DEVRY BIS155 week 3 quiz
- Mastermind
- Rating : 6
- Grade : A+
- Questions : 0
- Solutions : 3687
- Blog : 0
- Earned : $13683.31
Question 1. Question :
(TCO 4) _____ column and row headings enables you to keep these headings on the screen when scrolling through a large spreadsheet.
Formatting
Freezing
Resizing
Tiling
Question 2. Question :
(TCO 4) Which of the following best describes a page break?
Freezes only the top row
The sequence in which pages print
Indicates where data starts on a new printed page
Stops the printer from printing
Question 3. Question :
(TCO 4) 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. Question :
(TCO 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. Question :
(TCO 4) To apply a red background color to cells for employees who have sales greater than $1,000, you can use _____.
a PivotTable
a multiple level sort
conditional formatting
a range name
Question 6. Question :
(TCO 4) 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. Question :
(TCO 4) The Subtotal command is located on the _____ tab.
data
formula
page layout
insert
Question 8. Question :
(TCO 4) _____ are created to organize and summarize data in PivotTables.
Categories
Types
Titles
Levels
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?
: Column Labels
Report Filter
Row Labels
Values
Question 10. Question :
(TCO 4) To create a calculated field, select _____ located on the PivotTable Tools Options tab.
Calculations
Insert Calculated Field dialog launcher
Tools
PivotTable Calculation
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) The PivotChart Tools contextual tab includes all the following EXCEPT _____.
design
layout
format
type
Question 14. Question :
(TCO 4) Click the _____ to sort or filter the chart representation based on the values.
Axis Field arrows
Report Filter arrows
Values arrows
Legend Field arrows
Question 15. Question :
(TCO 4) 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
[Solved] DEVRY BIS155 week 3 quiz
- This solution is not purchased yet.
- Submitted On 05 Apr, 2015 10:30:34
- Mastermind
- Rating : 6
- Grade : A+
- Questions : 0
- Solutions : 3687
- Blog : 0
- Earned : $13683.31