Page 15 - 2403_Trackpad_V5.1_C6_Fb
P. 15
e. Which one of the following cell references can be included in relative reference?
(i) A3 (ii) $A$4
(iii) A$1 (iv) SD6
2. Fill in the blanks using the words from the help box.
mouse, shift key, dollar($), True or False, Label, equal to
a. We cannot do mathematical calculations on __________.
b. A formula must always begin with an/a __________ sign.
c. We can select a range by using the __________ and by using the __________.
d. When two values are compared by using operators, the result is either __________.
e. In Mixed Referencing, you can lock either a column or a row by preceding it with a __________ symbol.
3. Think and answer.
a. What are formulas in Excel?
______________________________________________________________________________________
______________________________________________________________________________________
b. What is operator precedence?
______________________________________________________________________________________
______________________________________________________________________________________
c. What are the ways to enter a formula?
______________________________________________________________________________________
______________________________________________________________________________________
d. What is cell range? How can you select a cell range by using the mouse?
______________________________________________________________________________________
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
e. What is the way to make a cell reference as a mixed reference?
b. Which of the following is an arithmetic operator?
______________________________________________________________________________________
(i) ^ (ii) =
(iii) : (iv) <> ______________________________________________________________________________________
c. The cell address in the formula is known as __________ . ______________________________________________________________________________________
(i) Range (ii) Cell Reference
(iii) Mixed Reference (iv) None of these 4. Define the following functions:
d. A group of selected cells is called __________ . a. Arithmetic operators ________________________________________________________________
(i) Selection (ii) Combination ______________________________________________________________________________________
(iii) Cell range (iv) None of these
Formulas in Excel 2021 13

