Page 33 - KEC Khaitan C6 Flipbook
P. 33
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 considered a label in Excel?
(i) 123 (ii) A1+B2
(iii) Name (iv) 45.67
b. Which symbol is used to start a formula in Excel?
(i) $ (ii) @
(iii) # (iv) =
c. What type of operator is the colon (:) in Excel?
(i) Arithmetic (ii) Comparison
(iii) Reference (iv) Logical
d. Which function will you use to find the highest value in a range of cells?
(i) SUM (ii) AVERAGE
(iii) MAX (iv) MIN
e. Which of the following errors indicates division by zero?
(i) #VALUE! (ii) #NAME?
(iii) #DIV/0! (iv) #REF!
2. Write the Output of the following Excel Functions:
a. =SUM(10, 20, 30)
______________________________________________________________________________________
b. =PRODUCT(5, 4, 3)
______________________________________________________________________________________
c. =POWER(2, 3)
______________________________________________________________________________________
Formulas and Functions in Excel 2021 31

