Question 1

-In the accompanying figure,item 2 refers to the ____.

Accepted Answer

A)  cell name 
B)  range name 
C)  worksheet name 
D)  workbook name 
A)  cell name 
B)  range name 
C)  worksheet name 
D)  workbook name C

Question 2

If a value in a formula is not available,the error value #VALUE! will display in the cell.

Accepted Answer

A) True 
 B)False  False

Question 3

To name a range,select the range and then click the Define Name button in the Defined Names group.

Accepted Answer

A) True 
 B)False  True

Question 4

The symbol  stands for "equal to."

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is NOT one of the arguments of a PMT function?

Accepted Answer

A)  payment 
B)  pv 
C)  nper 
D)  rate 
A)  payment 
B)  pv 
C)  nper 
D)  rate

Question 6

-In the accompanying figure,which of the three banks offers the lowest interest rate?

Accepted Answer

A)  Commercial Bank 
B)  Venture Credit Union 
C)  First National Bank 
D)  All three offer the same interest rate. 
A)  Commercial Bank 
B)  Venture Credit Union 
C)  First National Bank 
D)  All three offer the same interest rate.

Question 7

Which comparison operator means not equal to?

Accepted Answer

A)   
B)  #=# 
C)  ## 
D)  !! 
A)   
B)  #=# 
C)  ## 
D)  !!

Question 8

A delimiter is a data separator.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is NOT a comparison operator you can use in Excel?

Accepted Answer

A)   
C)  = 
D)  $ 
A)   
C)  = 
D)  $

Question 10

If a number is divided by zero,the error value #DIV / 0! will display in the cell.

Accepted Answer

A) True 
 B)False

Question 11

The ____________________ function returns TRUE if any of its arguments are true.

Accepted Answer

The answer of The ____________________ function returns TRUE if any...

Question 12

-A cell with a(n)____________________ reference contains a formula that refers to its own cell location.

Accepted Answer

The answer of  
-A cell with a(n)____________________ reference contains...

Question 13

Which Excel function averages cells in a range based on a specified condition?

Accepted Answer

A)  AVERAGEIF 
B)  AVERAGE 
C)  COUNTIF 
D)  SUMIF 
A)  AVERAGEIF 
B)  AVERAGE 
C)  COUNTIF 
D)  SUMIF

Question 14

Which error code will display if a formula contains a text error?

Accepted Answer

A)  #NA 
B)  #NUM! 
C)  #NAME? 
D)  ##### 
A)  #NA 
B)  #NUM! 
C)  #NAME? 
D)  #####

Question 15

Which error code will display if a column is not wide enough to display data?

Accepted Answer

A)  ##### 
B)  #NUM! 
C)  #NULL! 
D)  #NA 
A)  ##### 
B)  #NUM! 
C)  #NULL! 
D)  #NA

Question 16

Which error code will display if a number is used invalidly in a cell?

Accepted Answer

A)  #NUM! 
B)  #VAL 
C)  #VALUE! 
D)  #NAME? 
A)  #NUM! 
B)  #VAL 
C)  #VALUE! 
D)  #NAME?

Question 17

Which Excel function counts the number of cells in a range?

Accepted Answer

A)  SUMIF 
B)  AVERAGEIF 
C)  COUNTIF 
D)  TOTALSUM 
A)  SUMIF 
B)  AVERAGEIF 
C)  COUNTIF 
D)  TOTALSUM

Question 18

-In the accompanying figure,item number ____________________ indicates the function name.

Accepted Answer

The answer of  
-In the accompanying figure,item number ____________________...

Question 19

Which error code will display if a value in a formula is not available?

Accepted Answer

A)  #NAME? 
B)  #VAL 
C)  #NONE 
D)  #NA 
A)  #NAME? 
B)  #VAL 
C)  #NONE 
D)  #NA

Question 20

Cell references that reference other sheets behind the summary sheet are known as ____ references.

Accepted Answer

A)  3-D 
B)  Mirror 
C)  Backstage 
D)  Stage 
A)  3-D 
B)  Mirror 
C)  Backstage 
D)  Stage

-In the accompanying figure,item 2 refers to the ____.

