Order ready-to-submit essays. No Plagiarism Guarantee!
Note: All our papers are written from scratch by human writers to ensure authenticity and originality.
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.
Verify your essay before you submit. Get an Official Turnitin Report for Just $8.99!
Check your paper with the same Turnitin report your professor uses. AI detection + similarity score without storing your work. Pay once, no subscription
Check My Assignment!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
