BIS 155 WEEK 3 QUIZ

BIS 155 WEEK 3 
Week 3	Quis

 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.
Question :
(TCO 4) Which of the following best describes a page break?
Question :
(TCO 4) To create a table from an existing range of data, _____.
Question :
(TCO 4) Which of the following best describes the Excel filtering feature?
Question :
(TCO 4) To apply a red background color to cells for employees who have sales greater than $1,000, you can use _____.
Question :
(TCO 4) In addition to sorting and filtering cells by content, you can sort and/or filter by _____.
Question :
(TCO 4) When data is grouped, the margin area displays the _____.
Question :
(TCO 4) _____ are created to organize and summarize data in PivotTables.
Question :
(TCO 4) Data mining techniques such as PivotTables can detect _____ of data.
Question :
(TCO 4) The Insert Calculated Field dialog box requires you do all the following EXCEPT _____.
Question :
(TCO 4) Excel applies basic formatting to PivotTables such as _____.
Question :
(TCO 4) The _____ enables you to move to a cell quickly by typing the desired cell reference in it and pressing Enter.
Question :
(TCO 4) To go to the top of your spreadsheet quickly, use the _____ key(s).
Question :
(TCO 4) Click the _____ to sort or filter the chart representation based on the values.
Question :
(TCO 4) Pivot Charts look best when they use basic charts, such as a _____.