Select Page

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