Devry bUs155 week 3 quiz 3 latest

Question (TCO 4) In Excel, a dataset would be which of the following?Indicates where data starts on a new printed pageCollection of structured, related data in columns and rowsFreezing rows to keep them visibleFreezing panes to keep them visible: Textbook Chapter 42 of 2Question 2. Question : (TCO 4) Which of the following best describes a page break?Freezes only the top rowThe sequence in which pages printIndicates where data starts on a new printed pageStops the printer from printing: Textbook Chapter 42 of 2Question 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 Tableselect any cell in the worksheet and then click Existing Range in the Tools groupclick in a cell and on the Home tab, and click the Insert arrow in the Cells groupcick the Insert tab and then click Table in the Tables group: Textbook Chapter 42 of 2Question 4. Question : (TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____.a Date Filtera Text Filterthe use of a table element as a formulaa Number Filter: Textbook Chapter 40 of 2Question 5. Question : (TCO 4) Which of the following best describes conditional formatting?Highlights or emphasizes cells that meet certain conditionsTags a table element as a reference in a formulaFormats the condition of the worksheet in preparation for printingCalculates an aggregate for values in a range or database: Textbook Chapter 42 of 2Question 6. Question : (TCO 4) In addition to sorting and filtering cells by content, you can sort and/or filter by _____.top/bottom rulesconditional formattingicon setsthe data bar: Textbook Chapter 40 of 2Question 7. Question : (TCO 4) When data is grouped, the margin area displays the _____.aggregate columnsgroup headingscollapse and expand buttonsgroup totals: Textbook Chapter 50 of 2Question 8. Question : (TCO 4) To add a PivotTable, choose the Insert PivotTable command from the _____ group. tablesformatlayoutchart: Textbook Chapter 50 of 2Question 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 LabelsReport FilterRow LabelsValues: Textbook Chapter 50 of 2Question 10. Question : (TCO 4) To create a calculated field, select _____ located on the PivotTable Tools Options tab.CalculationsInsert Calculated Field dialog launcherToolsPivotTable Calculation: Textbook Chapter 50 of 2Question 11. Question : (TCO 4) Excel applies basic formatting to PivotTables such as _____.subtotals in italicsprimary row labels in boldprimary row labels in italicssubtotals in red: Textbook Chapter 52 of 2Question 12. Question : (TCO 4) What are the areas of a PivotTable Report where fields can be placed?Criteria Range and Extract RangeValues, Axis Fields, Legend Fields, and Report FilterValues, Row Labels, Column Labels, and Report FilterDatabase, Field, and Criteria: Textbook Chapter 52 of 2Question 13. Question : (TCO 4) After a PivotChart has been created, the PivotTable Settings can still be changed by using the _____.PivotTable Field ListChart Layout commandFormat TabData Tab: Textbook Chapter 52 of 2Question 14. Question : (TCO 4) Click the _____ to sort or filter the chart representation based on the values.Axis Field arrowsReport Filter arrowsValues arrowsLegend Field arrows: Textbook Chapter 50 of 2Question 15. Question : (TCO 4) Which of the following will NOT delete a PivotChart?Go to the Home tab and click CutRight-click the chart and click CutSelect the chart and then press DeleteClick and drag the PivotChart off the worksheet