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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- lesson 1 phrases and clauses answer key
- lesson 1 homework practice
- lesson 1 homework practice lines
- lesson 1 homework practice answers
- lesson 1 physical geography of china and mongolia
- chapter 2 lesson 1 quiz
- lesson 1 2
- lesson 1 planet earth
- lesson 1 physical geography of eastern europe
- lesson 1 1 power and exponents
- lesson 1 summary
- lesson 1 13