excel workbooks

will be required to upload the two completed Excel workbooks that you saved at the end of Parts 1 and 2. 

The main grading criteria will be: 

Part 1:

  • Is the data saved correctly?

  • Is the data formatted correctly?

  • Has the data been cleaned correctly?

  • Has the workbook been saved correctly? 

Part 2:

  • Is the data formatted as a table? 

  • Are the AutoSum values correct? 

  • Has the correct pivot table been created and sorted? 

  • Has the pivot table been created two more times? 

  • Have the correct fields been used in pivot tables 2 and 3?

  • Has the workbook been saved correctly? 


Leave a Reply

Your email address will not be published. Required fields are marked *