Excel allows you to create spreadsheets much like paper ledgers that can perform
automatic calculations. Each Excel file is a workbook
that can hold many worksheets
The worksheet is a grid of columns
(designated by letters) and rows
numbers). The letters and numbers of the columns and rows (called labels
displayed in gray buttons across the top and left side of the worksheet. The intersection
of a column and a row is called a cell
. Each cell on the spreadsheet has a cell address
that is the column letter and the row number. Cells can contain either text, numbers, or
Adding and Renaming Worksheets
The worksheets in a workbook are accessible by clicking the worksheet tabs just above
the status bar. By default, three worksheets are included in each workbook. To add a
sheet, select Insert|Worksheet
from the menu bar. To rename the worksheet tab, rightclick
on the tab with the mouse and select Rename
from the shortcut menu. Type the
new name and press the ENTER
The Standard Toolbar
This toolbar is located just below the menu bar at the top of the screen and allows you
to quickly access basic Excel commands.
- Select File|New
from the menu bar, press CTRL+N
, or click the New
create a new workbook.
- Click File|Open
from the menu bar, press CTRL+O
, or click the Open
button to open an existing workbook.
- The first time you save a workbook, select File|Save As
and name the file. After
the file is named click File|Save
, or the Save button on the standard toolbar.
- Click the Print button to print the worksheet.
- This feature will allow you to preview the worksheet before it prints.