Question 1

Excel includes predesigned templates,for example for a budget.

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

chart area

Question 3

The Select locked cells option enables you to click the locked cell and ________ the formulas.

Accepted Answer

A) view 
B) delete 
C) modify 
D) format 
A) view 
B) delete 
C) modify 
D) format A

Question 4

Which of the following SmartArt graphic categories would be best to show a timeline?

Accepted Answer

A) List 
B) Pyramid 
C) Cycle 
D) Process 
A) List 
B) Pyramid 
C) Cycle 
D) Process

Question 5

The two main reasons for creating templates for commonly used forms in an organization are ________.

Accepted Answer

A) lookup and validation 
B) validation and standardization 
C) standardization and protection 
D) validation and relationship 
A) lookup and validation 
B) validation and standardization 
C) standardization and protection 
D) validation and relationship

Question 6

All shapes in an organization chart must be the same color.

Accepted Answer

A) True 
 B)False

Question 7

When you open a template from the Templates folder in Backstage view,a new copy of the template opens as a workbook.

Accepted Answer

A) True 
 B)False

Question 8

When creating a column chart,selecting ________ for the data helps the reader understand the chart.

Accepted Answer

A) labels 
B) columns 
C) totals 
D) rows 
A) labels 
B) columns 
C) totals 
D) rows

Question 9

The ________ controls the minimum,maximum,and incremental values on the value axis.

Accepted Answer

The answer of The ________ controls the minimum,maximum,and incremental values...

Question 10

You cannot add additional shapes to a SmartArt graphic.

Accepted Answer

A) True 
 B)False

Question 11

A Process SmartArt graphic can display steps in a process or a ________.

Accepted Answer

The answer of A Process SmartArt graphic can display steps...

Question 12

Both charts and SmartArt graphics depend on underlying data in a worksheet.

Accepted Answer

A) True 
 B)False

Question 13

To make comparisons among related data,use a ________ chart.

Accepted Answer

A) line 
B) pie 
C) column 
D) scatter 
A) line 
B) pie 
C) column 
D) scatter

Question 14

Templates can only be used on the computer on which they are created.

Accepted Answer

A) True 
 B)False

Question 15

The ________ is the range of numbers in the data series and that controls the minimum,maximum,and incremental values on the value axis.

Accepted Answer

A) legend 
B) template 
C) scale 
D) matrix 
A) legend 
B) template 
C) scale 
D) matrix

Question 16

To display trends over time,use a ________ chart.

Accepted Answer

A) line 
B) bar 
C) column 
D) pie 
A) line 
B) bar 
C) column 
D) pie

Question 17

In order for individuals completing your form to type their data into designated cells,the cells must be ________.

Accepted Answer

A) selected 
B) unlocked 
C) password 
D) unprotected 
A) selected 
B) unlocked 
C) password 
D) unprotected

Question 18

A(n)________ graphic is a graphical tool that depicts ideas or associations.

Accepted Answer

The answer of A(n)________ graphic is a graphical tool that...

Question 19

The chart element that identifies the patterns or colors that are assigned to the categories in the chart is the ________.

Accepted Answer

The answer of The chart element that identifies the patterns...

Question 20

As you create a chart,you can make choices about what data to include.

Accepted Answer

A) True 
 B)False

Excel includes predesigned templates,for example for a budget.

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

The Select locked cells option enables you to click the locked cell and ________ the formulas.

Which of the following SmartArt graphic categories would be best to show a timeline?

The two main reasons for creating templates for commonly used forms in an organization are ________.

All shapes in an organization chart must be the same color.

When you open a template from the Templates folder in Backstage view,a new copy of the template opens as a workbook.

When creating a column chart,selecting ________ for the data helps the reader understand the chart.

The ________ controls the minimum,maximum,and incremental values on the value axis.

You cannot add additional shapes to a SmartArt graphic.

A Process SmartArt graphic can display steps in a process or a ________.

Both charts and SmartArt graphics depend on underlying data in a worksheet.

To make comparisons among related data,use a ________ chart.

Templates can only be used on the computer on which they are created.

The ________ is the range of numbers in the data series and that controls the minimum,maximum,and incremental values on the value axis.

To display trends over time,use a ________ chart.

In order for individuals completing your form to type their data into designated cells,the cells must be ________.

A(n)________ graphic is a graphical tool that depicts ideas or associations.

The chart element that identifies the patterns or colors that are assigned to the categories in the chart is the ________.

As you create a chart,you can make choices about what data to include.

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

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

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

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 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 6: Excell: Creating Charts, Diagrams, and Templates

Excel includes predesigned templates,for example for a budget.

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

The Select locked cells option enables you to click the locked cell and ________ the formulas.

Which of the following SmartArt graphic categories would be best to show a timeline?

The two main reasons for creating templates for commonly used forms in an organization are ________.

All shapes in an organization chart must be the same color.

When you open a template from the Templates folder in Backstage view,a new copy of the template opens as a workbook.

When creating a column chart,selecting ________ for the data helps the reader understand the chart.

The ________ controls the minimum,maximum,and incremental values on the value axis.

You cannot add additional shapes to a SmartArt graphic.

A Process SmartArt graphic can display steps in a process or a ________.

Both charts and SmartArt graphics depend on underlying data in a worksheet.

To make comparisons among related data,use a ________ chart.

Templates can only be used on the computer on which they are created.

The ________ is the range of numbers in the data series and that controls the minimum,maximum,and incremental values on the value axis.

To display trends over time,use a ________ chart.

In order for individuals completing your form to type their data into designated cells,the cells must be ________.

A(n)________ graphic is a graphical tool that depicts ideas or associations.

The chart element that identifies the patterns or colors that are assigned to the categories in the chart is the ________.

As you create a chart,you can make choices about what data to include.

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

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

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

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