BUSI 201 QUESTIONS WITH ACCURATE ANSWERS
Add a calculated field to this PivotTable to calculate the average sales per visit by
state (=Sales/Visits). Name the new field Average. correct answer On the
PivotTable Tools Analyze tab, click the Calculations button, and then click Fields,
Items, & Sets. Select Calculated Field... In the Insert Calculated Field dialog, type
Average in the Name box. In the Formula box, delete the 0 and type Sales/Visits.
Do not delete the equals sign. Click OK.
Add a hyperlink from cell C11 in the Summary worksheet to link to cell A7 in the
Downtown worksheet. Don't forget to use A7 as the cell reference. correct
answer On the Insert tab, in the Links group, click the Link button. Under Link to:
click Place in this document. In the Type the cell reference box, type: A7 In the Or
select a place in this document box, click Downtown. Click OK.
Add a linear trendline to this chart. Use the default trendline formatting. correct
answer Click the Chart Elements button that appears near the upper right corner
of the chart. Click the Trendline check box to add a checkmark.
Add a Picture Organization Chart SmartArt diagram to the worksheet. It is the
second option in the first row of the Hierarchy category. correct answer Click the
Insert tab. Click the Insert a SmartArt Graphic button. In the Choose a SmartArt
Graphic dialog box, click the Hierarchy category. Click the second option in the
first row and click OK.
Add a report filter for the State field and use it to filter the PivotTable to show
only data where the value of the State field is MD. correct answer Click the State
field in the PivotTable Fields pane and drag it to the Filters box in the bottom part
of the pane. Click the filter arrow in cell B1. Click MD. Click OK.
,Add a slicer to the PivotTable for the State field and use the slicer to show only
data where the value is VA. correct answer On the PivotTable Tools Analyze tab,
in the Filter group, click the Insert Slicer button. In the Insert Slicers dialog, click
the check box for State. Click OK. In the slicer, click VA.
Add a timeline to the PivotTable to filter the data by values in the Date of Last
Visit field. Use the timeline to filter the PivotTable to show only dates in
September. correct answer On the PivotTable Tools Analyze tab, in the Filter
group, click the Insert Timeline button. In the Insert Timeline dialog, click the
check box for the Date of Last Visit field. Click OK. Click the September segment
on the timeline.
Add a total row to this table and display the maximum value for the Total Spent
column. correct answer On the Table Tools Design tab, in the Table Style Options
group, click the Total Row check box. In the Total row, click in the Total Spent
column. Click the arrow and select Max.
Add another data series to the chart to represent the number of items ordered.
Use the value of cell B1 as the series name and cells B2:B4 as the series values. Do
not rebuild the chart from scratch. correct answer On the Chart Tools Design tab,
in the Data group, click the Select Data button. In the Select Data Source dialog,
click the Add button. Click cell B1 to enter it in the Series name box. Click in the
Series values box and delete the default entry. Click and drag cells B2:B4. Click OK
to add the new series. Click OK to accept the change to the chart data source.
Add line Sparklines to cells E3:E12 to represent the values in B3:D12. correct
answer Click the Quick Analysis Tool button and click the Sparklines tab. Click Line.
, Add slicers to filter the data in this table by City. correct answer Click the Table
Tools Design tab. In the Tools group, click the Insert Slicer button. Click the City
check box. Click OK.
Add the Developer tab to the Ribbon. correct answer Click the File tab. Click
Options to open the Excel Options dialog. Click Customize Ribbon. At the right
side of the Customize the Ribbon window, the Customize the Ribbon list shows all
the tab and groups available. Click the Developer check box to add the Developer
tab to the Ribbon. Click OK.
Add this comment to cell B4: Why did advertising increase? correct answer On the
Review tab, in the Comments group, click the New Comment button. Type: Why
did advertising increase? Click outside the balloon.
Apply data validation rules to the selected cells to allow only decimal numbers
less than 5.00. Allow blank cells. correct answer On the Data tab, in the Data Tools
group, click the Data Validation button. Expand the Allow list and select Decimal.
Expand the Data list and select less than. Type 5.00 in the Maximum box. Click OK.
Apply the Cartoon SmartArt style to the diagram. It is the third option in the 3-D
section of the gallery. correct answer Click the SmartArt Tools Design tab. Click
the More button to display the gallery. Select the third option in the 3-D section
of the gallery.
Apply the Colorful Palette 4 color scheme (the fourth option in the Colorful
section) to the chart. correct answer Click the Chart Tools Design tab. In the Chart
Styles group, click the Change Colors button. Click Colorful Palette 4, it is the
fourth option in the Colorful section.
Add a calculated field to this PivotTable to calculate the average sales per visit by
state (=Sales/Visits). Name the new field Average. correct answer On the
PivotTable Tools Analyze tab, click the Calculations button, and then click Fields,
Items, & Sets. Select Calculated Field... In the Insert Calculated Field dialog, type
Average in the Name box. In the Formula box, delete the 0 and type Sales/Visits.
Do not delete the equals sign. Click OK.
Add a hyperlink from cell C11 in the Summary worksheet to link to cell A7 in the
Downtown worksheet. Don't forget to use A7 as the cell reference. correct
answer On the Insert tab, in the Links group, click the Link button. Under Link to:
click Place in this document. In the Type the cell reference box, type: A7 In the Or
select a place in this document box, click Downtown. Click OK.
Add a linear trendline to this chart. Use the default trendline formatting. correct
answer Click the Chart Elements button that appears near the upper right corner
of the chart. Click the Trendline check box to add a checkmark.
Add a Picture Organization Chart SmartArt diagram to the worksheet. It is the
second option in the first row of the Hierarchy category. correct answer Click the
Insert tab. Click the Insert a SmartArt Graphic button. In the Choose a SmartArt
Graphic dialog box, click the Hierarchy category. Click the second option in the
first row and click OK.
Add a report filter for the State field and use it to filter the PivotTable to show
only data where the value of the State field is MD. correct answer Click the State
field in the PivotTable Fields pane and drag it to the Filters box in the bottom part
of the pane. Click the filter arrow in cell B1. Click MD. Click OK.
,Add a slicer to the PivotTable for the State field and use the slicer to show only
data where the value is VA. correct answer On the PivotTable Tools Analyze tab,
in the Filter group, click the Insert Slicer button. In the Insert Slicers dialog, click
the check box for State. Click OK. In the slicer, click VA.
Add a timeline to the PivotTable to filter the data by values in the Date of Last
Visit field. Use the timeline to filter the PivotTable to show only dates in
September. correct answer On the PivotTable Tools Analyze tab, in the Filter
group, click the Insert Timeline button. In the Insert Timeline dialog, click the
check box for the Date of Last Visit field. Click OK. Click the September segment
on the timeline.
Add a total row to this table and display the maximum value for the Total Spent
column. correct answer On the Table Tools Design tab, in the Table Style Options
group, click the Total Row check box. In the Total row, click in the Total Spent
column. Click the arrow and select Max.
Add another data series to the chart to represent the number of items ordered.
Use the value of cell B1 as the series name and cells B2:B4 as the series values. Do
not rebuild the chart from scratch. correct answer On the Chart Tools Design tab,
in the Data group, click the Select Data button. In the Select Data Source dialog,
click the Add button. Click cell B1 to enter it in the Series name box. Click in the
Series values box and delete the default entry. Click and drag cells B2:B4. Click OK
to add the new series. Click OK to accept the change to the chart data source.
Add line Sparklines to cells E3:E12 to represent the values in B3:D12. correct
answer Click the Quick Analysis Tool button and click the Sparklines tab. Click Line.
, Add slicers to filter the data in this table by City. correct answer Click the Table
Tools Design tab. In the Tools group, click the Insert Slicer button. Click the City
check box. Click OK.
Add the Developer tab to the Ribbon. correct answer Click the File tab. Click
Options to open the Excel Options dialog. Click Customize Ribbon. At the right
side of the Customize the Ribbon window, the Customize the Ribbon list shows all
the tab and groups available. Click the Developer check box to add the Developer
tab to the Ribbon. Click OK.
Add this comment to cell B4: Why did advertising increase? correct answer On the
Review tab, in the Comments group, click the New Comment button. Type: Why
did advertising increase? Click outside the balloon.
Apply data validation rules to the selected cells to allow only decimal numbers
less than 5.00. Allow blank cells. correct answer On the Data tab, in the Data Tools
group, click the Data Validation button. Expand the Allow list and select Decimal.
Expand the Data list and select less than. Type 5.00 in the Maximum box. Click OK.
Apply the Cartoon SmartArt style to the diagram. It is the third option in the 3-D
section of the gallery. correct answer Click the SmartArt Tools Design tab. Click
the More button to display the gallery. Select the third option in the 3-D section
of the gallery.
Apply the Colorful Palette 4 color scheme (the fourth option in the Colorful
section) to the chart. correct answer Click the Chart Tools Design tab. In the Chart
Styles group, click the Change Colors button. Click Colorful Palette 4, it is the
fourth option in the Colorful section.
