Page 31 - Trackpad_V5_Book 6
P. 31
Hashtag
#Operator: An operator is a symbol that is used to perform calculation
#Function: A predefined formula in Excel
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 error 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( )
Formulas and Functions in Excel 2021 29

