Deck 3: Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Question 1

A ________ in a pie chart identifies the pie slices.

A)data series
B)data label
C)data marker
D)data point

Answer 1

B

Question 2

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

A)To value
B)Set cell
C)By changing cell
D)Goal Seek dialog

Answer 2

A

Question 3

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

A)relative cell reference
B)absolute cell reference
C)3-D cell reference
D)data marker

Answer 3

B

Question 4

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

A)chart sheet
B)chart area
C)plot area
D)axis

Question 5

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

A)It is a green plus sign.
B)It looks like a funnel.
C)It looks like a paintbrush.
D)It is a percent sign.

Question 6

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

A)To value
B)Set cell
C)By changing cell
D)Goal Seek dialog

Question 7

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

A)Goal Seek
B)what-if analysis
C)General fund analysis
D)Relative cell reference

Question 8

To what extent can a pie chart be rotated?

A)Up to 360 degrees
B)Up to 180 degrees
C)Up to 90 degrees
D)Up to 45 degrees

Question 9

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

A)Alt
B)Shift
C)$
D)Ctrl

Question 10

Which of the following is the second order of operations?

A)Multiplication
B)Division
C)Expressions within parentheses
D)Exponentiation

Question 11

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

A)It is left-aligned on the page.
B)It is right-aligned on the page.
C)It is centered on the page.
D)It is has a default footer and page number.

Question 12

Which of the following is the first order of operations?

A)Multiplication
B)Division
C)Expressions within parentheses
D)Exponentiation

Question 13

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

A)Goal Seek
B)Formula AutoComplete
C)A what-if analysis
D)A bevel

Question 14

Where is the Format Painter button located?

A)On the mini toolbar and the Design tab
B)On the mini toolbar and the Pay Layout tab
C)On the Home tab and the Page Layout tab
D)On the mini toolbar and the Home tab

Question 15

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

A)one range
B)two ranges
C)at least three ranges
D)four or more ranges

Question 16

Which of the following is TRUE about a pie chart?

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

Question 17

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

A)Depth
B)Length
C)Width
D)Height

Question 18

________ is a group of related data points represented by data markers.

A)A data series
B)A value axis
C)The y-axis
D)The x-axis

Question 19

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

A)%
B)&
C)$
D)*

Question 20

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

A)the pie slices must be manually updated
B)an error message will display
C)the pie slices will be automatically updated
D)a new,second pie chart must be created

Question 21

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

Question 22

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

A)with two or more cells
B)with a minimum of three cells
C)through the use of a formula
D)through the use of a function

Question 23

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

Question 24

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

Question 25

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

Question 26

Which of the following displays trends over time?

A)A pie chart
B)An axis
C)What-if analysis
D)A line chart

Question 27

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

Question 28

Which of the following resides along the left side of a column chart?

A)The x-axis
B)The plot area
C)The y-axis
D)The legend

Question 29

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

A)The x-axis
B)The plot area
C)The y-axis
D)The legend

Question 30

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.

Question 31

Only one piece of a pie can be exploded.

Question 32

3-D is short for three-dimensional.

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

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

A)Ctrl;drag a corner sizing handle
B)Shift;drag a left or right sizing handle
C)Shift;drag a top or bottom sizing handle
D)Shift;drag a corner sizing handle

Question 39

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

Question 40

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.

Question 41

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

Question 42

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

Question 43

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

Question 44

All Excel charts have a minimum of three background elements.

Question 45

A(n)________ displays the relationship of each part of a whole.

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

A(n)________ refers to a cell by its fixed position in a worksheet;the reference will not change when copied and pasted.

Question 55

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

Question 56

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

Question 57

Goal Seek is a what-if analysis tool.

Question 58

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

Question 59

A(n)________ is a value in a worksheet cell that is represented in a chart by a data marker.

Question 60

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

Question 61

Match each of the following terms to its definition:
I.bevel
II.3-D
III.explode
IV.order of operations
V.line chart
A.width,length,and depth
B.shape effect that uses shading and shadows
C.pulling out one or more piece of a pie chart
D.displays trends over time
E.a set of mathematical rules

Question 62

Excel follows a set of mathematical rules called the ________.

Question 63

Goal Seek is a ________ tool in Excel 2016.

Question 64

When a worksheet is selected that is part of a group,the [Group] notation displays in the ________.

Question 65

A workbook sheet that contains only a chart is a(n)________.

Question 66

________ within parentheses are processed first within the order of operations.

Question 67

Match each of the following terms to its definition:
I.data series
II.chart sheet
III.pie chart
IV.legend
V.chart area
A.entire chart and all of its elements
B.shows the relationship of parts to a whole
C.identifies the data markers in a chart
D.a worksheet that contains only a chart
E.related data points represented by data markers

Question 68

Match each of the following mathematical operations to its order:
I.multiplication and division
II.addition and subtraction
III.expressions within parentheses
IV.exponentiation
A.first
B.second
C.third
D.fourth

Question 69

The ________ is the entire chart and all of its elements.

Question 70

In a(n)________ time is displayed along the bottom axis and data point values connect in the chart to show a trend over time.

Question 71

Match each of the following terms to its definition:
I.fund
II.general fund
III.enterprise fund
IV.data series
V.axis
A.money set aside for the normal operating activities of a city
B.border a chart plot area
C.set of data that is represented by data markers
D.sum of money set aside for a specific purpose
E.money for municipal services for which a fee is charged

Question 72

A line that serves as a frame of reference for measurement in a chart is a(n)________.

Question 73

A(n)________ chart emphasizes the flow from one data point value to the next.

Question 74

Match each of the following terms to its definition:
I.line chart
II.axis
III.plot area
IV.x-axis
V.y-axis
A.a part of a chart bounded by the axes
B.also known as the category axis
C.displays trends over time
D.a line that serves as a frame of reference in a chart
E.also known as the value axis

Question 75

Match each of the following terms to its definition:
I.Goal Seek
II.what-if analysis
III.Format Painter
IV.Formula Bar
V.Formula AutoComplete
A.a feature that applies formats one cell or range to another cell or range
B.a part of the Excel window that displays the results of a cell
C.a feature that finds the input needed in one cell to arrive at a desired result in another cell
D.process of changing values in cells to see how those changes affect the outcome of formulas in a worksheet
E.a feature that displays function names based on the first letter that you type

Question 76

A shape effect that uses shading and shadows is a ________.

Question 77

Match each of the following terms to its definition:
I.absolute cell reference
II.relative cell reference
III.data point
IV.data marker
V.data series
A.a group of related data points
B.the representation in a chart of a value from a worksheet
C.a value that originates in a worksheet cell and is used in a chart
D.changes when a formula is copied and pasted
E.does not change when a formula is copied and pasted

Question 78

One or more pieces of a pie chart can be ________,or pulled out,for emphasis.

Question 79

In the ________ pane,you can change the bounds of the axes.