If a value in a formula is not available,the error value #VALUE! will display in the cell.

To name a range,select the range and then click the Define Name button in the Defined Names group.

The symbol < > stands for "equal to."

Which of the following is NOT one of the arguments of a PMT function?

-In the accompanying figure,which of the three banks offers the lowest interest rate?

Which comparison operator means not equal to?

A delimiter is a data separator.

Which of the following is NOT a comparison operator you can use in Excel?

If a number is divided by zero,the error value #DIV / 0! will display in the cell.

The ____________________ function returns TRUE if any of its arguments are true.

-A cell with a(n)____________________ reference contains a formula that refers to its own cell location.

Which Excel function averages cells in a range based on a specified condition?

Which error code will display if a formula contains a text error?

Which error code will display if a column is not wide enough to display data?

Which error code will display if a number is used invalidly in a cell?

Which Excel function counts the number of cells in a range?

-In the accompanying figure,item number ____________________ indicates the function name.

Which error code will display if a value in a formula is not available?

Cell references that reference other sheets behind the summary sheet are known as ____ references.

Word 2013 : Creating and Formatting Tables

Word 2013 : Illustrating Documents With Graphics

Word 2013 : Working With Themes and Building Blocks

Word 2013 : Merging Word Documents

Powerpoint 2013 : Working With Advanced Tools and Masters

Powerpoint 2013 : Enhancing Charts

Powerpoint 2013 : Inserting Graphics, Media, and Objects

Powerpoint 2013 : Using Advanced Features

Integration : Integrating Word and Excel

Integration : Integrating Word, Excel, and Access

Integration : Integrating Word, Excel, Access, and Powerpoint

Excel 2013 : Managing Workbook Data

Excel 2013 : Managing Data Using Tables

Excel 2013 : Analyzing Table Data

Access 2013 : Modifying the Database Structure

Access 2013 : Improving Queries

Access 2013 : Enhancing Forms

Access 2013 : Analyzing Data With Reports

Working in the Cloud

Filters

Exam 12: Excel 2013 : Analyzing Data Using Formulas

-In the accompanying figure,item 2 refers to the ____.

If a value in a formula is not available,the error value #VALUE! will display in the cell.

To name a range,select the range and then click the Define Name button in the Defined Names group.

The symbol < > stands for "equal to."

Which of the following is NOT one of the arguments of a PMT function?

-In the accompanying figure,which of the three banks offers the lowest interest rate?

Which comparison operator means not equal to?

A delimiter is a data separator.

Which of the following is NOT a comparison operator you can use in Excel?

If a number is divided by zero,the error value #DIV / 0! will display in the cell.

The ____________________ function returns TRUE if any of its arguments are true.

-A cell with a(n)____________________ reference contains a formula that refers to its own cell location.

Which Excel function averages cells in a range based on a specified condition?

Which error code will display if a formula contains a text error?

Which error code will display if a column is not wide enough to display data?

Which error code will display if a number is used invalidly in a cell?

Which Excel function counts the number of cells in a range?

-In the accompanying figure,item number ____________________ indicates the function name.

Which error code will display if a value in a formula is not available?

Cell references that reference other sheets behind the summary sheet are known as ____ references.

Word 2013 : Creating and Formatting Tables

Word 2013 : Illustrating Documents With Graphics

Word 2013 : Working With Themes and Building Blocks

Word 2013 : Merging Word Documents

Powerpoint 2013 : Working With Advanced Tools and Masters

Powerpoint 2013 : Enhancing Charts

Powerpoint 2013 : Inserting Graphics, Media, and Objects

Powerpoint 2013 : Using Advanced Features

Integration : Integrating Word and Excel

Integration : Integrating Word, Excel, and Access

Integration : Integrating Word, Excel, Access, and Powerpoint

Excel 2013 : Managing Workbook Data

Excel 2013 : Managing Data Using Tables

Excel 2013 : Analyzing Table Data

Access 2013 : Modifying the Database Structure

Access 2013 : Improving Queries

Access 2013 : Enhancing Forms

Access 2013 : Analyzing Data With Reports

Working in the Cloud

Filters