Page 49 - TP_Pluse_V2.2_Class_6
P. 49
4. Short answer type questions.
a. What is cell reference?
______________________________________________________________________________
______________________________________________________________________________
b. Write the names of any two Date functions.
______________________________________________________________________________
c. What is absolute cell referencing?
______________________________________________________________________________
______________________________________________________________________________
d. What is the use of the SUM( ) function?
______________________________________________________________________________
5. Long answer type questions.
a. What are the Mathematical functions? Write the names of any two Mathematical functions.
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
b. What is the use of the LEN function? Explain with example.
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
c. Describe the ways to enter a formula.
______________________________________________________________________________
______________________________________________________________________________
d. What are the rules to enter a function?
______________________________________________________________________________
______________________________________________________________________________
6. Define the following functions:
a. SQRT() b. DAY() c. MOD() d. INT() e. MIN()
7. Competency-based/Application-based questions.
a. Nidhi has made a spreadsheet for the marks obtained by the students of her class in different
subjects. Which feature should she use to keep the spreadsheet updated if she has to change
marks in one of the subjects of any student?
Formulas and Functions in Excel 2016 47

