Question 1

Excel offers tools to help you project ________ results based on past performance.

Accepted Answer

A) recent 
B) current 
C) present 
D) future 
A) recent 
B) current 
C) present 
D) future

Question 2

Match the following five terms to their meanings:
i.income
II.expenses
III.fixed expenses
IV.variable expenses
v.break-even point

Accepted Answer

A) For a business,typically classified as fixed or variable. 
B) For a business,this typically consists of sales for products and services. 
C) Expenses that remain the same regardless of amount of activity. 
D) When income equals expenses. 
E) Expenses that vary depending on amount of sales. 
A) For a business,typically classified as fixed or variable. 
B) For a business,this typically consists of sales for products and services. 
C) Expenses that remain the same regardless of amount of activity. 
D) When income equals expenses. 
E) Expenses that vary depending on amount of sales.

Question 3

The custom date code,"ddd,mmm dd" displays in the format ________.

Accepted Answer

A) Wednesday,July 15 
B) Wed,Jul 15 
C) Wednesday,Jul 15 
D) Wed,July 15 
A) Wednesday,July 15 
B) Wed,Jul 15 
C) Wednesday,Jul 15 
D) Wed,July 15

Question 4

When you use the fill handle to copy a formula across columns,cell references that should NOT change must be ________.

Accepted Answer

A) mixed 
B) absolute 
C) relative 
D) constant 
A) mixed 
B) absolute 
C) relative 
D) constant

Question 5

A moving average is based on historical data,and therefore is a good prediction of what will occur in the future.

Accepted Answer

A) True 
 B)False

Question 6

A ________ is a prediction of the future,often based on past performances.

Accepted Answer

The answer of A ________ is a prediction of the...

Question 7

Business owners expect that,at some future point,the business will become ________.

Accepted Answer

A) profitable 
B) adverse 
C) useful 
D) negative 
A) profitable 
B) adverse 
C) useful 
D) negative

Question 8

Variable expenses vary depending on the amount of ________.

Accepted Answer

The answer of Variable expenses vary depending on the amount...

Question 9

After a constraint is added to Solver Parameters,it cannot be deleted.

Accepted Answer

A) True 
 B)False

Question 10

The ________ of a function specifies the arrangement of the arguments in the function.

Accepted Answer

A) criteria 
B) rules 
C) logical functions 
D) syntax 
A) criteria 
B) rules 
C) logical functions 
D) syntax

Question 11

Match the following five terms to their meanings:
i.SUMIF function
II.COUNTIF function
III.logical function
IV.SUMIFS function
v.syntax

Accepted Answer

A) A logical function that counts the cells that meet specific criteria in a specified range. 
B) A logical function that will add values in multiple ranges that meet multiple criteria. 
C) A logical function that will add values in one specified range that meet a certain specific criteria. 
D) A function that tests for specific conditions. 
E) The arrangement of the arguments in a function. 
A) A logical function that counts the cells that meet specific criteria in a specified range. 
B) A logical function that will add values in multiple ranges that meet multiple criteria. 
C) A logical function that will add values in one specified range that meet a certain specific criteria. 
D) A function that tests for specific conditions. 
E) The arrangement of the arguments in a function.

Question 12

The point at which a business begins to make a profit is called the price point.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following would NOT be considered a variable expense for a restaurant?

Accepted Answer

A) Wages 
B) Food 
C) Rent 
D) Beverages 
A) Wages 
B) Food 
C) Rent 
D) Beverages

Question 14

________ is one of Excel's what-if analysis tools with which you can find an optimal value for a formula in one cell.

Accepted Answer

The answer of ________ is one of Excel's what-if analysis...

Question 15

Excel has ________ codes that enable you to display dates in a specific date format.

Accepted Answer

A) symbol 
B) date 
C) text 
D) number 
A) symbol 
B) date 
C) text 
D) number

Question 16

Match the following five terms to their meanings:
i.moving average
II.Add-ins
III.forecast
IV.transpose
v.dual-axis chart

Accepted Answer

