Susan Fuschetto
CIS 151 Excel For I.T.
Excel Assignment 4 - Working with Large Worksheets and Tables
Notes:
In the hands-on exercise 1 steps there are a couple corrections.
Page 259, item g should read "Click in cell A28, click Breaks on the
Page Setup Group on the Page Layout Tab, and select Insert
Page Break. Same problem on page 260, item h.
For the practice exercise #4, page 293 there are missing steps.
After step e and before step f make sure you clear the print area (Page
Layout Tab, Print Area, Clear Print Area). This will prevent a
problem in step h. Also, after step g before step h make sure you
click the Employees worksheet. You are to do steps h and i on the
Employees worksheet. When you are done you should have 5 pages for
the Employees worksheet.
I hope these notes help.
- Read Chapter 4 pages 243 - 284.
- Do both of the hands-on exercises
described on pages 243 - 284.
- Also, do Practice Exercise #4 pages 292
- 293.
- Online students: Upload the
chap4_ho2_band_solution and
chap4_pe4_widget_solution files to the Excel 4
assignment on the class website.
- Traditional students:
During the lab time show the chap4_ho2_band_solution
and chap4_pe4_widget_solution files on
your computer screen to me.
Last update:
01/08/09 |
