Blog

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

The image below shows a portion of an Excel table that shows information about registrations for seminars.  A room change is needed only in the case where the number of people registered is greater than the capacity of the room.  Which Excel function should be used in the formula in cell K2 to display whether a room change is needed?  

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

Use the image below to match answers with the questions.  

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

In Excel, text values appear ____-aligned in the cell by default.

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

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

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?