Chapter 5 Excel Fill in the Blank

row label

A filed that is assigned a row orientation in a Pivot Table report is a(n) _________

Pivot Chart

A graphical representation of the data in a Pivot Table report that is interactive with the Pivot Table is a(n) ___________ report.

=B4>=21

A job requires that the applicant must be at least 21 years old. Assume that age displays in cell B4. Write the formula if the age requirement is met: _________.

NOT

A logical function that returns the opposite result is the _________ function.

page set up

To control if and where comments are printed, use the _________________ dialog box.

properties

To record information about a file, from the Office menu, point to Prepare, and then click _________.

values

The area on a Pivot Table that summarizes quantitative data is labeled ________

false

When using the AND function, if the first argument is true, the second argument is false, and the third argument is true, the results will display _______ .

C5>=2

Write a formula to determine whether an employee has two years if experience (assume that the years of experience display in cell C5): _________ .

percent

In a Pivot Table, the % Difference From calculation displays the results as a(n) _______

Axis Field (Categories)

In a PivotChart, the fields that display in the Row Labels box of the related Pivot Table display in the _________________ box for the Pivot Chart.

basis

In the YEARFRAC functions, an argument that is the type of day count is used to calculate the number of years between two dates is the _______ argument.

automatically updated

Information about a file that is controlled and changed by the system such as file, size and the time the document was last saved is referred to as ________ properties.

standard

Information that you can control such as author name, title, subject and keywords is known as _______ properties.

field

Labels along the top of a column of data that identify the category of data in each column are ______ labels.