Skip to content

Practice Exam 1 - Project 4

Network Hardware

Your company sells, installs, and services network equipment. You are preparing a workbook to track customer activity.

Task 1

Add a new worksheet named Customers to the workbook.

Hint

  1. At the bottom of the workbook, to the right of the Hardware worksheet tab, click the New Sheet button (+)

  2. Right-click the new worksheet tab named Sheet1, and select Rename.

  3. Replace the name, Sheet1, by typing the new name, Customers. Press Enter on your keyboard to accept the change.

Task 2

Simultaneously remove all duplicate records in the Wired Networks table in the Hardware worksheet.

Hint

  1. Click any cell within the Wired Networks table.

  2. On the Data tab, in the Data Tools group, click Remove Duplicates.

    (Hint: Notice the entire table is automatically selected.)

  3. Accept all defaults and click OK.

    (Hint: A pop-up window should confirm that 2 duplicate records were removed.)

  4. Click OK.

Task 3

Beginning at cell A1 on the Hardware worksheet, import the picture file NetworkTopology.png located in the GMetrix Templates folder.

Hint

  1. On the Hardware worksheet, click on cell A1.

  2. On the Insert tab, in the Illustrations group, click Pictures. Browse to the GMetrix Templates folder, select the file, NetworkTopology.png.

  3. Click the Insert button.

Task 4

On the Hardware worksheet, rotate the text Wired Networks and Wireless Networks to Angle Clockwise.

Hint

  1. Click the cell containing the text Wired Networks (Cell C3) then hold down the CTRL button on the keyboard and select Wireless Networks (Cell C18) to simultaneously select both.

  2. On the in the Home tab, in the Alignment group, click the Orientation icon and select Angle Clockwise.

Task 5

Sort the data in the Wired Networks table. Sort by ProductID, smallest to largest.

Hint

  1. Click any cell within the Wired Networks table.

  2. On the Home tab, in the Editing group, click Sort & Filter and select Custom Sort...

  3. In the Sort pop-up window, configure the fields as shown below:

    Column Sort by: ProductID

    Sort on: Values

    Order: smallest to largest

  4. Click OK.