It’s now time to apply all that you have learned so far in this course.

It’s now time to apply all that you have learned so far in this course. For this assignment, you will edit a worksheet detailing the current inventory of special items at the Maryville bookstore.

To Get Started
Using the files below, follow the instructions to compare the data provided.

A Few Guidelines
You will need to submit an Excel file for your assignment – not another type of file.
The Excel file must allow me to see the formulas and functions used in order to qualify for credit. So if a question asks for the average body weight of the cars, and only the answer is provided and not the equation itself, full credit cannot be granted.
You can ask questions on this assignment in the discussion forum, but responses should provide direction not the answer themselves. (e.g. review the module on SumIf() function)
The work you submit must be your own. 0 credit will be earned if the work submitted is not your own.
Submit
Your submission must include:

Split data
All required formatting
Replaced text
COUNTIF function
IF function
Conditional formatting
Table with headers
Total row
Landscape orientation
When You Are Finished

When you upload your XLSX assignment file, be sure you keep it in the same format/structure as the original assignment file.
Be sure to add your last name to the assignment submission.
Important Note
Since there are multiple ways to accomplish goals in Excel, make sure you use the learning modules within the course to answer and solve these problems. To ensure full credit, you must demonstrate that you’re using the elements taught in the learning modules. Let me know if you have any questions about this.
Please do not wait until the last minute to ask questions. Ideally, students can work through this assignment while reviewing the learning modules.