Question 1

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

The answer of Match each of the following terms to...

Question 2

Excel follows a set of mathematical rules called the ________.

Accepted Answer

The answer of Excel follows a set of mathematical rules...

Question 3

Goal Seek is a ________ tool in Excel 2016.

Accepted Answer

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

Question 4

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

Accepted Answer

The answer of When a worksheet is selected that is...

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

The answer of ________ within parentheses are processed first within...

Question 7

Match each of the following terms to its definition:
i.data series
II.chart sheet
III.pie chart
IV.legend
v.chart area

Accepted Answer

E) A data series is a set of related data points represented by data markers.  D) A chart sheet is a worksheet that contains only a chart.  B) A pie chart shows the relationship of parts to a whole.  C) A legend identifies the data markers in a chart.  A) The chart area includes the entire chart and all of its elements.

Question 8

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

The answer of Match each of the following mathematical operations...

Question 9

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

Accepted Answer

The answer of The ________ is the entire chart and...

Question 10

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 11

Match each of the following terms to its definition:
i.fund
II.general fund
III.enterprise fund
IV.data series
v.axis

Accepted Answer

The answer of Match each of the following terms to...

Question 12

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 13

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

Accepted Answer

The answer of A(n)________ chart emphasizes the flow from one...

Question 14

Match each of the following terms to its definition:
i.line chart
II.axis
III.plot area
IV.x-axis
v.y-axis

Accepted Answer

The answer of Match each of the following terms to...

Question 15

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

Accepted Answer

- Goal Seek is correctly matched with "a feature that finds the input needed in one cell to arrive at a desired result in another cell" (C).- What-if analysis is the process of changing values in cells to see how those changes affect the outcome of formulas in a worksheet (D).- Format Painter is a feature that applies formats from one cell or range to another cell or range (A).- The Formula Bar is a part of the Excel window that displays the results of a cell, but more accurately, it displays the content or formula used in the active cell (B).- Formula AutoComplete is a feature that displays function names based on the first letter that you type, helping to complete formulas faster and with fewer errors (E).

Question 16

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

Accepted Answer

The answer of A shape effect that uses shading and...

Question 17

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

Accepted Answer

The answer of Match each of the following terms to...

Question 18

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

Accepted Answer

The answer of One or more pieces of a pie...

Question 19

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

Accepted Answer

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

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

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

Excel follows a set of mathematical rules called the ________.

Goal Seek is a ________ tool in Excel 2016.

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

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

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

Match each of the following terms to its definition: i.data series II.chart sheet III.pie chart IV.legend v.chart area

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

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

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

Match each of the following terms to its definition: i.fund II.general fund III.enterprise fund IV.data series v.axis

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

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

Match each of the following terms to its definition: i.line chart II.axis III.plot area IV.x-axis v.y-axis

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 shape effect that uses shading and shadows is a ________.

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

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

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