excel 3

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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

Ctrl

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

It is centered on the page

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

$

To what extent can a pie chart be rotated

360

is a group of related data points represented by data markers

a data series

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

absolute cell reference

A ________ in a pie chart identifies the pie slices

data label

Which of the following is the first order of operations

expressions within parentheses

A chart sheet contains only a chart and the data used to generate that chart

false

A data marker is a value that originates in a worksheet cell and that is represented in a chart

false

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

false

Consecutive operators with the same level of precedence are calculated from right to left

false

In a formula, a % sign designates that a cell in a formula is an absolute

false

Only one piece of a pie can be exploded

false

Use the F1 key to cancel a moving border after you have copied and pasted

false

When you group sheets, only one sheet can be viewed in Print Preview

false

When you select the data range for a pie chart, you should be sure to include the total cell on the worksheet

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

Which of the following is TRUE about a pie chart

it shows the relationship of each part to a whole

Which of the following displays trends over time

line chart

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

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

Shift; drag a corner sizing handle

Where is the Format Painter button located

On the mini toolbar and the Home tab

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

true

A chart and all of its elements is known as the

true

A graphic image can be inserted into the background of a chart

true

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

true

A pie chart should be considered when you have just one data series to plot

true

Every Excel formula starts with an equal sign (=)

true

Formula AutoComplete displays a list of function names that match the letter or two that you type

true

Goal Seek is a what-if analysis tool

true

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

true

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

true

Numbers that display with E + a number are an exponential notation

true

The Format Painter button can be accessed from the mini toolbar

true

The chart area is the background and surrounding border of a chart

true

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

true

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

true

The y-axis of a chart is also referred to as the value axis

true

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

true

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

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

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

true

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

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

x-axis

Which of the following resides along the left side of a column char

y-axis


Set pelajaran terkait

ECO 155 Chapter 16 (Final Review)

View Set

foundations of entrepreneurship exam #1

View Set

3.5 Profitability and liquidity ratio analysis!

View Set

PrepU Chapter 42: Assessment and Management of Patients with Obesity

View Set

Jazz History Chapter 12 Study Guide

View Set

Advanced Computer Science Chapters 1-8 Multiple Choice

View Set

Med Surg I Prep U Chapter 37: Assessment and Management of Patients With Allergic Disorders

View Set