BIS 155 Week 3 Quiz
BIS 155 Week 3 Quiz Recent
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
24/7 Nursing Homework Help
Stuck with your nursing assignment? From Essays to Complicated Dissertations? Our accredited nursing paper writers can answer it all!
