GMETRIX PRACTICE EXAM 2
On the Qtr 2 worksheet, in cell F10, insert a column sparkline
showing the sales trend from Apr through Jun. Apply Gold, Sparkline
Style Accent 2, Darker 25% to the sparkline. Copy the sparkline to the
remaining cells in the column (F11:F14). - ANSWERS-1. Select cell
F10 on the Qtr 2 worksheet.
2. Select the Insert tab.
3. In the Sparklines group, click Column.
4. In the Create Sparklines pop-up window, configure the fields as
follows:
Data range: B10:E10
Location range: $F$10
5. Click OK.
6. On the Sparkline Tools Design tab, in the Style group, click the
More down arrow to open the Style gallery. Select Gold, Sparkline
Style Accent 2, Darker 25%.
7. In the lower-right corner of the cell, click-drag the Fill Handle from
cell F11 through cell F14 to create a sparkline for each location.
Using the Move Chart feature, move the pie chart on the Qtr 2
worksheet to its own chart sheet named Qtr 2 Chart. - ANSWERS-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.
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. -
ANSWERS-1. On the Qtr 1 worksheet, select columns B through E.
2. On the Home tab, in the Number group, click the $ symbol (this
will align the symbols).
(Hint: Alternatively, click the dialog-box launcher in the lower-right
corner of the Number group. On the Number tab, in the Category
pane, select Accounting and configure Decimal places: 2 and Symbol:
$. Then click OK.)
In the Qtr 1 worksheet, change the configuration of the Qtr 1 Location
Revenue chart so that it displays the months on the x-axis and the
revenue on the y-axis. - ANSWERS-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.
Display all of the formulas on the Qtr 2 worksheet. - ANSWERS-1.
On the Qtr 2 worksheet, select the Formulas tab.
2. On the Formulas tab, in the Formula Auditing group, click Show
Formulas.
On the Qtr 2 worksheet, in cell F10, insert a column sparkline
showing the sales trend from Apr through Jun. Apply Gold, Sparkline
Style Accent 2, Darker 25% to the sparkline. Copy the sparkline to the
remaining cells in the column (F11:F14). - ANSWERS-1. Select cell
F10 on the Qtr 2 worksheet.
2. Select the Insert tab.
3. In the Sparklines group, click Column.
4. In the Create Sparklines pop-up window, configure the fields as
follows:
Data range: B10:E10
Location range: $F$10
5. Click OK.
6. On the Sparkline Tools Design tab, in the Style group, click the
More down arrow to open the Style gallery. Select Gold, Sparkline
Style Accent 2, Darker 25%.
7. In the lower-right corner of the cell, click-drag the Fill Handle from
cell F11 through cell F14 to create a sparkline for each location.
Using the Move Chart feature, move the pie chart on the Qtr 2
worksheet to its own chart sheet named Qtr 2 Chart. - ANSWERS-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.
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. -
ANSWERS-1. On the Qtr 1 worksheet, select columns B through E.
2. On the Home tab, in the Number group, click the $ symbol (this
will align the symbols).
(Hint: Alternatively, click the dialog-box launcher in the lower-right
corner of the Number group. On the Number tab, in the Category
pane, select Accounting and configure Decimal places: 2 and Symbol:
$. Then click OK.)
In the Qtr 1 worksheet, change the configuration of the Qtr 1 Location
Revenue chart so that it displays the months on the x-axis and the
revenue on the y-axis. - ANSWERS-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.
Display all of the formulas on the Qtr 2 worksheet. - ANSWERS-1.
On the Qtr 2 worksheet, select the Formulas tab.
2. On the Formulas tab, in the Formula Auditing group, click Show
Formulas.
