Quiz 3

Which symbol represents that a cell is an absolute cell reference in a function or formula?

$

If you edit data in a worksheet that is associated with a pie chart ________.

the pie slices will be automatically updated

You must select ________ on a worksheet to create a pie chart.

two ranges

The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as ________.

what-if anaysis

AutoFill will fill a series when you establish a pattern ________.

with two or more cells

________ is a group of related data points represented by data markers.

A data series

Which of the following displays trends over time?

A line chart

Use the ________ key to select A5:A8 and D5:D8.

Ctrl

Which of the following is the second order of operations?

Exponentiation

Which of the following is the first order of operations?

Expressions within parentheses

________ is an Excel tool that finds the input needed to arrive at a desired result.

Goal Seek

Which of the following is NOT one of the three spatial dimensions of 3-D?

Height

How can you identify the Chart Elements button when you select a chart?

It is a green plus sign

When you print a chart sheet, how is it automatically formatted?

It is centered on the page

Which of the following is TRUE about a pie chart?

It shows the relationship of each part to a whole

Where is the Format Painter button located?

On the mini toolbar and the Home tab

In Goal Seek, the ________ box contains the formula that calculates the information you seek.

Set Cell

To size a chart proportionately, hold down the ________ key and ________.

Shift; drag a corner sizing handle

In a line chart, which of the following resides along the bottom of the chart?

The X-Axis

Which of the following resides along the left side of a column chart?

The y-axis

In Goal Seek, you enter the specific value that you want to achieve in the ________ box.

To value

To what extent can a pie chart be rotated?

Up to 360 degrees

A(n) ________ refers to a cell by its fixed position in the worksheet.

absolute cell reference

A chart and all of its elements is known as the

chart area