Susan Fuschetto

CIS 151 Excel For I.T.
Excel Assignment 5 - Data to Information
Notes:
In the hands-on exercise 2 steps there are a couple corrections.
Page 332, item f should read "... cells D3:D14." not through
D16. Same problem on page 333, item b, and page 336, item a.
On page 336, item e be sure to format it left aligned and no fill.
On page 337, items a and d be sure to bold the labels. Page 339,
item d the average salary of all employees should be $52,462. Page
357, item f be sure to switch back to Excel before doing the step.
For the practice exercise #3, page 366, item e, the first sentence
should be "Click G4, not E4." And in the second sentence it should
be "Click E4, not F4." Item f, first bullet where it says A25:E25
it should be A25:E26. Also, item i, first bullet it may be easier
just to do the following steps: Page Layout Tab, Page Setup
dialogue box launcher, Header/Footer Tab, Custom Footer.
For the practice exercise #4, page 368, step g can be tricky.
Select the cells E4:E8 which is the Sophomore column, then point to the
edge of the selection and then drag it left. You will see a
vertical bar as you drag. Drag the bar between columns B and C.
Release the mouse. The goal is to have the classes in the correct
order moving left to right: Freshman, Sophomore, Junior, then
Senior. Widen the C column so that the heading Sophomore is not
wrapped around in the cell.
I hope these notes help.
- Read Chapter 5 pages 303 - 357.
- Do all three hands-on exercises
described on pages 303 - 357.
- Do Practice Exercise #3 pages 365
- 366.
- Do Practice Exercise #4 pages 367
- 368.
- Online students: Upload the
chap5_ho2_hremployee_solution, chap5_ho3_salesrep_solution,
chap5_pe3_scholarship_solution, and chap5_pe4_exscholarship_solution files to
the Excel 5 assignment on the class website.
- Traditional students:
During the lab time show the
chap5_ho2_hremployee_solution, chap5_ho3_salesrep_solution,
chap5_pe3_scholarship_solution, and
chap5_pe4_exscholarship_solution files
on your computer screen to me.
Last update:
08/26/08 |