NEW
Font size
WorksheetsExcel EXPERT Lesson 4 Quiz
Total questions: 23
Worksheet time: 23mins
The statement that best describes the GETPIVOTDATA function is that it:
deletes unused data from a PivotTable.
inputs data from a location outside of the PivotTable to a PivotTable.
extracts data stored in a PivotTable.
pulls data from a PivotTable and creates a new chart.
On which tab is the Shape Effects command located?
Chart Tools Format tab
Home tab
Insert tab
R tab
What does Emma need to do before she can group the data in her PivotTable?
aggregate
filter
sort
subtotal
Amy is currently viewing a chart she recently created and would like to make a chart template from it. To complete this task, Amy should:
take a screenshot of the chart and save it as a graphics file to use as an example for future chart creation.
click the File tab, select Save As, and then select Chart Template for the file type.
right-click in the Chart Area and select Save As Template.
use the Format Selection button to change the template property.
To create a PivotTable from Power Pivot data, the data must be in:
columns
fields
rows
tables
Which is a graphical representation that fails to depict all of the exact data in the worksheet?
chart
dual-axis chart
template
trendline
Sarah knows she has chosen the best type of trendline for the data on her chart because:
it is dark red.
it is slightly above the data.
it is slightly below the data.
the R2 value is closest to 1.
Which is an example of a trendline option in Excel?
bar
exponential
radar
stock
An advantage of using the Power Pivot model over standard PivotTables is the ability to:
filter data.
sort data.
use aggregate functions.
use data in multiple related tables.
Mark has selected the sheet that contains a line chart. To add a trendline, Mark would:
change the chart type to the line with a trendline.
right-click a data series and then select Add Trendline on the shortcut menu.
select the trendline style in the chart styles gallery on the Chart Tools Design tab.
use the Insert Shapes tool on the Chart Tools Format tab to draw a trendline on the chart.
A PivotChart is normally based on an existing:
Named Range.
PivotSheet.
PivotTable.
What-If Analysis.
Which statement is true about slicers?
There can only be one active slicer at a time.
They cannot be moved.
They cannot be resized.
A user can select multiple buttons within a slicer.
Which PivotChart tool limits the amount of data being displayed?
axis
filter
legend
sort
Which is true about trendlines?
They can be added to 3D charts.
They can be added to pie charts.
They can be used to predict future values.
They correspond directly to data in the spreadsheet.
Damon wants to be able to view test scores for one subject area at a time in his PivotChart. Where should he drag the “Subject” field in the PivotChart Fields Task Pane Options?
Columns
Filters
Rows
Values
Allison is working with a PivotTable in Excel, but the PivotTable Fields Pane has disappeared. In order to make the PivotTable Fields Pane reappear, she must click on:
any active cell with showing data.
any cell outside of the table.
any empty cell.
the fx icon.
Which Excel group in the PivotTable Tools, Analyze tab contains the option to insert a timeline once a PivotTable is created?
Actions
Data
Filter
Tools
Which Excel group on the PivotTable Tools, Analyze tab has the option to insert a slicer in a PivotTable?
Actions
Data
Filter
Calculations
Ginger is working with a PivotTable. Which PivotTable formatting task will allow her to turn on the row headers and banded rows?
applying a PivotTable style
configuring a PivotTable layout
selecting a report layout
setting PivotTable style options
Which Excel value shows how well the trend calculations fit the actual data points?
FV
R2
V2
PV
Kenneth would like to analyze large amounts of data in many different ways. Which report could Kenneth use to summarize data by categories and subcategories, expand and collapse levels of data to drill down and filter results, or move rows to columns or columns to rows to examine different summaries of the data?
PivotTable
PowerChart
Query
Slicer
Which function is used to pull data to be used outside of the PivotTable?
GETPIVOTDATA
INDEX
SLICER
VLOOKUP
For a Power Pivot model to work properly, the data should be formatted as a:
chart
PivotChart
PivotTable
table
