A(n) predefined calculation performs numeric, date, and text computations on each record using data from one or more fields. _________________________

When a form is selected, the Conditional Formatting button is found in the ________ group under the Format tab

A) Font B) Number C) Control Formatting D) Background

Which of the following options is the best tool when using a PivotTable that contains more data than you currently need?

A) Removing a value field B) Sorting C) Refreshing the data D) Filtering