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