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 
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) * 
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 
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. 
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 
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 
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 
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 
A) The x-axis 
B) The plot area 
C) The y-axis 
D) The legend

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?

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Creating Pivottables and Pivotcharts

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: Using Macros and Visual Basic for Applications

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters

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?

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Creating Pivottables and Pivotcharts

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: Using Macros and Visual Basic for Applications

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters