Question 1

A chart and all of its elements is known as the ________.

Accepted Answer

A) chart sheet 
B) chart area 
C) plot area 
D) axis 
A) chart sheet 
B) chart area 
C) plot area 
D) axis

Question 2

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

Accepted Answer

A) money set aside for the normal operating activities of a city 
B) border a chart plot area 
C) set of data that is represented by data markers 
D) sum of money set aside for a specific purpose 
E) money for municipal services for which a fee is charged 
A) money set aside for the normal operating activities of a city 
B) border a chart plot area 
C) set of data that is represented by data markers 
D) sum of money set aside for a specific purpose 
E) money for municipal services for which a fee is charged

Question 3

When you select the data range for a pie chart,you should be sure to include the total cell on the worksheet.

Accepted Answer

A) True 
 B)False

Question 4

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 5

Every Excel formula starts with an equal sign (=).

Accepted Answer

A) True 
 B)False

Question 6

Excel follows a set of mathematical rules called the ________.

Accepted Answer

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

Question 7

The order of data in the worksheet determines how the pie slices are ordered in a pie chart.

Accepted Answer

A) True 
 B)False

Question 8

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

A) entire chart and all of its elements 
B) shows the relationship of parts to a whole 
C) identifies the data markers in a chart 
D) a worksheet that contains only a chart 
E) related data points represented by data markers 
A) entire chart and all of its elements 
B) shows the relationship of parts to a whole 
C) identifies the data markers in a chart 
D) a worksheet that contains only a chart 
E) related data points represented by data markers

Question 9

The Chart Elements button allows you to add,remove,or change chart elements.

Accepted Answer

A) True 
 B)False

Question 10

All Excel charts have a minimum of three background elements.

Accepted Answer

A) True 
 B)False

Question 11

When you group sheets,only one sheet can be viewed in Print Preview.

Accepted Answer

A) True 
 B)False

Question 12

You can edit the data or a label in a cell by double-clicking the cell and then positioning the insertion point within the cell.

Accepted Answer

A) True 
 B)False

Question 13

A(n)________ refers to a cell by its fixed position in a worksheet;the reference will not change when copied and pasted.

Accepted Answer

absolute c

Question 14

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

A) a group of related data points 
B) the representation in a chart of a value from a worksheet 
C) a value that originates in a worksheet cell and is used in a chart 
D) changes when a formula is copied and pasted 
E) does not change when a formula is copied and pasted 
A) a group of related data points 
B) the representation in a chart of a value from a worksheet 
C) a value that originates in a worksheet cell and is used in a chart 
D) changes when a formula is copied and pasted 
E) does not change when a formula is copied and pasted

Question 15

The y-axis of a chart is also referred to as the value axis.

Accepted Answer

A) True 
 B)False

Question 16

How can you identify the Chart Elements button when you select a chart?

Accepted Answer

A) It is a green plus sign. 
B) It looks like a funnel. 
C) It looks like a paintbrush. 
D) It is a percent sign. 
A) It is a green plus sign. 
B) It looks like a funnel. 
C) It looks like a paintbrush. 
D) It is a percent sign.

Question 17

A Major unit value in a line chart determines the range of numbers in the value axis.

Accepted Answer

A) True 
 B)False

Question 18

Goal Seek is a what-if analysis tool.

Accepted Answer

A) True 
 B)False

Question 19

In a formula,a % sign designates that a cell in a formula is an absolute.

Accepted Answer

A) True 
 B)False

Question 20

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

A) a feature that applies formats one cell or range to another cell or range 
B) a part of the Excel window that displays the results of a cell 
C) a feature that finds the input needed in one cell to arrive at a desired result in another cell 
D) process of changing values in cells to see how those changes affect the outcome of formulas in a worksheet 
E) a feature that displays function names based on the first letter that you type 
A) a feature that applies formats one cell or range to another cell or range 
B) a part of the Excel window that displays the results of a cell 
C) a feature that finds the input needed in one cell to arrive at a desired result in another cell 
D) process of changing values in cells to see how those changes affect the outcome of formulas in a worksheet 
E) a feature that displays function names based on the first letter that you type

A chart and all of its elements is known as the ________.

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

When you select the data range for a pie chart,you should be sure to include the total cell on the worksheet.

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

Every Excel formula starts with an equal sign (=).

Excel follows a set of mathematical rules called the ________.

The order of data in the worksheet determines how the pie slices are ordered in a pie chart.

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

The Chart Elements button allows you to add,remove,or change chart elements.

All Excel charts have a minimum of three background elements.

When you group sheets,only one sheet can be viewed in Print Preview.

You can edit the data or a label in a cell by double-clicking the cell and then positioning the insertion point within the cell.

A(n)________ refers to a cell by its fixed position in a worksheet;the reference will not change when copied and pasted.

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

The y-axis of a chart is also referred to as the value axis.

How can you identify the Chart Elements button when you select a chart?

A Major unit value in a line chart determines the range of numbers in the value axis.

Goal Seek is a what-if analysis tool.

In a formula,a % sign designates that a cell in a formula is an absolute.

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

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 and all of its elements is known as the ________.

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

When you select the data range for a pie chart,you should be sure to include the total cell on the worksheet.

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

Every Excel formula starts with an equal sign (=).

Excel follows a set of mathematical rules called the ________.

The order of data in the worksheet determines how the pie slices are ordered in a pie chart.

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

The Chart Elements button allows you to add,remove,or change chart elements.

All Excel charts have a minimum of three background elements.

When you group sheets,only one sheet can be viewed in Print Preview.

You can edit the data or a label in a cell by double-clicking the cell and then positioning the insertion point within the cell.

A(n)________ refers to a cell by its fixed position in a worksheet;the reference will not change when copied and pasted.

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

The y-axis of a chart is also referred to as the value axis.

How can you identify the Chart Elements button when you select a chart?

A Major unit value in a line chart determines the range of numbers in the value axis.

Goal Seek is a what-if analysis tool.

In a formula,a % sign designates that a cell in a formula is an absolute.

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

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