Page 37 - TP_iPlus_V2.1_Class8
P. 37
Excel provides a variety of different chart formats, such as Bar, Column, Pie, Line, Area,
Scatter.
Charts make it easier to draw comparisons, analyse growth and relationships among
the values.
Sorting of data refers to the process of arranging data in ascending or descending
order based on a certain criteria.
Exercise
Section A (Objective)
A. Tick (✓) the correct option.
1. Which of the following is the relative cell reference?
a. B3 b. $B3
c. &B3 d. $B$3
2. Which of the following functions is used to find the remainder after a number is
divided by the divisor?
a. PRODUCT b. MOD
c. SQRT d. POWER
3. What is the cell address in the formula known as?
a. Range b. Mixed reference
c. Cell reference d. None of these
4. What kind of functions can calculate interest on a loan?
a. Statistical function b. Financial function
c. Date and Time Function d. Mathematical Function
5. What is the horizontal axis that is used to plot the labels?
a. Bar b. Value Axis
c. Data d. Category Axis
6. Under which group is the Sort & Filter command present?
a. Styles b. Editing
c. Number d. Alignment
35
Spreadsheet—Functions and Charts

