Question 1

A logical function that returns a result of TRUE if all of the conditions are met.

Accepted Answer

A) AND 
B) IF 
C) NOT 
D) OR 
A) AND 
B) IF 
C) NOT 
D) OR

Question 2

Solver is an analysis tool that is installed automatically when Excel is first installed.

Accepted Answer

A) True 
 B)False

Question 3

Fixed expenses remain the same each month regardless of the amount of activity.

Accepted Answer

A) True 
 B)False

Question 4

Optional commands and features that are not immediately available and must first be installed for you to use them are referred to as ________.

Accepted Answer

A) Decision variables 
B) Constraints 
C) Add-ins 
D) Scenarios 
A) Decision variables 
B) Constraints 
C) Add-ins 
D) Scenarios

Question 5

On a line chart,you can change the ________ of the vertical axis to provide more vertical space and a more dramatic slope to the lines.

Accepted Answer

A) balance 
B) degree 
C) scale 
D) level 
A) balance 
B) degree 
C) scale 
D) level

Question 6

Use Solver when you need to make a decision that involves more than ________ variable(s).

Accepted Answer

A) four 
B) two 
C) one 
D) three 
A) four 
B) two 
C) one 
D) three

Question 7

A business can use ________ statement to create a line chart that shows income and expenses and the projected break-even point.

Accepted Answer

A) a profit and loss 
B) a summary 
C) an estimated income 
D) a break-even 
A) a profit and loss 
B) a summary 
C) an estimated income 
D) a break-even

Question 8

You can use a ________ chart to display trends over a period of time.

Accepted Answer

The answer of You can use a ________ chart to...

Question 9

When the Scenario Values dialog box displays,it lists the ________ value in each of the decision variable cells.

Accepted Answer

A) total 
B) current 
C) future 
D) past 
A) total 
B) current 
C) future 
D) past

Question 10

When entering a function,optional arguments display in the ScreenTip.

Accepted Answer

A) True 
 B)False

Question 11

A ________ is a sequence of averages computed from parts of a data series that shows a trend more clearly.

Accepted Answer

The answer of A ________ is a sequence of averages...

Question 12

The logical function NOT takes only one argument and tests one condition.

Accepted Answer

A) True 
 B)False

Question 13

Variable expenses vary depending on sales.

Accepted Answer

A) True 
 B)False

Question 14

Expenses are classified according to which two broad categories?

Accepted Answer

A) Stable and fluctuating 
B) Fixed and stable 
C) Fixed and variable 
D) Fluctuating and variable 
A) Stable and fluctuating 
B) Fixed and stable 
C) Fixed and variable 
D) Fluctuating and variable

Question 15

The results of a logical test are either TRUE or FALSE.

Accepted Answer

A) True 
 B)False

Question 16

In Excel,it is NOT possible to create custom date formats.

Accepted Answer

A) True 
 B)False

Question 17

Excel's Data Analysis tools,which range from basic to very sophisticated,can help you project future results based on ________ performance.

Accepted Answer

The answer of Excel's Data Analysis tools,which range from basic...

Question 18

The point at which a business begins to make a profit is known as the ________ point.

Accepted Answer

The answer of The point at which a business begins...

Question 19

When you use a moving average,you choose how many preceding ________ to include in the average.

Accepted Answer

A) sections 
B) options 
C) sequences 
D) intervals 
A) sections 
B) options 
C) sequences 
D) intervals

Question 20

Solver is a tool that you could use to help determine how to minimize weekly payroll expenses.

Accepted Answer

A) True 
 B)False

A logical function that returns a result of TRUE if all of the conditions are met.

Solver is an analysis tool that is installed automatically when Excel is first installed.

Fixed expenses remain the same each month regardless of the amount of activity.

Optional commands and features that are not immediately available and must first be installed for you to use them are referred to as ________.

On a line chart,you can change the ________ of the vertical axis to provide more vertical space and a more dramatic slope to the lines.

Use Solver when you need to make a decision that involves more than ________ variable(s).

A business can use ________ statement to create a line chart that shows income and expenses and the projected break-even point.

You can use a ________ chart to display trends over a period of time.

When the Scenario Values dialog box displays,it lists the ________ value in each of the decision variable cells.

When entering a function,optional arguments display in the ScreenTip.

A ________ is a sequence of averages computed from parts of a data series that shows a trend more clearly.

The logical function NOT takes only one argument and tests one condition.

Variable expenses vary depending on sales.

Expenses are classified according to which two broad categories?

The results of a logical test are either TRUE or FALSE.

In Excel,it is NOT possible to create custom date formats.

Excel's Data Analysis tools,which range from basic to very sophisticated,can help you project future results based on ________ performance.

The point at which a business begins to make a profit is known as the ________ point.

When you use a moving average,you choose how many preceding ________ to include in the average.

Solver is a tool that you could use to help determine how to minimize weekly payroll expenses.

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 Charts, Diagrams, and Templates

Excell: Creating Pivottables and Pivotcharts

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 8: Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

A logical function that returns a result of TRUE if all of the conditions are met.

Solver is an analysis tool that is installed automatically when Excel is first installed.

Fixed expenses remain the same each month regardless of the amount of activity.

Optional commands and features that are not immediately available and must first be installed for you to use them are referred to as ________.

On a line chart,you can change the ________ of the vertical axis to provide more vertical space and a more dramatic slope to the lines.

Use Solver when you need to make a decision that involves more than ________ variable(s).

A business can use ________ statement to create a line chart that shows income and expenses and the projected break-even point.

You can use a ________ chart to display trends over a period of time.

When the Scenario Values dialog box displays,it lists the ________ value in each of the decision variable cells.

When entering a function,optional arguments display in the ScreenTip.

A ________ is a sequence of averages computed from parts of a data series that shows a trend more clearly.

The logical function NOT takes only one argument and tests one condition.

Variable expenses vary depending on sales.

Expenses are classified according to which two broad categories?

The results of a logical test are either TRUE or FALSE.

In Excel,it is NOT possible to create custom date formats.

Excel's Data Analysis tools,which range from basic to very sophisticated,can help you project future results based on ________ performance.

The point at which a business begins to make a profit is known as the ________ point.

When you use a moving average,you choose how many preceding ________ to include in the average.

Solver is a tool that you could use to help determine how to minimize weekly payroll expenses.

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 Charts, Diagrams, and Templates

Excell: Creating Pivottables and Pivotcharts

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