Question 1: In Excel, a dataset would be which of the following?

• Indicates where data starts on a new printed page
• Collection of structured, related data in columns and rows
• Freezing rows to keep them visible
• Freezing panes to keep them visible

Question 2: Which of the following best describes a page break?

• Freezes only the top row
• The sequence in which pages print
• Indicates where data starts on a new printed page
• Stops the printer from printing

Question 3: To create a table from an existing range of data, _____.

• click within the range, click the Table Tools Design tab, and then select Convert to Table
• select any cell in the worksheet and then click Existing Range in the Tools group
• click in a cell and on the Home tab, and click the Insert arrow in the Cells group
• cick the Insert tab and then click Table in the Tables group

Question 4: Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____.

• a Date Filter
• a Text Filter
• the use of a table element as a formula
• a Number Filter

Question 5: Which of the following best describes conditional formatting?

• Highlights or emphasizes cells that meet certain conditions
• Tags a table element as a reference in a formula
• Formats the condition of the worksheet in preparation for printing
• Calculates an aggregate for values in a range or database

Question 6: In addition to sorting and filtering cells by content, you can sort and/or filter by _____.

• top/bottom rules
• conditional formatting
• icon sets
• the data bar

Question 7: When data is grouped, the margin area displays the _____.

• aggregate columns
• group headings
• collapse and expand buttons
• group totals

Question 8: To add a PivotTable, choose the Insert PivotTable command from the _____ group.

• tables
• format
• layout
• chart

Question 9: To begin a filter based on a particular field, you drag the desired field to which area under Drag fields between areas below?

• Column Labels
• Report Filter
• Row Labels
• Values

Question 10: To create a calculated field, select _____ located on the PivotTable Tools Options tab.

• Calculations
• Insert Calculated Field dialog launcher
• Tools
• PivotTable Calculation

Question 11: Excel applies basic formatting to PivotTables such as _____.

• subtotals in italics
• primary row labels in bold
• primary row labels in italics
• subtotals in red

Question 12: What are the areas of a PivotTable Report where fields can be placed?

• Criteria Range and Extract Range
• Values, Axis Fields, Legend Fields, and Report Filter
• Values, Row Labels, Column Labels, and Report Filter
• Database, Field, and Criteria

Question 13: After a PivotChart has been created, the PivotTable Settings can still be changed by using the _____.

• PivotTable Field List
• Chart Layout command
• Format Tab
• Data Tab

Question 14: Click the _____ to sort or filter the chart representation based on the values.

• Axis Field arrows
• Report Filter arrows
• Values arrows
• Legend Field arrows

Question 15: Which of the following will NOT delete a PivotChart?

• Go to the Home tab and click Cut
• Right-click the chart and click Cut
• Select the chart and then press Delete
• Click and drag the PivotChart off the worksheet