Excel Chapter Ten

Macro.

A _________ is created by perfroming a set of steps and recording the steps as they are performed.

In order to use the power tools.

Data analysis commands are required

Use Relative Reference.

If you will be using keyboard navigation when creating a macro, you must ensure that the '________' button in the Code group on the DEVELOPER tab is selected so that the macro works properly.

True.

PivotTables can be made without Power Pivot.

Tiles.

Power View uses ________ to group Data.

False.

The 3D Maps command opens a window that uses a few of your computer's resources.

False.

The Get & Transform command does not allow you to edit imported data.

Online Analytical Processing.

What does OLAP stand for?

Open the user's default email handler.

You can create hyperlinks to ______.

Trust Center.

You can enable or disable macros with options in the _________ dialog box.