Page 61 - TP_Prime_v2.2_Class_6
P. 61
d. A group of selected cells is called ___________.
(i) Selection (ii) Combination
(iii) Cell range (iv) None of these
2. Write ‘T’ for true and ‘F’ for false.
a. Every formula begins with a + sign. ___________ FORMULAS AND FUNCTIONS IN EXCEL
b. Combined reference is a type of cell reference. ___________
c. The UPPER function is used to find the largest value in the given range. ___________
d. The LOWER function changes the given string into lowercase. ___________
e. The LEN function returns the length of the provided string. ___________
Evaluation Time
59
1. Fill in the blanks using the hints given below:
Functions, ABS(), equal, Dollar ($), square root
a. ___________ are predefined formulas in Excel.
b. Formulas in Excel begin with the ___________ sign.
c. The SQRT function returns the ___________ of the given number.
d. In Mixed Referencing, you can lock either a column or a row by preceding it with a
___________ symbol.
e. The ___________ function returns the absolute value of a given number.
2. Short answer type questions.
a. What is cell reference?
b. What is the use of the Text functions in Excel?
c. What will be the output of =TODAY() function?
3. Long answer type questions.
a. What is the use of the LEN function? Explain with example.
b. What are rules to enter a function?
c. What is the use of concatenate?
21 st #Information Literacy
Century
4. Competency-based/Application-based questions. Skills #Critical Thinking
a. Ridhi is trying to show grade A if average of marks come out to be more than
70 else she wishes to show grade B. Would you help her note down the functions she would
require to do her task.

