Make your own free website on Tripod.com

SpreadSheet Concepts

 

INTRODUCTION TO SPREADSHEET

lITS USES

lITS BASIC CONCEPTS

lADVANTAGES OF USING A SPREADSHEET

lFEATURES OF A SPREADSHEET PROGRAM

 

INTRO TO SPREADSHEET

lBefore spreadsheet

use paper, pen and calculator

Now use electronic spreadsheet program e.g.

Excel

Lotus 1-2-3

 

WHAT IS A SPREADSHEET?

uhas rows numerically labeled (1 - 16384) & columns alphabetically labeled (A - IV)

uintersection of a row & column is called a cell

u256 columns x 16,384 rows

ucontains a set of instructions that perform or make calculations

 

What is a spreadsheet used for ?

lbudgeting

l in accounting

̃keep petty cash records

̃analyse payroll & other a/c records

̃interest rate calculations

̃keep small club/business accounts

lfinancial analysis & What-If analysis

lbuilding business plans

lkeeping test results

ltracking personal income & expenditure

Spreadsheet concept: cell

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

 

lseveral 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

ulabel (words, text or alphabets)

uvalue (numbers, %, dates or currency)

uformula : instruction to perform a calculation

Spreadsheet concept: formula

lincludes 1 or more mathematical operators

 (+ , -,  * ,  /, ^ )

lmay use other cell addresses

lcan contain 1 or more functions for making calculations

 

lA 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

lAutomatic recalculation

lImproves productivity : easy to reformat and print

lReduces human errors : easy to copy formulae from cell to cell

lAids in decision-making : forecasts is easy & can do graph

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