Question 1

________ is the keyboard shortcut to display a list of named ranges.

Accepted Answer

A) F1 
B) F2 
C) F3 
D) F4 
A) F1 
B) F2 
C) F3 
D) F4

Question 2

The OR function returns TRUE if any one of its arguments is true.

Accepted Answer

A) True 
 B)False

Question 3

In financial applications,the word "term" refers to the total time of a loan,usually in months or years.

Accepted Answer

A) True 
 B)False

Question 4

Excel's ________ function rounds a number down to the specified number of digits.

Accepted Answer

The answer of Excel's ________ function rounds a number down...

Question 5

A(n)________is an extension of a cell reference and provides a way to identify commonly used cell references or ranges.

Accepted Answer

The answer of A(n)________is an extension of a cell reference...

Question 6

If you want to find the time between two dates,you would use the ________ function.

Accepted Answer

A) DATE 
B) TIME 
C) DATEDIF 
D) WEEKNUM 
A) DATE 
B) TIME 
C) DATEDIF 
D) WEEKNUM

Question 7

The IFERROR function returns either a specified value if a function or formula returns an error; or it returns the value of the function or formula.

Accepted Answer

A) True 
 B)False

Question 8

The AND function returns FALSE if any one of its arguments is FALSE.

Accepted Answer

A) True 
 B)False

Question 9

In financial applications,the word ________ refers to the frequency of payments,such as monthly payments.

Accepted Answer

The answer of In financial applications,the word ________ refers to...

Question 10

________ refers to the structure and order of the function and the arguments used by Excel to perform a calculation.

Accepted Answer

The answer of ________ refers to the structure and order...

Question 11

Excel's ________ function returns a random number from 0 to less than 1.

Accepted Answer

The answer of Excel's ________ function returns a random number...

Question 12

When cell B2 containing the formula =A4*B6 is copied to cell C1,the formula in cell C1 is ________.

Accepted Answer

A) =A4*B6 
B) =B3*C5 
C) =A4*C5 
D) =B3*C6 
A) =A4*B6 
B) =B3*C5 
C) =A4*C5 
D) =B3*C6

Question 13

Excel's MAXIMUM function returns the largest number from a set of numbers.

Accepted Answer

A) True 
 B)False

Question 14

The result of =ROUNDUP(123.456,0)is ________.

Accepted Answer

The answer of The result of =ROUNDUP(123.456,0)is ________....

Question 15

If you type =C,a list of functions and named ranges beginning with the letter "C" appears.

Accepted Answer

A) True 
 B)False

Question 16

Match between columns Premises: > < <> >= =

Accepted Answer

The Answer of Equal to and Less than and Not is...

Question 17

Excel's TIME function returns the number of minutes in the range 1 to 60.

Accepted Answer

A) True 
 B)False

Question 18

What is the error message when you attempt to multiple a number by text?

Accepted Answer

The answer of What is the error message when you...

Question 19

Which of the following is an alternative to using a space in a named range?

Accepted Answer

A) Use a hyphen 
B) Use an equal sign 
C) Use an underscore 
D) Capitalize the first letter of each word 
A) Use a hyphen 
B) Use an equal sign 
C) Use an underscore 
D) Capitalize the first letter of each word

Question 20

Which of the following is NOT an Excel function category?

Accepted Answer

A) Educational 
B) Cube 
C) Logical 
D) Financial 
A) Educational 
B) Cube 
C) Logical 
D) Financial

________ is the keyboard shortcut to display a list of named ranges.

The OR function returns TRUE if any one of its arguments is true.

In financial applications,the word "term" refers to the total time of a loan,usually in months or years.

Excel's ________ function rounds a number down to the specified number of digits.

A(n)________is an extension of a cell reference and provides a way to identify commonly used cell references or ranges.

If you want to find the time between two dates,you would use the ________ function.

The IFERROR function returns either a specified value if a function or formula returns an error; or it returns the value of the function or formula.

The AND function returns FALSE if any one of its arguments is FALSE.

In financial applications,the word ________ refers to the frequency of payments,such as monthly payments.

________ refers to the structure and order of the function and the arguments used by Excel to perform a calculation.

Excel's ________ function returns a random number from 0 to less than 1.

When cell B2 containing the formula =A4*B6 is copied to cell C1,the formula in cell C1 is ________.

Excel's MAXIMUM function returns the largest number from a set of numbers.

The result of =ROUNDUP(123.456,0)is ________.

If you type =C,a list of functions and named ranges beginning with the letter "C" appears.

Excel's TIME function returns the number of minutes in the range 1 to 60.

What is the error message when you attempt to multiple a number by text?

Which of the following is an alternative to using a space in a named range?

Which of the following is NOT an Excel function category?

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters

Exam 3: Cell References, named Ranges, and Functions

________ is the keyboard shortcut to display a list of named ranges.

The OR function returns TRUE if any one of its arguments is true.

In financial applications,the word "term" refers to the total time of a loan,usually in months or years.

Excel's ________ function rounds a number down to the specified number of digits.

A(n)________is an extension of a cell reference and provides a way to identify commonly used cell references or ranges.

If you want to find the time between two dates,you would use the ________ function.

The IFERROR function returns either a specified value if a function or formula returns an error; or it returns the value of the function or formula.

The AND function returns FALSE if any one of its arguments is FALSE.

In financial applications,the word ________ refers to the frequency of payments,such as monthly payments.

________ refers to the structure and order of the function and the arguments used by Excel to perform a calculation.

Excel's ________ function returns a random number from 0 to less than 1.

When cell B2 containing the formula =A4*B6 is copied to cell C1,the formula in cell C1 is ________.

Excel's MAXIMUM function returns the largest number from a set of numbers.

The result of =ROUNDUP(123.456,0)is ________.

If you type =C,a list of functions and named ranges beginning with the letter "C" appears.

Excel's TIME function returns the number of minutes in the range 1 to 60.

What is the error message when you attempt to multiple a number by text?

Which of the following is an alternative to using a space in a named range?

Which of the following is NOT an Excel function category?

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters