|
|
|
Microsoft Excel
Basic In's
& Outs of the Program
Making a Gradebook
Lesson Plan Sheet
- Click the Start button in the lower-left corner.
- Position the mouse pointer on Programs.
- Click Microsoft Excel.
The Excel workbook contains screens called worksheets. The screens are numbered as sheet 1, sheet 2 and so on. This is the screen you will see when the program opens.
Moving around in the
Excel worksheet
There are a number of ways to move around in a worksheet. Moving from one cell to another in Excel is quick and easy. The ways to move from cell to cell include clicking a cell or using the Go To command, the scroll bars, the arrow keys, or the home, end, page up, and page down keys.
Moving within a window
1. To select any cell, click it. For example, click cell A1.
2. To move one cell to the right, press tab, or to move one cell to the left, press shift+tab.
3. To move one cell down, right, up, or left, use the arrow keys.
4. To move to the first column of the worksheet, press home.
Moving from window to window
1. To move one window down, press page down.
2. To move one window up, press page up.
3. To move to the uppermost-left cell, A1; press ctrl+home.
4. To move to any cell, on the Edit Menu, click Go To, and type J18 or any cell number.
5. Press ctrl+home to return to cell A1.
Creating an Excel workbook
There is a difference between a workbook and a
worksheet. A workbook can contain many worksheets. Each worksheet can contain up
to 256 columns across and 65,536 rows down.
Creating an Excel workbook
1. On the File menu, click New.
2. On the General tab, double-click Workbook to open a new one.
3. Click cell B2, and type Student List.
4. On the File menu, click Save, type Book 1, and click OK.
When you create a workbook, regardless of which method you use, you must save your work in a logical place on the computer. Just like filing a document in a file drawer, storing a computer document requires some attention to how you name the document and where you place it so you can easily find it again.
Unless you specify otherwise, Excel saves all workbooks to a default folder on your computer called My Documents.
Saving for the first time
When you save the file for the first time, you should name the file as
descriptively but as briefly as possible. Sometimes, you will want to name it as
a particular version, or as a type of workbook (i.e., Student Lists V.1.2).
Saving a new workbook
1. On the File menu, click Save.
2. Click the Save As arrow, and choose a location for your workbook.
3. In the File name box, type Student List.
4. To save the workbook, click Save.
Saving to a different name and folder or disk drive
1. Open
the file named Student List.
2. On the File menu, click Save As.
3. In the Save as dialog box, click Create New Folder.
4. In the Name box, type Student List First Semester.
5. Click OK, and click Save.
1. Click the Start button on the desktop, and then move the mouse pointer to Documents.
2. Click a file to open it.
3. On the File menu, click Close, to close the workbook.
While using Excel, you can open another workbook.
Opening an existing file with the menu bar
On the File menu, click Open or Press ctrl+o.
Double-click Book 1 (or any file you want to open).. or Select the file name, and click Open.
There are several ways to quit Excel. Always follow proper procedures, or your work may not be saved. All Office applications prompt you to save changes if you try to quit a program without saving your open workbooks.
Always quit the program before you turn off your computer.
Quitting Excel using the Exit command
With the file from the previous lesson open, click Exit on the File menu.
Click Yes if you want to save your workbook and quit Excel.
. or
Click No if you do not want to save the workbook for future use, but you do want to quit Excel.
. or .
Click Cancel if you do not want to close this workbook