Page 51 - Plus_V2.2_C6_Flipbook
P. 51
4. Short answer type questions.
a. What is cell reference?
______________________________________________________________________________
b. Write the names of any two Date functions.
______________________________________________________________________________
c. What is relative 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
fun Zone
Let's soLve
1. Application based question. Experiential Learning
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?
2. Solve the crossword using the clues. Critical Thinking
Down:
1. Cell address that is to be used in a calculation
2. Function used to display current date
4. Function used to add values in cells
6. Predefined formula in Excel
Across:
3. Symbols that specify calculations to be performed
Formulas and Functions in Excel 2016 49

