Peer$-$graded Assignment: Final Assignment $-$ Part $3$: Submit Your Work and Peer Review

DeadlineFeb $25,11$:$59$ PM PST

Ready for the assignment?

You will find instructions below to submit.

$1.$ Instructions

$2.$ My submission

$3.$ Discussions

By now you should have completed both parts of this final assignment. In this part, Part $3$ of the final assignment, you will submit the two Excel spreadsheets that you saved at the end of Parts $1$ and $2$ for grading, and grade your peers on their submissions.

Grading Criteria Overview

For your assignment to be graded in a subsequent step in the course, you 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?

You$$will not be judged$$on:

$$ Your English language, including spelling or grammatical mistakes.

$$ The content of any text or image$($s$)$ or where a link is hyperlinked to$.$

To submit your assignment, click on the $"$My Submissions" Tab at the top of this page.

Peer$-$graded Assignment: Final Assignment $-$ Part $3$: Submit Your Work and Peer Review

DeadlineFeb $25,11$:$59$ PM PST

Ready for the assignment?

You will find instructions below to submit.

$1.$ Instructions

$2.$ My submission

$3.$ Discussions

Project Title $*$

Upload the completed Excel file named Montgomery$\_$Fleet$\_$Equipment$\_$Inventory$\_$FA$\_$PART$\_1\_$END.XLSX that you saved in Task $8$ in Part $1$ of the final assignment.

Upload File

Part $1$ Task $3$: Have you used the Filter feature to look for blanks and remove all empty rows from the data? Yes$/$No

Enter text here

Your answer needs to be a little bit longer. Write a few sentences to complete your assignment.

Part $1$ Task $4$: Have you used either the Conditional Formatting or Remove Duplicates feature to look for and remove any duplicated records from the data? Yes$/$No

Enter text here

Your answer needs to be a little bit longer. Write a few sentences to complete your assignment.

Part $1$ Task $5$: Have you checked for spelling mistakes in the data and fixed them? Yes$/$No

Enter text here

Your answer needs to be a little bit longer. Write a few sentences to complete your assignment.

Part $1$ Task $6$: Have you used the Find and Replace feature to remove all double$-$spaces from the data? Yes$/$No

Enter text here

Your answer needs to be a little bit longer. Write a few sentences to complete your assignment.

Part $1$ Task $7$: Have you used Flash Fill to reduce the department names to just one column, and then removed any unnecessary columns? Yes$/$No

Enter text here

Your answer needs to be a little bit longer. Write a few sentences to complete your assignment.

Part $1$ Task $2$: Have you widened all columns so that all the data is visible? Yes$/$No

Enter text here

Your answer needs to be a little bit longer. Write a few sentences to complete your assignment.

Upload the completed Excel file named Montgomery$\_$Fleet$\_$Equipment$\_$Inventory$\_$FA$\_$PART$\_2\_$END.XLSX that you saved in Task $7$ in Part $2$ of the final assignment.

Upload File

Part $2$ Task $1$: Have you used the Format as Table option to format the data as a table? Yes$/$No

Enter text here

Your answer needs to be a little bit longer. Write a few sentences to complete your assignment.

Part $2$ Task $2$: Have you used AutoSum to find the following values for column C and recorded each of the values? Record the five values below.

SUM

AVERAGE

MIN

MAX

COUNT

Enter text here

Your answer needs to be a little bit longer. Write a few sentences to complete your assignment.

Part $2$ Task $3$: Have you used the PivotTable feature to create a pivot table that displays the Department field in the Rows section, and the Equipment Count in the Values section, so that the pivot table displays the sum of equipment count by department? Yes$/$No

Enter text here

Your answer needs to be a little bit longer. Write a few sentences to complete your assignment.

Part $2$ Task $4$: Have you used the $$Sort By Value$$ setting on the pivot table to sort it in descending order by the sum of equipment count? Yes$/$No

Enter text here

Your answer needs to be a little bit longer. Write a few sentences to complete your assignment.

Part $2$ Task $5$: Have you followed the same steps you performed in Part $2-$ Tasks $3$ and $4$ to create two more identical pivot tables so that you end up with $3$ worksheets that contain identical pivot tables? Yes$/$No

Enter text here

Your answer needs to be a little bit longer. Write a few sentences to complete your assignment.

Part $2$ Task $6$a: Have you used the PivotTable Fields pane to manipulate and analyze data in pivot table $2?$ In pivot table $2$ have you added the Equipment Class field