Page 78 - TechPluse_C6_Flipbook
P. 78
Checkpoint
A. Tick ( ) the correct option.
1. Which of the following cell references can be included in absolute reference?
a. K13 c. $K$13
b. K$13 d. $K13
2. Which one of these functions is used to calculate the average of a range of values?
a. AVERAGE ( ) c. SUM ( )
b. AVG ( ) d. None of these
3. What is the cell address in the formula known as?
a. Range c. Cell reference
b. Mixed reference d. None of these
4. Which of the following functions is used to find remainder after dividing two numbers?
a. LEN() c. MOD()
b. CONCATENATE() d. MAX()
5. In the .......................... chart, bars are placed horizontally.
a. Bar c. Column
b. Area d. Line
6. Function name must be followed by opening and closing ...........................
a. Parenthesis c. Curly Brackets
b. Angular Brackets d. Square Brackets
B. Fill in the blanks using the words given below:
Hints
functions, equal, dollar ($), square root, column
1. ...................... are predefined formulas in LibreOffice Calc.
2. Formulas in LibreOffice Calc begin with an ...................... 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
...................... symbol.
76 Premium Edition-VI

