Intermediate Excel XP
|Review of Excel Basics|
This module will cover the topics in the bulleted list below relating to Excel Basics. Complete each of the activities by following the steps enumerated in the yellow box. Some of the activities will be accompanied by demos to help you "see" the steps being performed before trying them yourself. At the end of this module, you will be given an assignment which you should complete and email as an attachment to firstname.lastname@example.org .
|Entering Data And Formatting a Worksheet|
|Activity 1: Entering
Data And Formatting a Worksheet
1. Open Excel to a New Blank Worksheet. Save as "review". Enter the Following Data:
2. Adjust the column widths and row heights as follows:
3. Align and format the data so that it resembles the above screen.
Use the text tool on the drawing toolbar
to create text boxes, and then add the text for
"purpose" and "Instructions" as it appears below.
Then, go to toolsàoptions
to remove the gridlines.
Finally, use the borders button on the formatting toolbar to
put borders around
in the summary area. Save your work.
The text box tool is located on the Drawing Toolbar. If this toolbar is not showing, go to View-> Toolbars and select it from the drop down list.
Back to Index
|Entering Simple Formulas|
|Activity 2: Entering
a formula in cell I 16 to calculate the gross revenue total for FY 93.
Extend that formula to calculate totals in cells I 17 through I 20.
(A simple way to calculate totals is to select the cell you want the
total to appear in, i.e. I 16, and click the AutoSum button on the
Toolbar. Then hit the Enter key).
|When using the AutoSum
button, be sure to check the range of cells that Excel thinks should be
included. In this case, you see that Excel for some reason left out the
amount in cell E 16.
A sure way to make sure Excel will perform the SUM operation on the cells you intend is to type the function in yourself. Type =SUM(E16:H16). Then hit the Enter key
To use the fill handle to find the totals in the other rows, place the mouse pointer on the fill handle of cell I 16. The pointer becomes a black plus sign.
Click and hold, then drag down the column.
When you release the mouse button, the formula is applied to the remaining rows.
Back to Index
|Activity 3: Formatting
Format the table in the summary area. First, format the table cell by cell using the formatting toolbar and the format menu. then, format the table using the AutoFormat option.
1. Select the range of cells you wish to format (i.e. a data table)
2. Go to FormatàAutoFormat and select the style you wish to apply.
3. Click the Options buttons to apply formatting to certain components only.
4. Click OK.
Back to Index
|Assignment 1 Due! Email the completed Excel document as an attachment to email@example.com .|
|You have now completed this module. Take a few minutes to review and practice what you have learned. If you are through for this session, close all programs, being sure to save any work. You may now begin the next module by clicking on the Back to Index link on this page and then clicking on the next module on the homepage of this course.|