Skip to content

Practice Exam 1 - Project 5

Farm Market

You are the Sales Director for your local Farmers Market Association. You are modifying an Excel workbook to help you track the revenue from last season.

Task 1

Change the margins of the Summary worksheet to 0.75" on the top, bottom, left, right, and a 0.5" header and footer. Center the worksheet horizontally within the margins.

Hint

  1. At the bottom of the workbook, click the Summary tab to make this the active worksheet.

  2. On the Page Layout tab, in the Page Setup group, click Margins and select Custom Margins ...

  3. Configure the margins as follows: (Hint: Type the numbers to change them. Do not scroll.)

    Top: 0.75" Header: 0.5"

    Left: 0.75" Right: 0.75"

    Bottom: 0.75" Footer: 0.5"

  4. Check the box to Center on Page: Horizonally

  5. Click OK.

Task 2

Hide the Rental Revenue worksheet so it still exists in the workbook, but the tab is not visible.

Hint
  1. At the bottom of the workbook, right-click the Rental Revenue worksheet tab, and select Hide.

An alternative solution:

  1. Click the Rental Revenue 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.

Task 3

Save the Summary worksheet into the GMetrixTemplates folder as a PDF file with the name, Summary.

Hint

  1. At the bottom of the workbook, click the Summary tab to make this the active worksheet.

  2. Select the File tab.

  3. In the left pane, select Save As and browse to the GMetrixTemplates folder.

  4. In the Save As pop-up window, configure the following:

File name: Summary Save as type: PDF (*.pdf)

  1. Accept all other defaults and click Save.

(Hint: If the .pdf is opened by your operating system, verify the creation of the document then close the PDF window.)

Task 4

Outline both the columns and rows of the table on the Summary worksheet.

Hint

  1. At the bottom of the workbook, click the Summary tab.

  2. Click any cell within the table to select it.

  3. On the Data tab, in the Outline group, click Group and select Auto Outline.

Task 5

Sort the Farmers Market worksheet alphabetically (from A to Z), first by Location, then by Product, and then by Season (Spring, Summer, Fall).

Hint

  1. At the bottom of the workbook, click the Farmers Market tab.

  2. Click any cell within the table to select it.

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

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

    Column Sort by: Location

    Sort on: Values

    Order: A to Z

  5. Click Add Level

  6. Then by: Product

    Sort on: Values

    Order: A to Z

  7. Click Add Level

  8. Then by: Season

    Sort on: Values

  9. For Order click Custom List, in the Add List**box type: **Spring, Summer, Fall

  10. Click Add.

  11. Click OK.

  12. Click OK.