Cerritos Home Susan Fuschetto Home Susan Fuschetto Home Cerritos Home Campus Information Admissions Academic Resources Student Resources Administration Personnel Services Search Cerritos College Computer and Information Sciences rectangle Susan Fuschetto header

Susan Fuschetto
(page divider)

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.

  1. Read Chapter 4 pages 243 - 284.
  2. Do both of the hands-on exercises described on pages 243 - 284.
  3. Also, do Practice Exercise #4 pages 292 - 293.
  4. Online students:  Upload the chap4_ho2_band_solution and chap4_pe4_widget_solution files to the Excel 4 assignment on the class website.
  5. 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