Page 35 - Trackpad_ipro 4.1_Class8
P. 35
One Touch
One Learn Section A (Objective)
✓
A. Tick ( ) the correct option.
1. Which of the following cell references can be included in the relative reference?
a. A3 b. A$1
c. $A$4 d. $D6
2. Which of the following functions is used to calculate the average of a range of values?
a. AVERAGE b. AVG
c. SUM d. None of these
3. By what name is the cell address in the formula known as?
a. Range b. Mixed reference
c. Cell reference d. None of these
4. What is a group of selected cells called?
a. Selection b. Cell range
c. Combination d. None of these
5. Name the vertical axis that is used to plot the values.
a. Bar b. Value Axis
c. Data d. Formulas
6. Under which tab is the Sort & Filter command present?
a. Home tab b. Formula tab
c. Insert tab d. View tab
7. What can be sorted by using the Sort A to Z option?
a. Numbers b. Symbols
c. Text d. All of these
8. What does the NOW () function display?
a. Date b. Time
c. Both a and b d. None of these
Spreadsheet—Functions and Charts 33

