Assignment
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. In Excel, a table is defined as _____.
an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis
a complete set of data for an entity
a Field, which is an individual piece of data
an individual piece of data, such as a last name
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. 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. Using Conditional Formatting to draw attention to cells that are blank _____.
displays a particular color based on the relative value of the cell contents to other selected cells
displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range
helps locate where data may be missing
helps locate errors in cells quickly
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. When creating a PivotTable, you should use a new worksheet because _____.
PivotTables only work in new worksheets
Excel aggregates and consolidates data best in new worksheets
separating the PivotTable from the original dataset will prevent accidental deletions of the original dataset
duplicate values are easily identified in new worksheets
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. A Pivot Table Style controls all the following EXCEPT _____.
bolding
font colors
number format
shading colors
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. The PivotChart Tools contextual tab includes all the following EXCEPT _____.
design
layout
format
type
Question 14. To build a PivotTable and PivotChart at the same time, click the PivotTable arrow and then select _____.
PivotTable & PivotChart
PivotChart
Auto PivotTable
Auto PivotChart
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