DEVRY BIS155/BIS 155 week 3 quiz - 89608

Solution Posted by
anjis_devis

anjis_devis

Rating : (20)B
Solution Detail
Price: $12.00
  • From: Computer Science, PHP
  • Posted on: Sun 05 Apr, 2015
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description
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
Solution Description

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

Attachments
DEVRY_BIS155_week_3_quiz.docx
DEVRY_BIS155_we...