Question 1

When you choose ____, Excel disables all macros but retains security alerts about macros in documents that are not stored in a trusted location.

Accepted Answer

A)  Disable all macros without notification 
B)  Disable all macros with notification 
C)  Disable all macros except digitally signed macros 
D)  Enable all macros

Question 2

By default, input messages appear as comments next to the cell when the cell is selected. _________________________

Accepted Answer

A) True 
 B)False

Question 3

MATCHING
  
Identify the letter of the choice that best matches the tools listed above.
-Show Formulas

Accepted Answer

A) #1 
B) #2 
C) #3 
D) #4 
E) #5
F)#6
G)#7
H)#8
I)#9
J)#10
K)#11
L)#12

Question 4

A(n) ____________________ cell contains a formula that refers to other cells.

Accepted Answer

The answer of A(n) ____________________ cell contains a formula that...

Question 5

EPS is calculated by dividing the number of shares outstanding by net income.

Accepted Answer

A) True 
 B)False

Question 6

If you want to prohibit workbook users from adding, renaming, or deleting worksheets in a workbook, you can enable ____ protection.

Accepted Answer

A)  workbook 
B)  worksheet 
C)  data table 
D)  user data

Question 7

MATCHING
  
Identify the letter of the choice that best matches the tools listed above.
-Evaluate Formula

Accepted Answer

A) #1 
B) #2 
C) #3 
D) #4 
E) #5
F)#6
G)#7
H)#8
I)#9
J)#10
K)#11
L)#12

Question 8

Protect and uprotect a workbook using the ____ dialog box.

Accepted Answer

A)  Protect Structure and Windows 
B)  Data Validation 
C)  Protect Sheet 
D)  Format Cells

Question 9

____ is a program that is attached to a file and runs when you open the file. It can harm your computer by changing program settings or deleting hard disk files.

Accepted Answer

A)  A virus 
B)  Adware 
C)  Spyware 
D)  A Trojan horse

Question 10

Displaying an input message when a user clicks a cell is a helpful way to let the user know what type of data to enter in the cell.

Accepted Answer

A) True 
 B)False

Question 11

An error alarm is a message box that displays a message of varying severity. _________________________

Accepted Answer

A) True 
 B)False

Question 12

When you trace dependent cells, you trace the components of a formula that references other cells.

Accepted Answer

A) True 
 B)False

Question 13

____________________ is input data for which you already know the results.

Accepted Answer

The answer of ____________________ is input data for which you...

Question 14

If you double-click the cell containing a formula with an error, Excel displays color-coded borders around related cells.

Accepted Answer

A) True 
 B)False

Question 15

A(n) ____________________ is a system that is used to collect, organize, and process data, and to communicate and distribute the results in a coordinated manner.

Accepted Answer

The answer of A(n) ____________________ is a system that is...

Question 16

You can use the ____ button in the Formula Auditing group to identify parts of a formula that reference other cells.

Accepted Answer

A)  Trace Precedents 
B)  Trace Dependents 
C)  Error Checking 
D)  Show Formulas

Question 17

A ____ worksheet usually contains the workbook title, creation date, name of the person who created the workbook, and any other information that describes the purpose and content of the workbook.

Accepted Answer

A)  documentation 
B)  detailed 
C)  data table 
D)  protected

Question 18

Excel assumes that any text in a formula is either a command word, such as a function name, or a reference to a cell, such as a named range.

Accepted Answer

A) True 
 B)False

Question 19

You can immediately fix the #### error by ____.

Accepted Answer

A)  widening the column 
B)  increasing the height of a row 
C)  changing the formula 
D)  running spellcheck

Question 20

You can use up to three levels of security and protection to control who can access and change your Excel data. Please describe two of the three levels and how you access each of them.

Accepted Answer

The answer of You can use up to three levels...

Exam 10: Troubleshooting Workbooks and Automating Excel Applications

When you choose ____, Excel disables all macros but retains security alerts about macros in documents that are not stored in a trusted location.

By default, input messages appear as comments next to the cell when the cell is selected. _________________________

MATCHING Identify the letter of the choice that best matches the tools listed above. -Show Formulas

A(n) ____________________ cell contains a formula that refers to other cells.

EPS is calculated by dividing the number of shares outstanding by net income.

If you want to prohibit workbook users from adding, renaming, or deleting worksheets in a workbook, you can enable ____ protection.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Evaluate Formula

Protect and uprotect a workbook using the ____ dialog box.

____ is a program that is attached to a file and runs when you open the file. It can harm your computer by changing program settings or deleting hard disk files.

Displaying an input message when a user clicks a cell is a helpful way to let the user know what type of data to enter in the cell.

An error alarm is a message box that displays a message of varying severity. _________________________

When you trace dependent cells, you trace the components of a formula that references other cells.

____________________ is input data for which you already know the results.

If you double-click the cell containing a formula with an error, Excel displays color-coded borders around related cells.

A(n) ____________________ is a system that is used to collect, organize, and process data, and to communicate and distribute the results in a coordinated manner.

You can use the ____ button in the Formula Auditing group to identify parts of a formula that reference other cells.

A ____ worksheet usually contains the workbook title, creation date, name of the person who created the workbook, and any other information that describes the purpose and content of the workbook.

Excel assumes that any text in a formula is either a command word, such as a function name, or a reference to a cell, such as a named range.

You can immediately fix the #### error by ____.

You can use up to three levels of security and protection to control who can access and change your Excel data. Please describe two of the three levels and how you access each of them.