A) Optional commands and features that must first be installed. 
B) To predict the future,often based on past performance. 
C) A chart that has one series plotted on a secondary axis. 
D) A sequence of averages computed from parts of a data series. 
E) To switch the data in rows and columns. 
A) Optional commands and features that must first be installed. 
B) To predict the future,often based on past performance. 
C) A chart that has one series plotted on a secondary axis. 
D) A sequence of averages computed from parts of a data series. 
E) To switch the data in rows and columns.

Question 17

The point of profitability is the same as the break-even point.

Accepted Answer

A) True 
 B)False

Question 18

You can use the mathematical operators plus sign (+),minus sign (-),division sign (/),and multiplication sign (*)to build complex formulas.

Accepted Answer

A) True 
 B)False

Question 19

A moving average calculates an average for a group of numbers over a specified interval allowing you to see ________ for widely fluctuating numbers.

Accepted Answer

A) an objective 
B) a trend 
C) a scenario 
D) a constraint 
A) an objective 
B) a trend 
C) a scenario 
D) a constraint

Question 20

If the date formats available in Excel are NOT suitable,you can create a ________ date format.

Accepted Answer

The answer of If the date formats available in Excel...

Excel offers tools to help you project ________ results based on past performance.

Match the following five terms to their meanings: i.income II.expenses III.fixed expenses IV.variable expenses v.break-even point

The custom date code,"ddd,mmm dd" displays in the format ________.

When you use the fill handle to copy a formula across columns,cell references that should NOT change must be ________.

A moving average is based on historical data,and therefore is a good prediction of what will occur in the future.

A ________ is a prediction of the future,often based on past performances.

Business owners expect that,at some future point,the business will become ________.

Variable expenses vary depending on the amount of ________.

After a constraint is added to Solver Parameters,it cannot be deleted.

The ________ of a function specifies the arrangement of the arguments in the function.

Match the following five terms to their meanings: i.SUMIF function II.COUNTIF function III.logical function IV.SUMIFS function v.syntax

The point at which a business begins to make a profit is called the price point.

Which of the following would NOT be considered a variable expense for a restaurant?

________ is one of Excel's what-if analysis tools with which you can find an optimal value for a formula in one cell.

Excel has ________ codes that enable you to display dates in a specific date format.

Match the following five terms to their meanings: i.moving average II.Add-ins III.forecast IV.transpose v.dual-axis chart

The point of profitability is the same as the break-even point.

You can use the mathematical operators plus sign (+),minus sign (-),division sign (/),and multiplication sign (*)to build complex formulas.

A moving average calculates an average for a group of numbers over a specified interval allowing you to see ________ for widely fluctuating numbers.

If the date formats available in Excel are NOT suitable,you can create a ________ date format.

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

Excel offers tools to help you project ________ results based on past performance.

Match the following five terms to their meanings: i.income II.expenses III.fixed expenses IV.variable expenses v.break-even point

The custom date code,"ddd,mmm dd" displays in the format ________.

When you use the fill handle to copy a formula across columns,cell references that should NOT change must be ________.

A moving average is based on historical data,and therefore is a good prediction of what will occur in the future.

A ________ is a prediction of the future,often based on past performances.

Business owners expect that,at some future point,the business will become ________.

Variable expenses vary depending on the amount of ________.

After a constraint is added to Solver Parameters,it cannot be deleted.

The ________ of a function specifies the arrangement of the arguments in the function.

Match the following five terms to their meanings: i.SUMIF function II.COUNTIF function III.logical function IV.SUMIFS function v.syntax

The point at which a business begins to make a profit is called the price point.

Which of the following would NOT be considered a variable expense for a restaurant?

________ is one of Excel's what-if analysis tools with which you can find an optimal value for a formula in one cell.

Excel has ________ codes that enable you to display dates in a specific date format.

Match the following five terms to their meanings: i.moving average II.Add-ins III.forecast IV.transpose v.dual-axis chart

The point of profitability is the same as the break-even point.

You can use the mathematical operators plus sign (+),minus sign (-),division sign (/),and multiplication sign (*)to build complex formulas.

A moving average calculates an average for a group of numbers over a specified interval allowing you to see ________ for widely fluctuating numbers.

If the date formats available in Excel are NOT suitable,you can create a ________ date format.

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