Page 90 - PlusGPT_V2.1_C7_Flipbook
P. 90
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:
Functions, Equal to, Dollar ($), Statistical
a. are predefined formulas in Excel 2016.
b. Formulas in Excel 2016 begin with the sign.
c. functions calculates the maximum, minimum, average, etc.
d. In Mixed Referencing, you can lock either a column or a row by preceding it with a
symbol.
3. Answer the following:
a. What is cell reference?
_______________________________________________________________________________________
_______________________________________________________________________________________
b. What is the use of the PRODUCT() function?
_______________________________________________________________________________________
_______________________________________________________________________________________
c. What are date and time functions? Write the names of any two date and time functions.
_______________________________________________________________________________________
_______________________________________________________________________________________
88 Premium Edition-VII

