Question 1

A common example of a text delimiter is ____.

Accepted Answer

A)  , 
B)  = 
C)  + 
D)  ( 
A)  , 
B)  = 
C)  + 
D)  (

Question 2

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

Accepted Answer

A)  cell reference 
B)  worksheet name 
C)  function name 
D)  workbook name 
A)  cell reference 
B)  worksheet name 
C)  function name 
D)  workbook name

Question 3

-In the accompanying figure,there are ____ arguments in the formula.

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 4

Cell and range names can use uppercase and lowercase letters,digits,and spaces.

Accepted Answer

A) True 
 B)False

Question 5

-In the accompanying figure,which numbered item identifies the logical test?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 6

You cannot use the fill handle to copy a formula with an external reference indicator.

Accepted Answer

A) True 
 B)False

Question 7

-A(n)____________________ is a data separator; Excel uses it to separate data into columns.

Accepted Answer

The answer of  
-A(n)____________________ is a data separator; Excel...

Question 8

A condition that can be answered with a true or false response is called a(n)____.

Accepted Answer

A)  logical test. 
B)  what-if analysis. 
C)  True_False condition 
D)  IF analysis 
A)  logical test. 
B)  what-if analysis. 
C)  True_False condition 
D)  IF analysis

Question 9

Which Excel function checks for errors and displays a message you specify if there is an error in a formula.

Accepted Answer

A)  ERROR 
B)  #ERROR 
C)  IFERROR 
D)  #IFERROR 
A)  ERROR 
B)  #ERROR 
C)  IFERROR 
D)  #IFERROR

Question 10

Which of the following is not a valid named range?

Accepted Answer

A)  Alaska59 
B)  New quote 
C)  salary 
D)  Top_Sales 
A)  Alaska59 
B)  New quote 
C)  salary 
D)  Top_Sales

Question 11

One way to check worksheet formulas for errors is to display the formulas on the worksheet rather then the formula results.

Accepted Answer

A) True 
 B)False

Question 12

You can link a formula to both another worksheet and to another workbook.

Accepted Answer

A) True 
 B)False

Question 13

Names that you assign to cells and cell ranges can be used in formulas.

Accepted Answer

A) True 
 B)False

A common example of a text delimiter is ____.

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

-In the accompanying figure,there are ____ arguments in the formula.

Cell and range names can use uppercase and lowercase letters,digits,and spaces.

-In the accompanying figure,which numbered item identifies the logical test?

You cannot use the fill handle to copy a formula with an external reference indicator.

-A(n)____________________ is a data separator; Excel uses it to separate data into columns.

A condition that can be answered with a true or false response is called a(n)____.

Which Excel function checks for errors and displays a message you specify if there is an error in a formula.

Which of the following is not a valid named range?

One way to check worksheet formulas for errors is to display the formulas on the worksheet rather then the formula results.

You can link a formula to both another worksheet and to another workbook.

Names that you assign to cells and cell ranges can be used in formulas.

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

A common example of a text delimiter is ____.

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

-In the accompanying figure,there are ____ arguments in the formula.

Cell and range names can use uppercase and lowercase letters,digits,and spaces.

-In the accompanying figure,which numbered item identifies the logical test?

You cannot use the fill handle to copy a formula with an external reference indicator.

-A(n)____________________ is a data separator; Excel uses it to separate data into columns.

A condition that can be answered with a true or false response is called a(n)____.

Which Excel function checks for errors and displays a message you specify if there is an error in a formula.

Which of the following is not a valid named range?

One way to check worksheet formulas for errors is to display the formulas on the worksheet rather then the formula results.

You can link a formula to both another worksheet and to another workbook.

Names that you assign to cells and cell ranges can be used in formulas.

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