Page 32 - Chinmaya_C6_flipbook
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 are 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 is not recognised by Excel?
(i) #VALUE! (ii) NUM!
(iii) REF! (iv) #NAME?
d. Which of the following functions returns the count of the number of values in the selected range?
(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 don't perform mathematical calculations on __________.
b. A formula must always begin with an/a __________ sign.
30 Premium Edition-VI

