Back to Assignments page

CS110: Intro to Computers

Name:____________________________________

Lab Exercise 6: Formatting Excel Worksheets

Due Date: Monday, October 21, 2002

 

 

Task 1: Hands-On Exercises

  1. Copy the Lab File, “Grade Book.xls”, from my Assignments web page or from the “Student Data Disk” sub-folder tree, on the local drive of the classroom PC, to a diskette.

 

  1. Do Hands-On Exercise 2, pages 23-32, from the Microsoft Excel, Chapter 1: Introduction to Microsoft Excel section of the lab book. Print out 2 separate copies of the exercise, as explained in the text, & attach to this sheet.

 

  1. Do Hands-On Exercise 1, pages 47-52, from the Microsoft Excel, Chapter 2: Gaining Proficiency section of the lab book. You do not need to print this version of the spreadsheet. It is used as a starting point for the next exercise.

 

  1. Do Hands-On Exercise 2, pages 59-67, from the Microsoft Excel, Chapter 2: Gaining Proficiency section of the lab book. Print out 2 separate copies of the exercise, as explained in the text, & attach to this sheet.

 

Task 2: Be sure to read or review the following pages in the Microsoft Excel section of the Lab/Office 2000 book:

  1. Chapter 1 “Introduction to Microsoft Excel”.
    1. Read pages 6-7.
    2. Review pages 7-10. (You should see a lot of similarities with Word).
    3. Read pages 19-23. (Note: page setup options that are specific to Excel).

                                                               i.      Also note Tip boxes on page 29 & 32.

  1. Chapter 2 “Gaining Proficiency”
    1. Read pages 42-46.
    2. Read pages 53-59.

 

Task 3: Review the few pages on “Spreadsheets” in the Concepts/Lecture book, Chapter 3C.

Back to Assignments page