Question 5. Question : (TCO 4) Which of the following best describes conditional formatting?
Student Answer: Highlights or emphasizes cells that meet certain conditions
Tags a table element as a reference in a formu
...
Question 5. Question : (TCO 4) Which of the following best describes conditional formatting?
Student Answer: 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. Question : (TCO 4) Using Conditional Formatting to draw attention to cells that are blank _____.
Student Answer: 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. Question : (TCO 4) When data is grouped, the margin area displays the _____.
Student Answer: aggregate columns
group headings
collapse and expand buttons
group totals
Question 8. Question : (TCO 4) _____ are created to organize and summarize data in PivotTables.
Student Answer: Categories
Types
Titles
Levels
I
Question 9. Question : (TCO 4) To begin a filter based on a particular field, you drag the desired field to which area under Drag fields between areas below?
Student Answer: Column Labels
Report Filter
Row Labels
Values
Question 10. Question : (TCO 4) The Insert Calculated Field dialog box requires you do all the following EXCEPT _____.
Student Answer: 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. Question : (TCO 4) A Pivot Table Style controls all the following EXCEPT _____.
Student Answer: bolding
font colors
number format
shading colors
Question 12. Question : (TCO 4) The _____ enables you to move to a cell quickly by typing the desired cell reference in it and pressing Enter.
Student Answer: Formula bar
F4 function key
Go to dialog box
Find and Replace dialog box
Question 13. Question : (TCO 4) After a PivotChart has been created, the PivotTable Settings can still be changed by using the _____.
Student Answer: PivotTable Field List
Chart Layout command
Format Tab
Data Tab
Question 14. Question : (TCO 4) After creating a PivotChart, you can sort or filter categories or subcategories in rows by clicking the _____.
Student Answer: Report Filter arrows
Legend Field arrows
Axis Field arrows
Values arrows
Question 15. Question : (TCO 4) Which of the following will NOT delete a PivotChart?
Student Answer: 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
[Show More]
