Question 1

________ is an Excel tool that finds the input needed to arrive at a desired result.

Accepted Answer

A) Goal Seek 
B) Formula AutoComplete 
C) A what-if analysis 
D) A bevel 
A) Goal Seek 
B) Formula AutoComplete 
C) A what-if analysis 
D) A bevel A

Question 2

In Goal Seek,you enter the specific value that you want to achieve in the ________ box.

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 A

Question 3

To size a chart proportionately,hold down the ________ key and ________.

Accepted Answer

A) Ctrl;drag a corner sizing handle 
B) Shift;drag a left or right sizing handle 
C) Shift;drag a top or bottom sizing handle 
D) Shift;drag a corner sizing handle 
A) Ctrl;drag a corner sizing handle 
B) Shift;drag a left or right sizing handle 
C) Shift;drag a top or bottom sizing handle 
D) Shift;drag a corner sizing handle D

Question 4

A graphic image can be inserted into the background of a chart.

Accepted Answer

A) True 
 B)False

Question 5

A(n)________ is a value in a worksheet cell that is represented in a chart by a data marker.

Accepted Answer

The answer of A(n)________ is a value in a worksheet...

Question 6

A chart sheet contains only a chart and the data used to generate that chart.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

When you copy a formula to another cell and the cells in the formula change,the cells are known as relative cell references.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

The plot area of a chart is bounded by the axes,including all the data series.

Accepted Answer

A) True 
 B)False

Question 11

The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as ________.

Accepted Answer

A) Goal Seek 
B) what-if analysis 
C) General fund analysis 
D) Relative cell reference 
A) Goal Seek 
B) what-if analysis 
C) General fund analysis 
D) Relative cell reference

Question 12

3-D is short for three-dimensional.

Accepted Answer

A) True 
 B)False

Question 13

You must select ________ on a worksheet to create a pie chart.

Accepted Answer

A) one range 
B) two ranges 
C) at least three ranges 
D) four or more ranges 
A) one range 
B) two ranges 
C) at least three ranges 
D) four or more ranges

Question 14

To what extent can a pie chart be rotated?

Accepted Answer

A) Up to 360 degrees 
B) Up to 180 degrees 
C) Up to 90 degrees 
D) Up to 45 degrees 
A) Up to 360 degrees 
B) Up to 180 degrees 
C) Up to 90 degrees 
D) Up to 45 degrees

Question 15

When you select a worksheet that is part of a group,[Group] displays in the title bar.

Accepted Answer

A) True 
 B)False

Question 16

A(n)________ refers to a cell by its fixed position in the worksheet.

Accepted Answer

A) relative cell reference 
B) absolute cell reference 
C) 3-D cell reference 
D) data marker 
A) relative cell reference 
B) absolute cell reference 
C) 3-D cell reference 
D) data marker

Question 17

A legend is a chart element that identifies the patterns or colors assigned to each category of a chart.

Accepted Answer

A) True 
 B)False

Question 18

Where is the Format Painter button located?

Accepted Answer

A) On the mini toolbar and the Design tab 
B) On the mini toolbar and the Pay Layout tab 
C) On the Home tab and the Page Layout tab 
D) On the mini toolbar and the Home tab 
A) On the mini toolbar and the Design tab 
B) On the mini toolbar and the Pay Layout tab 
C) On the Home tab and the Page Layout tab 
D) On the mini toolbar and the Home tab

Question 19

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

Accepted Answer

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

Question 20

The chart area is the background and surrounding border of a chart.

Accepted Answer

A) True 
 B)False

________ is an Excel tool that finds the input needed to arrive at a desired result.

In Goal Seek,you enter the specific value that you want to achieve in the ________ box.

To size a chart proportionately,hold down the key and .

A graphic image can be inserted into the background of a chart.

A(n)________ is a value in a worksheet cell that is represented in a chart by a data marker.

A chart sheet contains only a chart and the data used to generate that chart.

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

When you copy a formula to another cell and the cells in the formula change,the cells are known as relative cell references.

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

The plot area of a chart is bounded by the axes,including all the data series.

The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as ________.

3-D is short for three-dimensional.

You must select ________ on a worksheet to create a pie chart.

To what extent can a pie chart be rotated?

When you select a worksheet that is part of a group,[Group] displays in the title bar.

A(n)________ refers to a cell by its fixed position in the worksheet.

A legend is a chart element that identifies the patterns or colors assigned to each category of a chart.

Where is the Format Painter button located?

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

The chart area is the background and surrounding border of a 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

________ is an Excel tool that finds the input needed to arrive at a desired result.

In Goal Seek,you enter the specific value that you want to achieve in the ________ box.

To size a chart proportionately,hold down the ________ key and ________.

A graphic image can be inserted into the background of a chart.

A(n)________ is a value in a worksheet cell that is represented in a chart by a data marker.

A chart sheet contains only a chart and the data used to generate that chart.

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

When you copy a formula to another cell and the cells in the formula change,the cells are known as relative cell references.

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

The plot area of a chart is bounded by the axes,including all the data series.

The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as ________.

3-D is short for three-dimensional.

You must select ________ on a worksheet to create a pie chart.

To what extent can a pie chart be rotated?

When you select a worksheet that is part of a group,[Group] displays in the title bar.

A(n)________ refers to a cell by its fixed position in the worksheet.

A legend is a chart element that identifies the patterns or colors assigned to each category of a chart.

Where is the Format Painter button located?

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

The chart area is the background and surrounding border of a 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

To size a chart proportionately,hold down the key and .