Access over 20 million homework & study documents

search

1 (TCO 4) If there are certain columns of information that are not

Content type
User Generated
Rating
Showing Page:
1/4
1. (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. (Points : 2)
hide
delete
freeze
format
Question 2.2. (TCO 4) Which of the following best
describes a page break? (Points : 2)
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.3. (TCO 4) To convert a table back into a
range, _____. (Points : 2)
click within the table, click the Table Tools Design
tab, and then select Convert to Range
click the Insert tab and then click Range in the Range
group
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
Question 4.4. (TCO 4) Filtering the Cost column (field) to
show only records greater than $10,000 is an application
of _____. (Points : 2)
a Date Filter
a Text Filter
the use of a table element as a formula
a Number Filter
Question 5.5. (TCO 4) To apply a red background color to
cells for employees who have sales greater than $1,000,
you can use _____. (Points : 2)
a pivot table

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/4
a multiple level sort
conditional formatting
a range name
Question 6.6. (TCO 4) Using Conditional Formatting to
draw attention to cells containing errors _____. (Points : 2)
helps locate errors in cells quickly
displays a particular color based on the relative value
of the cell contents to other selected cells
calculates an aggregate for values in a range or
database
displays an icon representing a value in the top third
based on values in the selected range
Question 7.7. (TCO 4) The Subtotal command is located on
the _____ tab. (Points : 2)
data
formula
page layout
insert
Question 8.8. (TCO 4) _____ are created to organize and
summarize data in pivot tables. (Points : 2)
Categories
Types
Titles
Levels
Question 9.9. (TCO 4) Data mining techniques, such as
pivot tables can detect _____ of data. (Points : 2)
patterns
categories
styles
groups
Question 10.10. (TCO 4) To create a calculated field,
select _____ located on the Pivot Table Tools Options tab.
(Points : 2)
Calculations
Insert Calculated Field dialog launcher
Tools

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/4

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 4 pages?
Access Now
Unformatted Attachment Preview
1. (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. (Points : 2) hide delete freeze format Question 2.2. (TCO 4) Which of the following best describes a page break? (Points : 2) Freezes only the top row The sequence in which pages print Indicates where data starts on a new print ed page Stops the printer from printing Question 3.3. (TCO 4) To convert a table back into a range, _____. (Points : 2) click within the table, click the Table Tools Design tab, and then select Convert to Range click the Insert tab and then click Range in the Range group 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 Question 4.4. (TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____. (Points : 2) a Date Filter a Text Filter the use of a table element as a formula a Number Filter Question 5.5. (TCO 4) To apply a red b ackground color to cells for employees who have sales greater th ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4