Question 1

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

Accepted Answer

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. 
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 2

Only one piece of a pie can be exploded.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

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

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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 
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 10

Which of the following displays trends over time?

Accepted Answer

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

In a line chart,which of the following resides along the bottom of the 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

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is the second order of operations?

Accepted Answer

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

Question 17

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

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 
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 18

Which of the following is the first order of operations?

Accepted Answer

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

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

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

Only one piece of a pie can be exploded.

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

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

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

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

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

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

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

Which of the following displays trends over time?

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

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

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

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

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

Which of the following is the second order of operations?

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

Which of the following is the first order of operations?

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

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

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

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

Only one piece of a pie can be exploded.

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

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

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

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

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

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

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

Which of the following displays trends over time?

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

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

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

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

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

Which of the following is the second order of operations?

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

Which of the following is the first order of operations?

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

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

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