Activity Four October 12th/13th 10
points
Due: 11:59 p.m. Tuesday, October 18th for MW sections
11:59 p.m. Wednesday, October 19th for TR sections
Remember: the quiz covering Excel is October 17th/18th
The purpose of this activity is to add to an Excel workbook using features you have used
in previous activities, learn some more, and create an embedded chart.
1. Open the file you used for activity 3.
2. Save the file using the Save As option (from File on the menu bar) as “Act4_lab
section number_ last name” in your Home memory in ONID and remember to save
after every change (at least often!).
3. Use the unused worksheet in this workbook to enter your anticipated expenses for
next term. Change the label on the sheet to Winter Term.
4. Type an appropriate title in cell A1 and if you think a subtitle is necessary, type that
in cell A2.
5. Starting in cell A4 and going down the column (so you are entering row headings),
enter at least 5 different expense categories (use what you have on the other sheet, fall
term, if you want to).
6. Type January in cell B3 and use the fill feature to add February and March in cells C3
and D3 (column headings).
7. Add numbers to your expense categories for all three months. Total each category
(across the row) and each month (down the column), along with the totals row and
column (where they intersect, the “total of the totals”).
8. Format the worksheet for ease of readability. Remember what the data is (expenses)
when choosing how to display your numbers (what style should they be?). Consider
using the AutoFormat feature found under Format in the menu bar.
9. Create an embedded column chart for your expenses each month. Embedded means
that the chart will appear on the sheet with the data instead on a sheet of its own (like
the pie chart). You can choose any of the chart sub-types. DO NOT include totals in
your chart but DO include the row and column headings (these become the legend
and x-axis labels in your chart). Include a title for your chart.
