Slicers allow you to

Select one:

a. insert a graph into a single cell of the worksheet.

b. filter data from several workbooks at once.

c. filter without using a filter arrow.

d. sort a named range with one click.

What are Sparklines?

Select one:

a. identically-structured ranges occurring on different worksheets

b. watermarks that print behind a worksheet's cells

c. charts based on PivotTables

d. miniature charts embedded in the background of cells

What happens after you click the Insert Timeline button?

Select one:

a. The PivotTable displays the data for the time period selected.

b. The PivotTable updates to show the results.

c. The Value Field Settings dialog box opens.

d. The Insert Timelines dialog box opens.

What is the first step in consolidating data?

Select one:

a. Click the Consolidate button.

b. Click the Data tab.

c. Make the starting cell active.

d. Enter the first range in the Reference text box.

Slicers allow you to Select one: a. insert a graph into a single cell of the worksheet. b. filter data from several workbooks at once. c. filter without using a filter arrow. d. sort a named range with one click