COMP APPLICATION 2 SAMPLEFullscreen Mode
SOFTWARE
A spreadsheet is used to carry out everything from simple addition to complex financial and statistical analyses. Spreadsheet programs can also help you create charts and graphs based on the data you’ve entered.
Types/Brand Names of Spreadsheet Software
Microsoft Excel
Microsoft Works Spreadsheet
Lotus 1-2-3
BASIC MS EXCEL SKILLS
Starting Up Microsoft Excel
1. Click on START, choose PROGRAMS and click on Microsoft Excel
2. You will see a white grid in front of you with rows of menus and icons at the top of the screen.
The Key Components of a Spreadsheet
1. Title Bar: The bar that displays the name of the spreadsheet you currently have open.
2. Name Box: The box that displays the address of the cell that you are presently on.
3. Formula Box: The bar where the contents of the cell are displayed.
4. Worksheet Tabs: These tabs allow you to switch from one worksheet to another. The standard spreadsheet contains three worksheets.
Note: Terms
Cell – a single worksheet division
Title Bar
Name Box
Formula Box
A Cell
Header – identities/addresses to column, rows and cells
Column*A,B,…+, Rows*1,2,…+ and Cell [A1]
Cells – headers are in terms of cell position within a column and a row [A1 is a cell within column A and row 1 and A5 is a cell within column A and row 5]
Reference – the act of accessing/using cell addresses especially in formulas and functions
Types of references
a) Single cell – addressing a single cell [i.e. A1]
b) Range of cell – addressing a group of cells [i.e. A1:A5- vertical,A1:F1 -horizontal]
Ways of referencing
a) Relative – in a formulae, reference to cells(s) are based on their position relative to the cell that contain the formulae
b) Absolute – the cell referred to is the same no matter which cell refers to it
Functions and formulas
Function – readymade/ predefined mathematical procedures, built into the program library to perform a series of operations on a specified range of values (i.e. average, sum, if etc. –
Average(A1:A5))
Formulae – user defined formulae (i.e. =A1+A2+A3)
Entering Data into a Spreadsheet
1. To enter data into a cell, simply click into the cell and type.
2. ACTIVITY:
a. Start in cell A1, and type “Day of the Week”. Press Enter, or click your mouse into cell A2 and type “Monday”. Continue down Column A until you’ve typed Monday
through Sunday.
b. Click on cell B1 and type “Customers”. Proceed to cells B2-B8 begin typing in the numbers: 20, 10, 30, 50, 60, 100, and 70.
EXCEL FORMULA AND FUNCTIONS
Entering a Formula into a Spreadsheet
