Page 50 - Plus_V2.2_C6_Flipbook
P. 50
test Your skiLLs
1. Tick ( ) the correct option.
a. Which one of the following cell references can be included in relative reference?
(i) A3 (ii) $A$4
(iii) A$1 (iv) $D6
b. Which of the following functions is used to calculate the average of a range of values?
(i) Average (ii) SUM
(iii) AVG (iv) None of these
c. The cell address in the formula is known as ____________.
(i) Range (ii) Cell reference
(iii) Mixed reference (iv) None of these
d. A group of selected cells is called ____________.
(i) Selection (ii) Combination
(iii) Cell range (iv) None of these
e. The ____________ function returns the square root of the given number.
(i) MOD( ) (ii) INT( )
(iii) POWER( ) (iv) SQRT( )
2. Write ‘T’ for True and ‘F’ for False.
a. Every function begins with a + sign. ____________
b. Combined reference is a type of cell reference. ____________
c. The NOW( ) function is used to display the current date. ____________
d. Excel does not provide functions for working on textual content. ____________
e. The MAX( ) function returns the largest value from a set of values. ____________
3. Fill in the blanks using the words from the help box.
equal, square root, Functions, MIN(), dollar($)
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 smallest value.
48 Premium Edition-VI

