Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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.

Accepted Answer

A) True 
 B)False

Question 3

A ________ in a pie chart identifies the pie slices.

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

The answer of A line that serves as a frame...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

The answer of In the ________ pane,you can change the...

Question 9

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

Accepted Answer

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

Question 10

Match each of the following terms to its definition:
i.bevel
II.3-D
III.explode
IV.order of operations
v.line chart

Accepted Answer

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 11

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

Accepted Answer

The answer of In a(n)________ time is displayed along the...

Question 12

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

Accepted Answer

The answer of A workbook sheet that contains only a...

Question 13

Which of the following is TRUE about a pie chart?

Accepted Answer

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 14

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

Accepted Answer

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

Question 15

Match each of the following mathematical operations to its order:
i.multiplication and division
II.addition and subtraction
III.expressions within parentheses
IV.exponentiation

Accepted Answer

A) first 
B) second 
C) third 
D) fourth

Question 16

Goal Seek is a ________ tool in Excel 2016.

Accepted Answer

The answer of Goal Seek is a ________ tool in...

Question 17

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

Accepted Answer

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 18

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

Accepted Answer

The answer of A(n)________ displays the relationship of each part...

Question 19

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

Accepted Answer

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

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

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

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.

A ________ in a pie chart identifies the pie slices.

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

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

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

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

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

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

Match each of the following terms to its definition: i.bevel II.3-D III.explode IV.order of operations v.line chart

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

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

Which of the following is TRUE about a pie chart?

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

Match each of the following mathematical operations to its order: i.multiplication and division II.addition and subtraction III.expressions within parentheses IV.exponentiation

Goal Seek is a ________ tool in Excel 2016.

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

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

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