GO! Excel 2016 Chapter 3 Practice Exam

¡Supera tus tareas y exámenes ahora con Quizwiz!

A chart title can be taken from a cell in a worksheet. True False

t

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

t

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

t

Every Excel formula starts with an equal sign (=). True False

t

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

t

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

t

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

t

The Chart Elements button allows you to add, remove, or change chart elements. True False

t

The Format Painter button can be accessed from the mini toolbar. True False

t

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

t

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

t

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

t

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

t

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

t

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 False

t

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 False

t

Which of the following resides along the left side of a column chart? The plot area The y-axis The x-axis The legend

the y-axis

In Goal Seek, you enter the specific value that you want to achieve in the ________ box. By changing cell To value Set cell Goal Seek dialog

to value

To what extent can a pie chart be rotated? Up to 360 degrees Up to 180 degrees Up to 45 degrees Up to 90 degrees

up to 360 degrees

Which of the following is the second order of operations? Division Expressions within parentheses Exponentiation Multiplication

Exponentiation

How can you identify the Chart Elements button when you select a chart? It looks like a funnel. It is a green plus sign. It is a percent sign. It looks like a paintbrush.

It is a green plus sign.

Which symbol represents that a cell is an absolute cell reference in a function or formula? * & % $

$

Which of the following displays trends over time? A pie chart A line chart What-if analysis An axis

a line chart

A(n) ________ refers to a cell by its fixed position in the worksheet. data marker absolute cell reference relative cell reference 3-D cell reference

absolute cell reference

A chart and all of its elements is known as the ________. plot area axis chart area chart sheet

chart area

A ________ in a pie chart identifies the pie slices. data series data point data marker data label

data label

A Major unit value in a line chart determines the range of numbers in the value axis. True False

f

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

f

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

f

All Excel charts have a minimum of three background elements. True False

f

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

f

The chart area is the background and surrounding border of a chart. True False

f

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

f

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

f

________ is an Excel tool that finds the input needed to arrive at a desired result. Goal Seek Formula AutoComplete A bevel A what-if analysis

goal seek

Which of the following is NOT one of the three spatial dimensions of 3-D? Width Length Height Depth

height

In Goal Seek, the ________ box contains the formula that calculates the information you seek. To value By changing cell Set cell Goal Seek dialog

set cell

3-D is short for three-dimensional. True False

t

Goal Seek is a what-if analysis tool. True False

t

To size a chart proportionately, hold down the ________ key and ________. Shift; drag a left or right sizing handle Shift; drag a top or bottom sizing handle Ctrl; drag a corner sizing handle Shift; drag a corner sizing handle

Shift; drag a corner sizing handle

Which of the following is TRUE about a pie chart? A pie chart should be your first choice when there are two data series to plot. It displays data that is arranged in one or more columns or rows or data. A pie chart has a minimum of three data series. It shows the relationship of each part to a whole.

It shows the relationship of each part to a whole.

Where is the Format Painter button located? On the mini toolbar and the Pay Layout tab On the mini toolbar and the Design tab On the Home tab and the Page Layout tab On the mini toolbar and the Home tab

On the mini toolbar and the Home tab

If you edit data in a worksheet that is associated with a pie chart ________. an error message will display a new, second pie chart must be created the pie slices must be manually updated the pie slices will be automatically updated

the pie slices will be automatically updated

In a line chart, which of the following resides along the bottom of the chart? The legend The plot area The x-axis The y-axis

the x-axis

________ is a group of related data points represented by data markers. A data series The x-axis A value axis The y-axis

A data series

Use the ________ key to select A5:A8 and D5:D8. $ Ctrl Alt Shift

ctrl

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

f

Only one piece of a pie can be exploded. True False

f


Conjuntos de estudio relacionados

Mortgages, Financing A Car, Financial Math Sem 2, Leasing vs. Buying a Car, Test, mortgages, buying vs.renting a home, Buying vs. Renting a Home Practice/Quiz, Topic Test - Mathematical Models with Applications, Annuities - Mathematical Models with A...

View Set

Adult Nursing: Integumentary System

View Set

Anatomy & Physiology - Module 2 Exam - Tissues and Skin

View Set

AP psychology study set from whole year

View Set

APUSH: Chapter 9 study questions

View Set

Reproduction and Clotting NUR 2712C

View Set