Theme Colors B.
Standard Colors
State True or False:
Formulas must begin with the question mark (?).
In Absolute Referencing, the relative position of rows and columns changes where you copy
a formula.
Recent Colors
No Color
More Colors
anging colour
3.
In Absolute Referencing, '$' sign is used before the cell co-ordinates.
Tab
POD AD
4.
Arange can be used in a formula.
Functions
5.
The error #VALUE occurs if the number is divided by a zero.
C.
1.
Application Based Questions:
A Sports teacher has measured the height of the students in a class. Saumya has been given the assignment to
find the maximum and minimum height from the collected data. Suggest the function, which she should use to
accomplish the task.
2.
Ms Priya and her friends got a raise of 10% in their salaries. Find the total amount if their present salary is
*15,000. Calculate the salary by using the formula.
ption