Project Description:
In this project, you will create table to meet objectives 3.1 through 3.3 of the Excel MOS Associate exam. To complete the project, you will create and format tables 3.1, modify tables 3.2, and filter and sort table data 3.3. Note: These projects are created for PC users since the MOS Exam is completed in the PC user environment.
Grader – Instructions Excel 2019 Project
MOS19_XL_PROJ3_Equipment
Project Description:
In this project, you will create table to meet objectives 3.1 through 3.3 of the Excel MOS Associate exam. To complete the project, you will create and format tables 3.1, modify tables 3.2, and filter and sort table data 3.3.
Note: These projects are created for PC users since the MOS Exam is completed in the PC user environment.
Steps to Perform:
Step
Instructions
Points Possible
1
Start Excel. Download and open the file named Student_MOS19_XL_PROJ3_Equipment.xlsx. Save the file as Last_First_MOS19_XL_PROJ3_Equipment.
0
2
On the Equipment worksheet find and remove the duplicate record in the Item column. Copy the Equipment worksheet, and create a new worksheet at the end with the name Safety.
10
3
On the Safety worksheet, format the range A4:G64 as an Excel table. Verify the table has headers and apply the Teal, Table Style Medium 18.
18
4
Remove the table row 5. Apply the First Column Table Style Option.
13
5
Insert a Total Row. Count the Items and determine the Maximum item cost.
15
6
Use the filter arrows in the header row of the table to sort the Item column in ascending order, and then sort the Stock Level column by font color so that all items that need to be ordered appear at the top of the list. Do not create a multi-level sort.
12
7
Filter the table data by Category to show only the Safety Equipment inventory data.
12
8
Copy the Safety worksheet, and create a new worksheet at the end with the name Order.
8
9
On the Safety worksheet convert the table to a normal range.
12
10
Ensure the worksheets are in the following order: Equipment, Safety, Order. Save the file Last_First_MOS19_XL_PROJ3_Equipment.xlsx. Exit Excel. Submit the file as directed.
0
Total Points
100
Created On: 12/14/2020 1 MOS19_XL_PROJ3 – Equipment 1.1
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.