Question 1

Which of the following is NOT a common error message?

Accepted Answer

A)  #NAME? 
B)  #NPV? 
C)  #REF! 
D)  #VALUE! 
A)  #NAME? 
B)  #NPV? 
C)  #REF! 
D)  #VALUE! B

Question 2

The process of removing unwanted characters,rearranging data in a cell,or correcting erroneous data in text is called ________.

Accepted Answer

A)  Flash Fill 
B)  concatenating 
C)  cleansing 
D)  purifying 
A)  Flash Fill 
B)  concatenating 
C)  cleansing 
D)  purifying C

Question 3

If you incorrectly name a range,you can rename it by selecting the data and naming the range again.

Accepted Answer

A) True 
 B)False  True

Question 4

Absolute cell referencing uses the # symbol.

Accepted Answer

A) True 
 B)False

Question 5

A(n)________ range 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)________ range is an extension of a...

Question 6

________ functions are functions that manage,manipulate,and format strings.

Accepted Answer

The answer of ________ functions are functions that manage,manipulate,and format...

Question 7

An example of a ________ is (C5+D5)/100.

Accepted Answer

A)  function 
B)  text string 
C)  named range 
D)  formula 
A)  function 
B)  text string 
C)  named range 
D)  formula

Question 8

The result of =DATEDIF("12/21/2014","11/02/2016","Y")is 2.

Accepted Answer

A) True 
 B)False

Question 9

Excel's ________ function returns the current date and time.

Accepted Answer

The answer of Excel's ________ function returns the current date...

Question 10

To return the number of cells in a range of cells that contain numeric data,use the ________ function.

Accepted Answer

The answer of To return the number of cells in...

Question 11

The ________ command produces multiple named ranges at one time from the headings in rows,columns,or both from the data set.

Accepted Answer

A)  Create New Names 
B)  Define Names 
C)  Create from Selection 
D)  Alt + Shift + F11 
A)  Create New Names 
B)  Define Names 
C)  Create from Selection 
D)  Alt + Shift + F11

Question 12

An example of a ________ is SUM(A1:A10)

Accepted Answer

A)  function 
B)  text string 
C)  named range 
D)  formula 
A)  function 
B)  text string 
C)  named range 
D)  formula

Question 13

________ text involves removing unwanted characters,rearranging data in a cell,or correcting erroneous data.

Accepted Answer

The answer of ________ text involves removing unwanted characters,rearranging data...

Question 14

The ________ function calculates the difference between two dates.

Accepted Answer

The answer of The ________ function calculates the difference between...

Question 15

Which of the following is NOT a Lookup or Reference function?

Accepted Answer

A)  VLOOKUP 
B)  INDEX 
C)  FIND 
D)  MATCH 
A)  VLOOKUP 
B)  INDEX 
C)  FIND 
D)  MATCH

Question 16

In the number set 1 to 5,3 would be the middle of the data or the ________.

Accepted Answer

The answer of In the number set 1 to 5,3...

Question 17

Match between columns
                        Premises: IF
VLOOKUP
OR
AND
PMT

Accepted Answer

The Answer of Returns one of two values depending upon is...

Question 18

A name of a range can begin with the / symbol.

Accepted Answer

A) True 
 B)False

Question 19

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 20

The TODAY and NOW functions return the same result.

Accepted Answer

A) True 
 B)False

Which of the following is NOT a common error message?

The process of removing unwanted characters,rearranging data in a cell,or correcting erroneous data in text is called ________.

If you incorrectly name a range,you can rename it by selecting the data and naming the range again.

Absolute cell referencing uses the # symbol.

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

________ functions are functions that manage,manipulate,and format strings.

An example of a ________ is (C5+D5)/100.

The result of =DATEDIF("12/21/2014","11/02/2016","Y")is 2.

Excel's ________ function returns the current date and time.

To return the number of cells in a range of cells that contain numeric data,use the ________ function.

The ________ command produces multiple named ranges at one time from the headings in rows,columns,or both from the data set.

An example of a ________ is SUM(A1:A10)

________ text involves removing unwanted characters,rearranging data in a cell,or correcting erroneous data.

The ________ function calculates the difference between two dates.

Which of the following is NOT a Lookup or Reference function?

In the number set 1 to 5,3 would be the middle of the data or the ________.

A name of a range can begin with the / symbol.

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

The TODAY and NOW functions return the same result.

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

Which of the following is NOT a common error message?

The process of removing unwanted characters,rearranging data in a cell,or correcting erroneous data in text is called ________.

If you incorrectly name a range,you can rename it by selecting the data and naming the range again.

Absolute cell referencing uses the # symbol.

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

________ functions are functions that manage,manipulate,and format strings.

An example of a ________ is (C5+D5)/100.

The result of =DATEDIF("12/21/2014","11/02/2016","Y")is 2.

Excel's ________ function returns the current date and time.

To return the number of cells in a range of cells that contain numeric data,use the ________ function.

The ________ command produces multiple named ranges at one time from the headings in rows,columns,or both from the data set.

An example of a ________ is SUM(A1:A10)

________ text involves removing unwanted characters,rearranging data in a cell,or correcting erroneous data.

The ________ function calculates the difference between two dates.

Which of the following is NOT a Lookup or Reference function?

In the number set 1 to 5,3 would be the middle of the data or the ________.

A name of a range can begin with the / symbol.

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

The TODAY and NOW functions return the same result.

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