*SpreadSheet** Concepts*

*INTRODUCTION TO
SPREADSHEET*

l*ITS USES*

l*ITS BASIC
CONCEPTS*

l*ADVANTAGES
OF USING A SPREADSHEET*

l*FEATURES
OF A SPREADSHEET PROGRAM*

* *

*INTRO TO SPREADSHEET*

l*Before
spreadsheet*

–*use paper, pen and calculator*

–*Now use electronic spreadsheet
program e.g.*

–* Excel*

–*Lotus **1-2-3*

*WHAT IS A SPREADSHEET? *

u*has rows
numerically labeled (1 - 16384) & columns alphabetically labeled (A - IV)*

u*intersection
of a row & column is called a cell*

u*256
columns x 16,384 rows*

u*contains
a set of instructions that perform or make calculations*

*What is a spreadsheet
used for ?*

l*budgeting*

l* in
accounting*

̃*keep
petty cash records*

̃*analyse** payroll & other a/c records*

̃*interest
rate calculations*

̃*keep
small club/business accounts*

l*financial
analysis & What-If analysis*

l*building
business plans*

l*keeping
test results *

l*tracking
personal income & expenditure*

*Spreadsheet concept:
cell*

l*the cell
address is the location of a cell based on the intersection of a column and
row in a worksheet*

l*several
types of cell address :*

̃*relative** address eg. D5*

̃*absolute** address eg. $D$5*

̃*mixed** address eg. $D5*

*Spreadsheet concept:
cell information*

*3 types of info are contained in a cell*

u*label
(words, text or alphabets) *

u*value
(numbers, %, dates or currency)*

u*formula :
instruction to perform a calculation*

*Spreadsheet concept:
formula*

l*includes
1 or more mathematical operators*

* (+ , -, * , /,
^ )*

l*may use
other cell addresses *

l*can
contain 1 or more functions for making calculations*

l*A
function is a pre-programmed formula*

̃*SUM
function*

̃*AVG
function*

*Features of a
spreadsheet program*

¬*performs
simple calculations*

*has
built-in functions for complex calculation*

__Category of common built-in functions :__

̃*date
& time*

̃*financial eg**. PMT*

̃*logical eg IF*

̃*lookup** eg. VLOOKUP*

̃*mathematical
& trigonometry*

̃*statistical*

̃*text** eg. LOWER: change to
lower-case*

*Features of a
spreadsheet program..*

®*charting
data capabilities*

¯*has
limited database mgt. functions*

°*uses
macros to automate repetitive jobs*

±*performs
“What - IF” analysis*

²*linking
worksheets and creating summary reports*

³*has
worksheet formatting features*

*Advantages of Using a
Spreadsheet*

l*Automatic
recalculation*

l*Improves
productivity : easy to reformat and print*

l*Reduces
human errors : easy to copy formulae from cell to cell*

l*Aids in
decision-making : forecasts is easy & can do graph*

l*Data
becomes more “shareable”: with export/ import of info. from other pkg.*