Devry BUS155/ BUS155 week 3 quiz 3 latest (PERFECT SOLUTION) - 92869

Solution Posted by
anjis_devis

anjis_devis

Rating : (20)B
Solution Detail
Price: $11.00
  • From: Computer Science, PHP
  • Posted on: Sat 15 Aug, 2015
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description
Question (TCO 4) In Excel, a dataset would be which of the following? Indicates where data starts on a new printed page Collection of structured, related data in columns and rows Freezing rows to keep them visible Freezing panes to keep them visible : Textbook Chapter 4 2 of 2 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 : Textbook Chapter 4 2 of 2 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 cick the Insert tab and then click Table in the Tables group : Textbook Chapter 4 2 of 2 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 : Textbook Chapter 4 0 of 2 Question 5. Question : (TCO 4) Which of the following best describes conditional formatting? Highlights or emphasizes cells that meet certain conditions Tags a table element as a reference in a formula Formats the condition of the worksheet in preparation for printing Calculates an aggregate for values in a range or database : Textbook Chapter 4 2 of 2 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 : Textbook Chapter 4 0 of 2 Question 7. Question : (TCO 4) When data is grouped, the margin area displays the _____. aggregate columns group headings collapse and expand buttons group totals : Textbook Chapter 5 0 of 2 Question 8. Question : (TCO 4) To add a PivotTable, choose the Insert PivotTable command from the _____ group. tables format layout chart : Textbook Chapter 5 0 of 2 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 : Textbook Chapter 5 0 of 2 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 : Textbook Chapter 5 0 of 2 Question 11. Question : (TCO 4) Excel applies basic formatting to PivotTables such as _____. subtotals in italics primary row labels in bold primary row labels in italics subtotals in red : Textbook Chapter 5 2 of 2 Question 12. Question : (TCO 4) What are the areas of a PivotTable Report where fields can be placed? Criteria Range and Extract Range Values, Axis Fields, Legend Fields, and Report Filter Values, Row Labels, Column Labels, and Report Filter Database, Field, and Criteria : Textbook Chapter 5 2 of 2 Question 13. Question : (TCO 4) After a PivotChart has been created, the PivotTable Settings can still be changed by using the _____. PivotTable Field List Chart Layout command Format Tab Data Tab : Textbook Chapter 5 2 of 2 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 : Textbook Chapter 5 0 of 2 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

(TCO 4) In Excel, a dataset would be which of the following?

Indicates where data starts on a new printed page

Collection of structured, related data in columns and rows

Freezing rows to keep them visible

Freezing panes to keep them visible

: Textbook Chapter 4

2 of 2

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

: Textbook Chapter 4

2 of 2

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 Ex

Attachments
devry_bis155_week_3_quiz_3_latest_all_correct.docx
devry_bis155_we...