Question 1. � Question : � (TCO 4) If there are certain columns of information that are not needed at a particular time but might be needed later, _____ the unneeded columns to allow users to focus on only the essential information. hide delete freeze format Question 2. � Question : � (TCO 4) In Excel, the print area is defined as _____. an individual piece of data, such as a last name a complete set of data for an entity the sequence in which pages print the range of data to print Question 3. � Question : � (TCO 4) When sorting in Excel, it arranges records in a table _____. by the number of pages in the worksheet by the number of pages in the workbook by the value in field(s) within a table by permanently removing extraneous data Question 4. � Question : � (TCO 4) Filtering the Last_Name column (field) to show only records that begin with the letter S is an application of _____. the use of a table element as a formula a Number Filter a Text Filter a Date 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 pivot table a multiple level sort conditional formatting a range name 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 Question 7. � Question : � (TCO 4) For subtotals to be useful and accurate, it is important that the data be _____ correctly. sorted formatted aligned labeled Question 8. � Question : � (TCO 4) _____ are created to organize and summarize data in pivot tables. Categories Types Titles Levels Question 9. � Question : � (TCO 4) Data mining techniques, such as pivot tables can detect _____ of data. patterns categories styles groups Question 10. Question : � (TCO 4) To create a calculated field, select _____ located on the Pivot Table Tools Options tab. Calculations Tools Pivot Table Calculation None of the above 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) To go to the top of your spreadsheet quickly, use the _____ key(s). Ctrl+End Arrow Ctrl+Home Esc Question 14. Question : � (TCO 4) When Excel creates a PivotChart it uses the current PivotTable settings – if you want to change that data you might use Insert PivotTable Insert Function PivotTable Field List Filter Connections Question 15. Question : � (TCO 4) Which of the following will NOT delete a pivot chart? 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 pivot chart off the worksheet
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer