Image by Free Photos from Pixabay 
Exercises
Objective Type Questions
 Equal
 $ Dollar
 & (Ampersand)
 SUM
 formula
 B:D
 before
True/False
 True
 False
 True
 False
 True
 True
 True
 True
MCQs
 ii. 3
 i. Editing group
 iii. =
 iii. mixed
 iii. &
 iii.AutoSum
 i. insert function
 i. #REF!
Writing excel formulas and functions
Short answer questions (2/3 Marks):

 Using a formula
 Using an operator

 Consider above values for following:
 + : For addition, Ex. = A1 + B1 , output will be 12 + 45 = 57
 – : For substratcion, Ex. = B2 – A2, output will be 52 – 33 = 19
 * : For multiplication, Ex. = B3 * A3, output will be 45 * 20 = 900
 / : For division, Ex. = B3 / 3, output will be 45 / 3 = 15
 ^ : For power or exponent, Ex. = A1 ^ 3, output will 12 x 12 x 12 = 1728
 & : For joining the words, Ex. = A1 & B1, output will be 12 & 45 = 1245
 Absolute Cell referencing
 Relative Cell referencing
 Mixed Cell referencing
1. Absolute cell referencing:
This method is used to accept fixed value in ms excel formula calculation. When the user is using the formula and copy the same formula in another cell excel adjusts the value according to the cells used in a formula. So sometimes the user does not want to change the value of the referenced cell but user wants to use fix the value form the cell. In this scenario, absolute cell referencing is used. To use absolute referencing write $ in front of column name and row number.
Example, = $A$1 * $B$1
2. Relative cell referencing:
It changes or adjusts the cell value when a formula is copied from one cell to another. It is by default referencing method in MS Excel. User can use $ sign in front of column name only.
Example, = $A1 * $B1
3. Mixed cell referencing: It is a combination of both absolute and relative cell referencing.
Example, = $A1 * $B$1

 ######: This error is coming when the value of a cell is expanded beyond the column width. To solve this error increase the column width of a cell.
 #Div/0!: This error is coming when you divide any number with 0. Change the divisor as any other number than 0 for the solution.
 #Name?: This error is coming when a wrong formula is typed which is not available in excel. To solve this error find the mistake and write an appropriate formula.
 #Value!: This error is generally found in excel when the cell contains a different type of value such as actual numbers required in a formula but cell contains a text value. To solve this find the source and type the correct required type data.
 #REF!: This error is an error of wrong cell reference error. Enter the correct cell to solve this error.
 #NUM!: This is displayed when the formula contains an invalid number. Correct the value will solve the error.
Q 3 Explain some mathematical formulas used in excel with example.
S.No 
Formula 
Returns 
Example 
Answer 
1. 
abs() 
Absolute Value 
= abs(A1) 
19 
2. 
Sum() 
Sum 
= SUM(A1:D1) 
99 
3. 
Mod() 
Remainder 
= mod(c1,d1) 
18 
4. 
Power() 
Exponential or Power 
= power(d2,2) 
1296 
5. 
Round() 
Rounding upto specified digits 
= round(B2,2) 
45.00 