Exam #2
(20 points)

  1. Recreate two of the following three charts using Microsoft Excel. Depending upon which two charts you select, follow the requirements listed below. Recommendation: Complete Assignment #16 before starting this exam.

    Chart 1 - "Fresh Apple Market". Use any fruit other than an apple. For full credit, your fruit must be tiled or STACKed (not STRETCHed).


    Chart 2 - "Internet User Growth Worldwide".
    1. Add the titles "millions" and "Internet User Growth Worldwide"
    2. Change the scale on the Y axis (to increments of 30)
    3. Add data labels above the points
    4. Change the color on the points (rectangles)
    5. Remove all legends
    6. Remove all gridlines
    7. Insert a gradient fill from pink to white



    Chart 3 - "Revenue by Geographic Area". Enter different city names.


  2. Include your name at the top of the document.

  3. Save your work as "exam2.xlsx" when you are finished.

  4. Upload this file to YOUR-CLASS-WEBSITE.   Help



Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
1. Recreated two of the three charts above using Microsoft Excel. All specific requirements are met including such features as titles, legends, scales, gridlines, etc. 16 0 8 16 __/16
2. Values (numbers) are formatted correctly. Font size, style, and colors are used to enhance the appearance. The spreadsheet and chart have an excellent design and layout. 4 0 2 4 __/4
Total points __/20