Page 32 - Trackpad_V2.1_Class6
P. 32
REVISIT
▶ Any text entered in Excel is called a label.
▶ Any numeric data entered in Excel is called a value.
▶ To perform mathematical calculations, a formula is entered in a cell.
▶ A function is a predefined formula in Excel.
▶ Operators are the symbols that are used to perform calculations.
▶ A group of selected cells is called a cell range.
▶ A cell reference is a cell address that can be used in a formula to denote a specific cell.
1. Tick ( ) the correct option.
a. Which of the following is left-aligned by default?
(i) Values (ii) Labels
(iii) Formulas (iv) None of these
b. Which of the following is an arithmetic operator?
(i) ^ (ii) =
(iii) : (iv) <>
c. Which of the following errors occurs when the formula contains an invalid operation?
(i) #VALUE! (ii) NUM!
(iii) REF! (iv) #NAME?
d. Which of the following functions finds the specified number of values from a given set of values?
(i) COUNT ( ) (ii) SUM ( )
(iii) MAX ( ) (iv) Both (i) & (ii)
e. Which function returns the square root of the given number?
(i) MOD( ) (ii) INT( )
(iii) POWER( ) (iv) SQRT( )
2. Fill in the blanks using the words from the help box.
cell reference, LEN, function, Label, equal to
a. We cannot do mathematical calculations on __________.
b. A formula must always begin with an/a __________ sign.
c. __________ is used in a formula to denote a specific cell.
d. A __________ is a predefined formula in Excel.
e. The __________ function is used to get the length of the string.
30 Trackpad (V2.1)-VI

