Skip to content

Practice Exam 1 - Project 1

Scuba

You own a small SCUBA diving concession in the Caribbean. You need to update your Inventory workbook to include new items.

Task 1

Beginning at cell A16 on Sheet1, import the list from the comma delimited source file MoreToys.csv located in the GMetrix Templates folder. (Accept all other defaults)

Hint

  1. On the Sheet1 worksheet, click cell A16 to select it.

  2. On the Data tab, in the Get External Data group, click From Text.

    Image title

  3. Browse to the GMetrix Templates folder.

  4. Select the MoreToys.csv file and click the Import button.

  5. In the Text Import Wizard - Step 1 of 3 pop-up window, accept the default data type as Delimited and click the Next button.

  6. In the Text Import Wizard - Step 2 of 3 pop-up, change the Delimiter from Tab to Comma by clicking on the box next to Tab to clear it, then clicking on the box next to Comma to select it. (Hint: Notice how you can preview how the data will be separated in the window below).

  7. Accept all other defaults and click the Finish button.

  8. In the Import Data pop-up accept the defaults and click OK.

    Image title

    Image title

Task 2

Change the worksheet tab color of Sheet1 to Blue, Accent 2, Darker 25%.

Hint

  1. At the bottom of the workbook, right-click the Sheet1 tab and select Tab Color.

  2. Under Theme Colors, in the sixth column fifth row, select Blue, Accent 2, Darker 25%.

    Image title

Task 3

Copy the contents of the New Inventory worksheet and put it in the table on the Boats worksheet beginning in cell A6.

Hint

  1. At the bottom of the workbook, click the New Inventory worksheet tab and select cell range A2 through D9.

  2. On the ribbon Home tab, in the Clipboard group, click Copy.

    (Hint: You can also copy using the keyboard short-cut CTRL-C)

    Image title

  3. Click on the Boats worksheet tab and click the first cell in the table, cell A6.

  4. On the ribbon Home tab, in the Clipboard group, click Paste.

    (Hint: You can also paste using the keyboard short-cut CTRL-V)

    Image title

Task 4

Reorder the worksheets so Boats is first.

Hint

  1. At the bottom of the workbook, right-click the Boats tab, and select Move or Copy...

    Image title

  2. In the Before sheet: window, select Sheet1.

  3. Click the OK button.

    (Hint: You can also click-drag the tab to move it.)

    Image title

Task 5

Hide the New Inventory worksheet.

Hint

  1. At the bottom of the workbook, right-click the New Inventory worksheet tab, and select Hide.

    Image title

-OR-

  1. Click the New Inventory worksheet tab to select it.

  2. On the Home tab, in the Cells group, click the Format drop-down arrow. Select Hide & Unhide, then click Hide Sheet.

    Image title