Advanced Features of Spreadsheets

1. Perform the activities 9.1 to 9.2 (pp. 165-168 of the lab manual) and the exercise marked "On Your Own" on p. 169. Print the spreadsheet after Step 4 of the exercise marked "On Your Own" (p. 169).



2. Perform Activity 9.3 (pp. 169-171 of the lab manual) and print the spreadsheet after Step 7 on p. 171.



3. Perform the activities 9.4 to 9.5 (pp. 171-173 of the lab manual) and print the spreadsheet after Step 3 of Activity 9.5 (near the bottom of p. 173).



4. Perform Activity 9.6 (pp. 173-175) and the exercise marked "On Your Own" on p. 175. Print the spreadsheet after Step 2 on p. 175 (sorted based on the last names, in descending order).



5. Perform the activities 9.7 to 9.10 (pp. 175-183) and answer the Quick Check questions 4 and 5 on p. 184. Print out these two questions and your answers.



6. In the MS Works Word Processor, create and print a cover page for this assignment. Don't forget to type in a brief one-paragraph description of Assignment 10.



7. Turn in the cover page and the printouts, preferably, stapled together with the cover page on top.