Skip to content

Practice Exam 1 - Project 6

Taco Stands

A Taco Stand business is creating a sales report. They need help with charts, formulas and configurations. You've been hired to assist.

Task 1

Make a copy of the Qtr 2 worksheet to the right of the Qtr 2 worksheet.

Hint

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

  2. In the Move or Copy pop-up window, configure the following:

    Before sheet: (move to end) Click the box Create a copy box to enable it.

  3. Click OK.

(Hint: The copy will automatically be named, Qtr 2 (2) and will appear to the right of the original worksheet. )

Task 2

Display the formulas that are in the cells of the Qtr 2 worksheet.

Hint

  1. Select the Qtr 2 worksheet.

  2. On the Formulas tab, in the Formula Auditing group, click Show Formulas.

Task 3

On the Qtr 1 worksheet, apply a number format to display the numbers in columns B through E to two decimal places with the US Dollar symbol ($) left-aligned and the decimal points aligned.

Hint

  1. On the Qtr 1 worksheet, select columns B through E.

  2. On the Home tab, in the Number group, click the $ symbol.

Task 4

In the Qtr 1 worksheet change the configuration of the Q1 Taco Revenue chart so that it displays the months on the x-axis and the revenue on the y-axis.

Hint

  1. Click the Qtr 1 worksheet tab to select it.

  2. Click the chart to reveal the Chart Tools tabs.

  3. On the Chart Tools Design tab, in the Data group, click Switch Row / Column.

Task 5

Without using the New Sheet button, move the pie chart on the Qtr 2 worksheet to its own chart sheet named Qtr 2 Chart.

Hint

  1. On the Qtr 2 worksheet, click anywhere on the pie chart to select it.

  2. On the Chart Tools Design contextual tab, in the Location group, click Move Chart.

  3. In the Move Chart pop-up window, select New Sheet and type the name Qtr 2 Chart.

  4. Click OK.