Question 1: If there are certain columns of information that are not needed at a particular time but might be needed later, _____ the unneeded columns to allow users to focus on only the essential information.

• hide
• delete
• freeze
• format

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
• click the Insert tab and then click Table in the Tables group

Question 4: Which of the following best describes the Excel filtering feature?

• Helps to clean the data before printing in Backstage view
• Displays data in chronological order
• The process of displaying only records that meet specific conditions
• Arranges dates in alphabetical order

Question 5: To apply a red background color to cells for employees who have sales greater than $1,000, you can use _____.

• a PivotTable
• a multiple level sort
• conditional formatting
• a range name

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: _____ are created to organize and summarize data in PivotTables.

• Categories
• Types
• Titles
• Levels

Question 9: Data mining techniques such as PivotTables can detect _____ of data.

• patterns
• categories
• styles
• groups

Question 10: The Insert Calculated Field dialog box requires you do all the following EXCEPT _____.

• enter formulas using field names instead of cell references
• enter a description column heading for the calculated field
• build formulas using mathematical operands such as +, -, and *
• enter formulas using cell references

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: The _____ enables you to move to a cell quickly by typing the desired cell reference in it and pressing Enter.

• Formula bar
• F4 function key
• Go to dialog box
• Find and Replace dialog box

Question 13: To go to the top of your spreadsheet quickly, use the _____ key(s).

• Ctrl+End
• Arrow
• Ctrl+Home
• Esc

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: Pivot Charts look best when they use basic charts, such as a _____.

• column chart
• scatter chart
• radar chart
• surface chart