Components of a Spreadsheet

Blank Spreadsheet

A spreadsheet work area is split into lots of different things, you still have the common menus and commands that feature in all productivity programs, but you will also have some extra ones just for spreadsheets. These will help you insert graphs and do calculations.

When you look at the spreadsheet work area you will notice it has lots of lines drawn up and down the work area. Each line up represents a column. Each line across represents a row. Where a row and a column meet in a little square is called a cell. Each cell can contain text, numbers or formulas (calculations). A cell address is made up from the column letter and the row number for example a cell address of C3 is in the 3rd column in row 3.

A spreadsheet can have more than one work area, these are called worksheets, so you can have several in one spreadsheet. Each worksheet is indicated by a tab at the bottom of the page named sheet 1, sheet 2 – you can give each worksheet its own name if you need to.

Spreadsheet Tabs

A spreadsheet also has some extra areas – these are for performing calculations called a formula bar at the top of the work area. It starts with fx. You can do all kinds of formulas inside that box, but you always start a formula with an equals sign = and then whatever calculation you are doing, for example, =A1+B1

Remember you still have your scroll bars for moving up and down and your status bar along the bottom of the work area telling you about the worksheet you are using.

Next: Entering Data