Chapter 3

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

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

Ctrl

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

$

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

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

Shift; drag a corner sizing handle

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

A ________ in a pie chart identifies the pie slices.

data label

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

set cell

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 analysis

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

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


संबंधित स्टडी सेट्स

Pharm Test 2 Practice questions endocrine med-math GI

View Set

Unit 9: Chemical Reaction Test Review

View Set

Chapter 4 Protein Structure and Function

View Set

med surg test 1 pp, Rasmussen: Nursing 1 Exam 1, Nursing 1 Exam #1 naomi, Rasmussen: Nursing 1 Exam 1 naomi

View Set

Converting between Decimal and Binary

View Set