CIS114DE 16581 Quiz#4

Chart area

A chart and all of its elements is known as the ________.

Absolute cell reference

An ________ refers to a cell by its fixed position in the worksheet.

With two or more cells

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

It is a green plus sign.

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

The pie slices will be automatically updated

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

Set cell

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

To value

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

What-if analysis

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

Shift; drag a corner sizing handle

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

up to 360 degrees

To what extent can a pie chart be rotated?

Expressions within parentheses

Which is the first order of operations?

A Line chart

Which of the following displays trends over time?

height

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

$

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

Goal Seek

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