Electronic spreadsheet

Function

Data analysis

Data manipulation function

Presents data in

A

Cell reference

Chart

Row

Columns

Contains

Common formats

Data

Formula

General

Currency

B

Time

Fraction

Scientific

C cell reference

D cell reference

Mixed cell reference

After a cell is copied and pasted into another cell, the cell reference changes.

After a cell is copied and pasted into another cell, the cell reference does not change.

After a cell is copied and pasted into another cell, only part of the cell reference changes.

Cell formulae created by user to perform specific calculations

Logical functions

Text functions

E functions

Data and time functions

Statistical functions

The relationship between data

Sorting

F

Recording the record according to a specific criterion

Select and display the records meeting the criteria specific by a user

Pivot chart

H

What-if analysis

Allows user to

Tools

Try out different input values in a spreadsheet

Produce different outcomes for analysis

Scenario Manager

G

Summary tables of a given data table and extract useful information form the m

click to edit