Excel Chapter 3

Réussis tes devoirs et examens dès maintenant avec 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 first order of operations?

Expressions within parentheses

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

_______ 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

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

Which of the following is the second order of operations?

exponentiation

A Major unit value in a line chart determines the range of numbers in the value axis. t/f

false

A chart sheet contains only a chart and the data used to generate that chart. t/f

false

Bevel is a shape effect that uses bolding and colors to make the edges of a shape appear to be straight or diagonal. t/f

false

Consecutive operators with the same level of precedence are calculated from right to left. t/f

false

In a formula, a % sign designates that a cell in a formula is an absolute. t/f

false

Only one piece of a pie can be exploded. t/f

false

The chart area is the background and surrounding border of a chart. t/f

false

Use the F1 key to cancel a moving border after you have copied and pasted. t/f

false

When you group sheets, only one sheet can be viewed in Print Preview. t/f

false

_______ 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

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

set cell

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

3-D is short for three-dimensional. t/f

true

A chart title can be taken from a cell in a worksheet. t/f

true

A graphic image can be inserted into the background of a chart. t/f

true

A legend is a chart element that identifies the patterns or colors assigned to each category of a chart. t/f

true

A pie chart should be considered when you have just one data series to plot. t/f

true

Every Excel formula starts with an equal sign (=). t/f

true

Goal Seek is a what-if analysis tool. t/f

true

If you change the value in a cell referenced in a formula, the result of the formula will automatically recalculate. t/f

true

In Excel, you should use parentheses in order to specify the order in which operations needs to occur. t/f

true

The Chart Elements button allows you to add, remove, or change chart elements. t/f

true

The Format Painter button can be accessed from the mini toolbar. t/f

true

The order of data in the worksheet determines how the pie slices are ordered in a pie chart. t/f

true

The plot area of a chart is bounded by the axes, including all the data series. t/f

true

The y-axis of a chart is also referred to as the value axis. t/f

true

When you copy a formula to another cell and the cells in the formula change, the cells are known as relative cell references. t/f

true

When you select a worksheet that is part of a group, [Group] displays in the title bar. t/f

true

When you select two ranges on a worksheet to create a pie chart, there must be the same number of cells selected in each of the two ranges. t/f

true

You can edit the data or a label in a cell by double-clicking the cell and then positioning the insertion point within the cell. t/f

true

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

two rangers

To what extent can a pie chart be rotated?

up to 360 degrees

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


Ensembles d'études connexes

Zad al-Talibin (Provision for the Seekers) 12- Part 2

View Set

Testing & Prescription Powerpoint 8

View Set

영어패턴233-패턴(1,3) 17-32

View Set

Chapter 1-2 Latin America and the Caribbean

View Set

Linear Algebra exam 1 True/false

View Set

Cell & Molec Exam 4 Ch 19 Text Bank

View Set