Page 90 - 2619_PlusGPT V2.1_C-7

test Your skiLLs

1. Tick ( ) the correct option.
a. Which of the following cell references can not be included in relative reference?

(i) $A$4 (ii) A1

(iii) D6 (iv) B3
b. Which of the following functions is used to calculate the average of a range of values?

(i) AVERAGE (ii) SUM

(iii) AVG (iv) INT
c. What is the cell address in a formula called?

(i) Range (ii) Cell reference

(iii) Mixed reference (iv) Formula

d. What is a group of selected cells called?
(i) Selection (ii) Combination

(iii) Cell range (iv) Cell reference

2. Fill in the blanks using the words given below:

Cell reference, Formulas, Functions, Referenced

a. always start with an equal to (=) sign.

b. If you change the value in the cell, the result of the formula will automatically
update.
c. A is like the address of a cell in Google Sheets.

d. are predefined formulas in Google Sheets.
3. Answer the following:

a. What is cell reference?
_____________________________________________________________________________________________

_____________________________________________________________________________________________

b. What is the use of the PRODUCT() function?
_____________________________________________________________________________________________

_____________________________________________________________________________________________

c. What are the rules to enter a function?
_____________________________________________________________________________________________

_____________________________________________________________________________________________

88 Premium Edition-VII