Page 36 - iPlus_Ver_2.0_class_8
P. 36
To Sum Up
Excel allows users to create custom formulas to perform calculations on their data.
Excel also contains built-in formulas called functions that make it easy to perform
common calculations on data.
A group of selected cells is called a range.
A cell reference refers to a cell or a range of cells on a worksheet that can be used to
find the values or data.
Functions are predefined formulas in Excel to perform both simple and complex
calculations.
A chart is a visual or graphical representation of data from a worksheet which is very
useful for instant analysis and decision making.
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 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. What is the cell address in the formula known as?
a. Range b. Mixed reference
c. Cell reference d. None of these
34
iPlus (Ver. 2.0)-VIII

