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