Word Lesson 1



| | | |

|Points earned |Excel Assignment #2 - Exercises |What to print and submit |

|(Points | | |

|possible in | | |

|parenthesis) | | |

| |Review Chapter 3 in your book | |

| |Review Chapter 3 Objectives and Key Terms (Pages 218-219) | |

| |Review Chapter 4, Pages 229-278 (Freeze/Unfreeze Panes, Page Breaks, Print Areas, Print Worksheet Titles, Change | |

| |Page Order, Naming Ranges, Adding Tables, Adding/Deleting Records, Styles, Sorting, Filtering, Total Row, | |

| |Conditional Formatting) | |

| |Review Chapter 4 Objectives and Key Terms (Page 275) | |

| |This assignment doesn’t cover Chapter 5, however, review Pages 297-330 (Pivot Tables, Pivot Charts) – we’ll begin| |

| |looking at those skills soon. | |

| | | |

| |This content may appear on test 2 (test 2 is cumulative). | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | | |

| | |Print: |

| | |As indicated in the column |

| | |to the left. |

| | |Attach to this cover sheet |

| | |in the order listed. |

|(1.5) |Complete Multiple Choice Questions, Page 220 | |

| |Key answers in Excel. | |

| |Indicate question number and your answer. | |

| |Apply unique appearance settings from the Home Tab: | |

| |Use unique font faces, font sizes, cell shading, and cell borders. | |

| |Print and attach to this sheet. | |

|(1.5) |Complete Chart Basics, Pages 192-196 | |

| |Follow the instructions carefully. | |

| |Print the worksheet(s) (fit to one page) after the last step. | |

| |Show formulas, and print the worksheet(s) (fit to one page). | |

|(1.5) |Complete Chart Design, Pages 202-206 | |

| |Follow the instructions carefully. | |

| |Print the worksheet(s) (fit to one page) after the last step. | |

| |Show formulas, and print the worksheet(s) (fit to one page). | |

| |Also, print as indicated in Step 6, Page 206. | |

|(1.5) |Complete Chart Layout, Pages 213-217 | |

| |Follow the instructions carefully. | |

| |Print the worksheet(s) (fit to one page) after the last step. | |

| |Show formulas, and print the worksheet(s) (fit to one page). | |

|(3) |Complete Box Office Movie Data, Page 228 | |

| |Follow the instructions carefully (there are many details). | |

| |Spend a lot of time experimenting with appearance and overall design. | |

| |Add footer by going to: Insert tab / Text group / Header & Footer command. | |

| |Add text box by going to: Insert tab / Text group / Text Box | |

| |Print the worksheets (fit to one page) – you choose if the pages should be portrait or landscape orientation. | |

|(6) |Excel Table and Charts for Your Small Business (Not in Book) | |

| |This exercise is graded by letter grade… A+, A, A-, B+, etc. | |

| |Use Your Imagination: Develop a workbook that contains fictitious data about your small business, calculations, | |

| |a pie chart, and another type of chart. | |

| |The data may be about profit over the last several years, sales figures, specific employee sales, expenses, etc. | |

| |– you come up with the approach, perform calculations, then create a pie chart and another type of chart based | |

| |upon the data. Use at least two worksheets to spread out the information. | |

| |The workbook must make use of the following features: | |

| |Excel Tables, SUM, MIN, MAX, AVERAGE, CONCATENATE (the actual function), IF Function, Conditional Formatting. | |

| |Include titles and labels throughout the workbook so it can easily be understood. | |

| |Print the worksheets (fit to one page). | |

| |Show formulas, and print the worksheets (fit to one page). | |

|(15) | | |

-----------------------

Due Tuesday 11/13 - Beginning of Class

• Make sure all files are printed before class begins.

• See me before class, if possible, if you have any questions about the assignment.

• Data files are available on the CD that came with your book, and the course web site.

Name:

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download