ch-2 formulas and functions in MS Excel

Ch – 2
FORMULAS AND FUNCTIONS IN MICROSOFT EXCEL 2010
Short answer type questions:
Q1. Write the general rules for writing a formula in MS excel.
Ans1. Rules for writing a formula in MS excel are:
1.       Every formula in Excel must begin with an ‘=’ sign.
2.       Arithmetic operator should be used for operating on numbers or data.
3.       The data can be a cell address also.
Q2. What do you mean by constant value?
Ans2. Constant values are the values which are directly entered in the cell. They consist of
text, numerals, alpha numerals etc.
Q3. What are formulas?
Ans3. A formula is an expression that tells which mathematical operation has to be
performed on a specific value. Example: =A1+A2+A3 is a formula to calculate the sum.
Q4. Define functions.
Ans4. Functions are the predefined formulas in Excel that are used to perform various
calculations in a worksheet. Example: COUNT, SUM, MAX, MIN etc. are some of the
formulas in Excel.
Q5. Explain CONCATENATE function by giving examples.
Ans5. It joins several text items into one text item.
Long answer type questions:
Q1. What are operators? Explain its types.
Ans1. Operators are symbols used in a formula to define the relationship between two
Or more values. There are two types of operators namely:
1.       Arithmetic operators:- used to do arithmetic calculations.eg: +,-,*,/,%,^.
2.       Comparison operator:- used to compare two or more than two numbers. Eg: =,>,<,>=,<=.
Q2. Write about the functions given below:
1)      CODE function: - returns a numeric code for the first character in a text string.
2)      LEFT function: - returns the leftmost characters from a text value.
3)      PROPER function: - capitalizes the first letter in each word of a text value.
4)      SUBSTITUTE function: - substitutes new text for old in a text string.
Q3. Explain any four errors that occur in MS Excel worksheet formulas.
Ans. The errors that occur in MS Excel are:-
1.       Value error:- when we use text to a function which accepts numbers.
A
1.
5
2.
4
3.
ABC
4.
#Value!
2.       Name error:- when a formula or a name is misspelled.
A
1.
5
2.
4
3.
7
4.
#Name?



The cell A3 is misspelled as AG.
    3. Division error:- when the value is divided by zero.
A
1.
5
2.

3.
#Div/0!



The formula applied is(=A1/A2)

4)) Cell error:- because the cell is too narrow to display the result.
A
1.
15669836
2.
15698544
3.
58993671
4.
# # # # #




Comments

  1. Saas Financial Model7 September 2018 at 08:13

    Great tutorials on excel functions especially to those who doesn't able to use the MS Excel 2010. This gives a lot of perspectives in excel learning, thus it also gives some significant terms for the SaaS Financial Model which is useful in financial modeling.

    ReplyDelete

Post a Comment

Popular posts from this blog

ch-6 QBASIC

Ch-6 QBASIC Short answer type questions:- Q1. Write the purpose and syntax of the following statements: a)       CLS         b) LET    c) INPUT               d) END ANS1. Statement Syntax Purpose 1.CLS CLS It clears the screen. 2.LET LET<variable>=<constants> To assign a value to a variable. 3.END END It ends the program permanently. It can be used only once at the end of the program. 4.INPUT INPUT<variable> To accept a value for the variable. Q2. What is elseif? Explain. Ans2. The command allows us to perform a secondary action if the first expression mentioned with the IF statement was ...
Read more

ch-10

Chapter 10 Internet Short Answer Type questions :- Q1. Write the use of internet in the field of education . Ans. Internet provides us number of books , reference books , online help centre ,expert’s views and other study materials that has made the learning process easy. There are lot of websites from where we can gain a lot of knowledge . Q2. Write a short note on ‘Picasa web albums ‘. Ans . The Picasa web Albums is Google’s photo sharing site ,where we can upload photos. A free picasa account gives us 1 GB of storage space. Q3.What is Social Networking? Ans. It is a service on the internet that enables us to connect with people who share the interests Q4. What do you know about ‘Entertainment on web ‘? Ans. The internet provides us many sources of entertainment . we can download music ,tune into Internet – based radio stations .we can see the photos of people sharing on the internet , videos ,watch movies on YouTube etc . Q5.What do you know about WhatsApp ? ...
Read more

ch-1 computer peripherals

Image
Class VII Chapter 1                              Computer Peripherals G. Short answer type questions:- 1. What is an Operating System ? Ans. An Operating System is the software that manages the computer’s resources and executes application programs. 2. What do you mean by Peripheral devices ? Ans. Peripheral devices are defined as auxiliary   devices   such as a computer mouse or keyboard that connects to and works with the computer in some way. Other examples are microphones, loudspeakers, webcams, and digital cameras. 3. What is a scan code ? Ans. When any key from the keyboard is pressed , the microprocessor generates a number called the Scan Code. 4. What is a Hard Copy ? Ans. The output given by a printer is called as a hard copy . 5.Write a short note on Line Printer ? Ans. Line printers produce output by pr...
Read more