Chapter 20 Data Analysis

•Formula & Function

•Range

•Cell

•Columns

•Rows

Arithmetic or mathematical operations
are carried out on cells.

• Range

• Cell

• Columns

• Rows

a group of cells in a spreadsheet that
consist of more than one row and
column and where the cells are all
adjacent to each other

• Cell

• Columns

• Rows

the small rectangular sections on
spreadsheets used to enter data such
as text, numbers or symbols and to
perform calculations using formulas
and functions

• Columns

• Rows

make up of cells that are adjacent to
each other and go from top to bottom
or top vertically

•Rows

made up of cells that are adjacent to
each other and go from left to right or
right to left horizontally.

Create a model similar to the one in Figure 20.01 which will grade the marks that students attain in their tests throughout the term and produce a comment about their final result.

Insert a few of your friends' names and enter marks (dummy data) for them for the ten weeks

Insert a column for the Percentage next to the "wk10" column.

The SUM function adds up all the numbers which are listed in the row or column

Insert a column for the Total next to the "Percentage" column.

The AVERAGE function works in a similar way to SUM, except that it works out the average of the numbers in the listed range of cells

The MAXIMUM and MINIMUM functions will give you the highest and the lowest numbers in a range of numbers.

The COUNT function is used to count the number of data entries in a range of cells

Using the IF function for grade

=IF(O4>=80,"A",IF(O4>=70,"B",IF(O4>=60,"C",IF(O4>=50,"D",IF(O4>=40,"E",F)))))