Page 31 - trackpad v5.1 class 6 flipbook
P. 31
21 st #Initiative
Self Reflection Century #Leadership & Responsibility
Skills
Your mother has been preparing a list of grocery items with their price. She has been manually
Self Reflection
calculating the total amount. Is there any function or formula that can help her make her task
easier? Do you think you should be helping people whenever you see an opportunity?
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 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
Formulas and Functions in Excel 2021 29

