excel practice

Excel Assignment 1 is a data analytics and visualization assignment using Excel Pivot Tables and Charts. Please review the instructions and download the data file (salesdata2023.xlsx).

Two grading categories focus on the (1) accuracy of the pivot tables and charts and (2) professional formatting and presentation of your analysis in a visually meaningful way. It should be easy for anyone viewing the charts to interpret the data, see trends, etc. For example, a line chart is the best option to show sales trends over time. Please review the grading rubric for additional information on how the assignment is assessed. The grading scale is shown below.

The pivot table tutorials provide information on the basics of creating pivot tables and charts, and several online tutorials focus on design elements (click on the following link for an additional resource: The charts created for this assignment will be used to develop an interactive dashboard for Practice Exercise 4.

Grading Scale:

Exceeds Expectations (5-6 points)

Rubric Score =

6

Grade =

100

Rubric Score =

5

Grade =

90

Meets Expectations (5-7 points)

Rubric Score =

4

Grade =

80

Rubric Score =

3

Grade =

70

Does Not Meet Expectations (< 3 points)

Rubric Score =

<3

Grade =

50-60

× How can I help you?