BIS 155 Week 3 Quiz NEW

Question 1. Question : (TCO 4) 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. Question : (TCO 4) In Excel, the print area is defined as _.

an individual piece of data, such as a last name
a complete set of data for an entity
the sequence in which pages print
the range of data to print

Question 3. Question : (TCO 4) When sorting in Excel, it arranges records in a table _.

by the number of pages in the worksheet
by the number of pages in the workbook
by the value in field(s) within a table
by permanently removing extraneous data

Question 4. Question : (TCO 4) Filtering the Last_Name column (field) to show only records that begin with the letter S is an application of _.

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

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

a pivot table
a multiple level sort
conditional formatting
a range name

Question 6. Question : (TCO 4) 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. Question : (TCO 4) For subtotals to be useful and accurate, it is important that the data be _ correctly.

sorted
formatted
aligned
labeled

Question 8. Question : (TCO 4) _ are created to organize and summarize data in pivot tables.

Categories
Types
Titles
Levels

Question 9. Question : (TCO 4) Data mining techniques, such as pivot tables can detect _ of data.

patterns
categories
styles
groups

Question 10. Question : (TCO 4) To create a calculated field, select _ located on the Pivot Table Tools Options tab.

Calculations
Tools
Pivot Table Calculation
None of the above

Question 11. Question : (TCO 4) A Pivot Table Style controls all the following EXCEPT _.

bolding
font colors
number format
shading colors

Question 12. Question : (TCO 4) A quick way to display the Go to dialog box is to press the _ key(s).

F4
Ctrl+Home
Ctrl+End
F5

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

Ctrl+End
Arrow
Ctrl+Home
Esc

Question 14. Question : (TCO 4) When Excel creates a PivotChart it uses the current PivotTable settings – if you want to change that data you might use

Insert PivotTable
Insert Function
PivotTable Field List
Filter Connections

Question 15. Question : (TCO 4) Which of the following will NOT delete a pivot chart?

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 pivot chart off the worksheet