Question 1

What is the error message when you attempt to use a cell that has been deleted as a function argument?

Accepted Answer

A)  #NPV? 
B)  #NAME? 
C)  #REF! 
D)  #N/A 
A)  #NPV? 
B)  #NAME? 
C)  #REF! 
D)  #N/A

Question 2

A named range is a group of cells that have been given a name,which you can use when writing a formula or function.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

When cell A4 containing the formula =$B$5/$C$6 is copied to cell F6,the formula in cell F6 is ________.

Accepted Answer

A)  =G7/H8 
B)  =$G$7/$H$8 
C)  =B5/C6 
D)  =$B$5/$C$6 
A)  =G7/H8 
B)  =$G$7/$H$8 
C)  =B5/C6 
D)  =$B$5/$C$6

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

The result of =LEFT("Washington",4)is Wash.

Accepted Answer

A) True 
 B)False

Question 7

B7 is an example of a(n)________ cell reference.

Accepted Answer

The answer of B7 is an example of a(n)________ cell...

Question 8

Which of the following is NOT a financial function?

Accepted Answer

A)  PMT 
B)  APR 
C)  PPMT 
D)  NPV 
A)  PMT 
B)  APR 
C)  PPMT 
D)  NPV

Question 9

The ________ logical function returns true only if one of its arguments is true.

Accepted Answer

The answer of The ________ logical function returns true only...

Question 10

Match between columns
                        Premises: Cell reference
Named range
Mixed cell reference
Relative cell reference
Absolute cell reference

Accepted Answer

The Answer of Changes automatically when the formula or function is...

Question 11

The inputs used by an Excel function to calculate a result are called ________.

Accepted Answer

A)  parameters 
B)  arguments 
C)  dependent variables 
D)  independent variables 
A)  parameters 
B)  arguments 
C)  dependent variables 
D)  independent variables

Question 12

If you wanted to determine how many cells in a range are not empty,you would use the ________ function.

Accepted Answer

A)  HASVALUE 
B)  NOTEMPTY 
C)  COUNT 
D)  COUNTA 
A)  HASVALUE 
B)  NOTEMPTY 
C)  COUNT 
D)  COUNTA

Question 13

The ________ function returns the number of workdays between to dates.

Accepted Answer

A)  NETWORKDAYS 
B)  WORKINGDAYS 
C)  DAYS 
D)  WEEKNUM 
A)  NETWORKDAYS 
B)  WORKINGDAYS 
C)  DAYS 
D)  WEEKNUM

Question 14

A(n)________ function determines if a statement is either true or false.

Accepted Answer

The answer of A(n)________ function determines if a statement is...

Question 15

The result of =ROUND(123.456,2)is ________.

Accepted Answer

The answer of The result of =ROUND(123.456,2)is ________....

Question 16

The ________ logical function will return one of two values depending upon whether the logical test being evaluated is true or false.

Accepted Answer

The answer of The ________ logical function will return one...

Question 17

Match between columns
                        Premises: INT
COUNT
ABS
ROUND
COUNTA

Accepted Answer

The Answer of Changes negative numbers to positive numbers and is...

Question 18

________ recognizes patterns in data as you type and automatically fills in values for text and numeric data.

Accepted Answer

The answer of ________ recognizes patterns in data as you...

Question 19

The result of =FIND("is","Mississippi",3)is ________.

Accepted Answer

A)  5 
B)  2 
C)  4 
D)  6 
A)  5 
B)  2 
C)  4 
D)  6

Question 20

The ________ function is similar to looking up a phone number in a phone book.

Accepted Answer

The answer of The ________ function is similar to looking...

What is the error message when you attempt to use a cell that has been deleted as a function argument?

A named range is a group of cells that have been given a name,which you can use when writing a formula or function.

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

When cell A4 containing the formula =$B$5/$C$6 is copied to cell F6,the formula in cell F6 is ________.

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

The result of =LEFT("Washington",4)is Wash.

B7 is an example of a(n)________ cell reference.

Which of the following is NOT a financial function?

The ________ logical function returns true only if one of its arguments is true.

The inputs used by an Excel function to calculate a result are called ________.

If you wanted to determine how many cells in a range are not empty,you would use the ________ function.

The ________ function returns the number of workdays between to dates.

A(n)________ function determines if a statement is either true or false.

The result of =ROUND(123.456,2)is ________.

The ________ logical function will return one of two values depending upon whether the logical test being evaluated is true or false.

________ recognizes patterns in data as you type and automatically fills in values for text and numeric data.

The result of =FIND("is","Mississippi",3)is ________.

The ________ function is similar to looking up a phone number in a phone book.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Effective Charts

The Four Main Database Objects

Tables,Keys,and Relationships

Queries and Data Access

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters

Exam 9: Cell References, Named Ranges, and Functions

What is the error message when you attempt to use a cell that has been deleted as a function argument?

A named range is a group of cells that have been given a name,which you can use when writing a formula or function.

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

When cell A4 containing the formula =$B$5/$C$6 is copied to cell F6,the formula in cell F6 is ________.

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

The result of =LEFT("Washington",4)is Wash.

B7 is an example of a(n)________ cell reference.

Which of the following is NOT a financial function?

The ________ logical function returns true only if one of its arguments is true.

The inputs used by an Excel function to calculate a result are called ________.

If you wanted to determine how many cells in a range are not empty,you would use the ________ function.

The ________ function returns the number of workdays between to dates.

A(n)________ function determines if a statement is either true or false.

The result of =ROUND(123.456,2)is ________.

The ________ logical function will return one of two values depending upon whether the logical test being evaluated is true or false.

________ recognizes patterns in data as you type and automatically fills in values for text and numeric data.

The result of =FIND("is","Mississippi",3)is ________.

The ________ function is similar to looking up a phone number in a phone book.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Effective Charts

The Four Main Database Objects

Tables,Keys,and Relationships

Queries and Data Access

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters