Multiple Choice Question (MCQ) on Auditing Tools in MS-Excel

1.  Which button, when clicked, will highlight cells that do not match existing data validation settings?

A)           Circle Invalid Data

B)           Circle Valid Data

C)           Circle Data Validation

D)           Circle Data List

 

2.  Which error value is displayed if =B30/0 is keyed into a cell?

A)           #DIV/0

B)           #N/A

C)           #NAME?

D)           #NULL!

 

3.  Which button on the Formulas tab, when clicked, points to cells that rely on the value in the active cell?

A)           Trace Precedents

B)           Trace Error

C)           Evaluate Formula

D)           Trace Dependents

 

4.  Which Ribbon command tab includes the Data Validation button?

A)           Formulas

B)           Data

C)           Validation

D)           Review

 

5.  Which command can be set to prohibit or allow a cell entry?

A)           Background error checking

B)           Data validation

C)           Go to Special

D)           Evaluate Formula

 

6.  Which dialog box provides a way to check each part of a formula?

A)           Data Validation

B)           Evaluate Formula

C)           Go To Special

D)           Watch Window

 

7.  If the formula is =IFERROR(C7*2,"Check formula.") and cell C7=January, what will result?

A)           2

B)           January

C)           Check formula.

D)           #VALUE!

 

8.  What button appears when the cursor hovers over a cell with an error triangle?

A)           Error Checking Options

B)           Formula Auditing

C)           Evaluate Formula

D)           Show Formula

 

9.  What is a probable cause of the #NAME? error value message?

A)           The formula uses a value that is not available.

B)           The formula is divided by zero.

C)           The formula uses unrecognized text.

D)           The formula refers to a cell reference that is not valid.

 

10.  What does the error value message #DIV/0 indicate?

A)           The formula uses a value that is not dividable.

B)           The formula divides by zero.

C)           The formula divides by text.

D)           The formula divides by itself.

 

ANSWERS:

1

2

3

4

5

6

7

8

9

10

A

A

D

B

B

B

D

A

C

B

 

Connect with us

We're on Social Networks. Follow us & get in touch.

ONLINE STAT

We have 13 guests and no members online

SPONSORED LINKS

Find us on facebook

You are here: Home Computer Operator Preparation Database System Multiple Choice Question (MCQ) on Auditing Tools in MS-Excel