WEEK 12-14 SREADSHEET

SPREADSHEET

Is a general-purpose electronic spreadsheet used to organize,

calculate, and analyze data. The task you can complete with Excel ranges from

preparing a simple family budget, preparing a purchase order, create an elaborate 3-D

chart, or managing a complex accounting ledger for a medium size business.

 ROWS AND COLUMNS:

SPREADSHEET BASICS:
You can get help from Excel in learning the parts of the spreadsheet. With the mouse pointer click on the
Help menu, scroll down and click on “What’s This?” The cursor will become a Question Mark and you can
click on any part of the toolbar to learn more about it. Using the Question Mark Cursor, find the Formula
Bar and click on it. Observe the difference between the cell contents and the Formula B
FORMULAR IN SREADSHEET
=SUM (D2:H2)
=COUNTA(B2:E2)
=MAX (F1:F4) 
=MIN(B4:B6)
=AVERAGE(T2:T4)
=RANK(B2,$B$2,:$B$11)
 =IF(D2="OFFICER",25%*E2,10%*E2)
=IF(B3="A",5,IF(B3="B+",4,IF(B3="B",3,IF(B3="C",2,IF(B3="D",1,0))))) 

READMORE