Details of this Paper

DEVRY BIS155 week 3 quiz




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 nameQuestion 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


Paper#36895 | Written in 18-Jul-2015

Price : $19