electronic
spreadsheet

uses

function

can be included in

cell formulae created by users to perform specific calculations

such as

logical functions

text functions

mathematical funtions

date and time fuctions

statistical functions

can be used to create

chart

visualizes

the relationship between data

provides

data manipulation
function

includes

sorting

filtering

is a process of

is a function to

recording the records according
to a specific criterion

select and display the records
meeting the criteria specified by a
user

can be used for

data analysis

such as

pivot table

creates

summary tables for a given data table and
extract useful information from them

pivot chart

is

a graphical representation of a pivot table

what-if analysis

allows users to

try out different input values in a
spreadsheet

produce different outcomes for analysis

tools

Scenario Manager

Goal Seek

uses

cell reference

includes

absolute cell reference

mixed cell reference

relative cell reference

property

property

property

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 cell is copied and pasted
into another cell, only part of the
cell reference changes

click to edit

presents data in

basic storage unit

rows

columns

cell

contains

data

formula

common formats

date

time

currency

general

fraction

scientific