What can you use to easily filter pivot tables interactively in a worksheet?

The PivotTable cache    Each time that you create a new PivotTable or PivotChart, Excel stores a copy of the data for the report in memory, and saves this storage area as part of the workbook file - this is called the PivotTable cache. Each new PivotTable requires additional memory and disk space. However, when you use an existing PivotTable as the source for a new one in the same workbook, both share the same cache. Because you reuse the cache, the workbook size is reduced and less data is kept in memory.

Location requirements    To use one PivotTable as the source for another, both must be in the same workbook. If the source PivotTable is in a different workbook, copy the source to the workbook location where you want the new one to appear. PivotTables and PivotCharts in different workbooks are separate, each with its own copy of the data in memory and in the workbooks.

Changes affect both PivotTables    When you refresh the data in the new PivotTable, Excel also updates the data in the source PivotTable, and vice versa. When you group or ungroup items, or create calculated fields or calculated items in one, both are affected. If you need to have a PivotTable that's independent of another one, then you can create a new one based on the original data source, instead of copying the original PivotTable. Just be mindful of the potential memory implications of doing this too often.

PivotCharts     You can base a new PivotTable or PivotChart on another PivotTable, but you cannot base a new PivotChart directly on another PivotChart. Changes to a PivotChart affect the associated PivotTable, and vice versa.

A

Shapes

B

Picture Cropping

C

Screen Clipping

D

Screenshot

ANSWER & EXPLANATION

Correct Answer: (c)

No Explanation

A

Word

B

Smart cell

C

Excel

D

Lotus 1-2-3

ANSWER & EXPLANATION

Correct Answer: (d)

No Explanation

A

Goal seek

B

Solver

C

Scenario manager

D

Auto Outline

ANSWER & EXPLANATION

Correct Answer: (d)

No Explanation

A

Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows

B

Select the range you want, include both cells, point to fill on the Edit menu, and then click down.

C

Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special

D

All of above

ANSWER & EXPLANATION

Correct Answer: (a)

No Explanation

A

Formula

B

Field

C

Data

D

Query Correct Answer:

ANSWER & EXPLANATION

Correct Answer: (a)

No Explanation

A

A cell

B

A block

C

A box

D

None of the above

ANSWER & EXPLANATION

Correct Answer: (a)

No Explanation

A

IF

B

AND

C

OR

D

NOT

ANSWER & EXPLANATION

Correct Answer: (b)

No Explanation

A

Double clicking on the right border of column header

B

From Format choose Columns and then Autofit Selection

C

From Format Cells dialog box mark Shrink to fit check box

D

All of above

ANSWER & EXPLANATION

Correct Answer: (c)

No Explanation

Teachers: Create FREE classroom games with your questions Click for more info!
©2007-2022 ReviewGameZone.com | About | Privacy | Contact | Terms | Site Map