Page 37 - iprime_V2.2_class8
P. 37
7. Which type of data can be sorted using the Sort A to Z option?
a. numbers c. text
b. symbols d. All of these
8. Which of the following does the NOW() function display?
a. date c. Both a and b
b. time d. None of these
9. The .......................... function is used to find the largest value in the given range.
a. MIN( ) c. MAX( )
b. LEN( ) d. AVERAGE( )
10. The .......................... function returns the square root of the given number.
a. MOD( ) c. INT( )
b. POWER( ) d. SQRT( )
B. Write ‘T’ for true and ‘F’ for false.
1. Every formula begins with a + sign. ..........................
2. Combined reference is a type of cell reference. ..........................
3. We cannot create a Bar Chart in Excel. ..........................
4. You cannot sort more than one column at a time in a selected
range of cells. ..........................
5. The Add Level button is available under the Insert tab. ..........................
6. Sorting can also be done through the Sort & Filter group under
the Data tab. ..........................
C. Fill in the blanks using the words given below:
Hints
Functions, equal, Dollar ($), square root, Custom Sort, column
1. .......................... are predefined formulas in Excel.
2. Formulas in Excel begin with the .......................... sign.
3. The SQRT function returns the.......................... of the given number.
4. The .......................... chart usually displays the data in the form of vertical bars.
5. In Mixed Referencing, you can lock either a column or a row by preceding it with a
.......................... sign.
6. .......................... is used when data is to be sorted on the basis of more than one criteria.
Spreadsheet—Functions and Charts 35

