Moving one or more slices of a pie chart away from the pie creates a(n) ____.

The image below shows a portion of an Excel table that shows information about company employees and their payroll.  A fixed bonus percentage will be used to pay bonuses for any employee whose rating value is not “Poor”.  Which Excel function should be used in the formula in cell I4 to display whether the employee will get a bonus?   

Using the image below, match the correct function that would be used for each of the indicated cells.     

If you delete a pivot table that has an associated pivot chart on the same worksheet, what happens to the pivot chart?

When creating footers, you can have Excel automatically insert the page numbers.

In an Excel table, it is impossible to sort the table data by more than one column using only the Filter arrows.

A pivot chart will change automatically when you change the filtering in its associated pivottable.

An Excel formula always begins with a(n) ____.

When using numeric values in a formula, they must not be enclosed in quotation marks.

The image below shows a portion of an Excel table that shows information about art items and their condition.  A restoration cost will be incurred only in the case where the art item is more than 10 years old.  Which Excel function should be used in the formula in cell K4 to display whether the art item will incur a restoration cost?