Page 51 - TP_Plus_v4_Class6
P. 51
Double Tap Century #Technology Literacy
21 st
Skills #Productivity & Accountability
Write the output of the following:
a. =MIN (5,7,8) d. =TODAY()
b. =Left("Computer", 4) e. =LEN("Touch")
c. =AVERAGE(12,3,6) f. =COUNT(4,8,12)
Timeline
A cell reference is a cell address that can be used in a formula to denote a specific cell.
By default, all cell references are Relative references and makes the cells reference free.
If you wish to maintain the original references as they were, then you should make use of the absolute
references.
A mixed reference is a reference that is a combination of absolute and relative reference. It refers to
a specific row or column.
Functions are predefined formulas in Excel to perform both simple and complex calculations.
Operators are the symbols that specify what calculations to be performed.
Choose the correct option.
1. Which one of the following cell references can be included in relative reference?
a. A3 b. $A$4
c. A$1 d. $D6
2. Which of the following functions is used to calculate the average of a range of values?
a. Average b. SUM
c. AVG d. None of these
3. Which of the following options is known as the cell address in the formula?
a. Range b. Cell reference
c. Mixed reference d. None of these
4. Which of the following is called group of selected cells?
a. Selection b. Combination
c. Cell range d. None of these
5. Which of the following is not a component of chart?
a. Chart Title b. Data Series
c. Gridlines d. Formula
#Charts, Formulas and Functions in Excel 49

