Question 1

Elianna has put together the Projected Income worksheet above. She is finalizing the worksheet for a presentation to her company's board of directors. When needed, please refer to the figure above as you answer the questions below.
-Elianna has included a Print Formulas button on the worksheet. This button links to ____.

Accepted Answer

A)  a macro 
B)  another worksheet 
C)  a formula in a cell 
D)  another file

Question 2

If you set up the validation rule only, all future data entry in that cell is restricted to the values ____.

Accepted Answer

A)  you have specified 
B)  Excel enters as a default 
C)  new users enter 
D)  none of the above

Question 3

The data validation tool restricts data being entered and data already stored in the worksheet.

Accepted Answer

A) True 
 B)False

Question 4

As part of his new job, Seth has created a Projected Income worksheet for his company. He wants to prohibit users from changing the formulas in the Projected Income worksheet, while allowing them to change values such as unit sales and unit price. Seth has also imported a worksheet named Sales History, which contains sales information for sunglasses for the last year.
-In order for Seth to allow others to enter data into some of the cells in the worksheet but not others, he should ____.

Accepted Answer

A)  unlock the cells he wants users to access and then protect the worksheet 
B)  protect the worksheet and then unlock the cells he wants users to access 
C)  name ranges and click "allow data entry" in the Data Validation dialog box 
D)  none of the above

Question 5

For optimal password security, Microsoft recommends that you always assign a password to open and view a file. Users who also have permission to modify data should then enter ____.

Accepted Answer

A)  a second password 
B)  the same password 
C)  no password 
D)  a Microsoft-assigned password

Question 6

MATCHING
  
Identify the letter of the choice that best matches the tools listed above.
-Error Checking menu

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 7

The Excel formula auditing tools help you troubleshoot formula problems by letting you review the ____ of a formula.

Accepted Answer

A)  structure 
B)  behavior 
C)  both a and b 
D)  neither a nor b

Question 8

In VBA, comments appear in green and start with a(n) ____.

Accepted Answer

A)  apostrophe (') 
B)  forward slash (/) 
C)  question mark (?) 
D)  exclamation point (!)

Question 9

One way to make a workbook easier to use is to automate repetitive or difficult tasks. To do so, you can use ____.

Accepted Answer

A)  a macro 
B)  animation 
C)  a wizard 
D)  a validation scheme

Question 10

Macro viruses are viruses that are written and stored as macros attached to documents created in Office programs such as Excel, and run when you open an infected document. _________________________

Accepted Answer

A) True 
 B)False

Question 11

MATCHING
  
Identify the letter of the choice that best matches the tools listed above.
-Trace Dependents

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 12

In addition to a helpful message that appears before users enter data, you can also display a(n) ____ message in a message box if users enter data that violates the cell's validation rule.

Accepted Answer

A)  error alert 
B)  alarm 
C)  caution 
D)  stop and look

Question 13

A trusted location is usually any computer that is used only by one person.

Accepted Answer

A) True 
 B)False

Question 14

New or casual Excel users usually prefer to create a macro using the ____, an excellent choice for automating tasks that you perform using the keyboard or mouse.

Accepted Answer

A)  macro recorder 
B)  macro simulator 
C)  macro animator 
D)  macro duplicator

Question 15

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

Accepted Answer

A)  Test 
B)  Complex 
C)  Scenario 
D)  Break-even

Question 16

When printing worksheet formulas, especially for the purposes of documentation, it is very helpful to set the print options to ____.

Accepted Answer

A)  print the row and column headings 
B)  portrait orientation 
C)  both a and b 
D)  neither a nor b

Question 17

As part of his new job, Seth has created a Projected Income worksheet for his company. He wants to prohibit users from changing the formulas in the Projected Income worksheet, while allowing them to change values such as unit sales and unit price. Seth has also imported a worksheet named Sales History, which contains sales information for sunglasses for the last year.
-Seth is thinking about hiding all cells with formulas in his Projected Income worksheet. He thinks this will definitely protect them from being changed. You would advise him not to hide all of these cells because ____.

Accepted Answer

A)  depending on whether the worksheet is protected, users will still be able to unhide and change the cell contents 
B)  it is considered poor practice to hide cells with formulas in a worksheet 
C)  both a and b 
D)  neither a nor b

Question 18

A #VALUE! error in a worksheet cell indicates ____.

Accepted Answer

A)  the wrong argument type or operand 
B)  an incorrect formula 
C)  a circular argument 
D)  the cell needs to be widened

Question 19

A(n) digital certificate should contain a digital signature, which confirms that the signer created the macro and that the macro has not been changed since its digital certificate was created. _________________________

Accepted Answer

A) True 
 B)False

Question 20

The formula auditing tool called Evaluate Formula displays the different parts of a nested formula, evaluated in the order the formula is written.

Accepted Answer

A) True 
 B)False

Exam 10: Troubleshooting Workbooks and Automating Excel Applications

If you set up the validation rule only, all future data entry in that cell is restricted to the values ____.

The data validation tool restricts data being entered and data already stored in the worksheet.

For optimal password security, Microsoft recommends that you always assign a password to open and view a file. Users who also have permission to modify data should then enter ____.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Error Checking menu

The Excel formula auditing tools help you troubleshoot formula problems by letting you review the ____ of a formula.

In VBA, comments appear in green and start with a(n) ____.

One way to make a workbook easier to use is to automate repetitive or difficult tasks. To do so, you can use ____.

Macro viruses are viruses that are written and stored as macros attached to documents created in Office programs such as Excel, and run when you open an infected document. _________________________

MATCHING Identify the letter of the choice that best matches the tools listed above. -Trace Dependents

In addition to a helpful message that appears before users enter data, you can also display a(n) ____ message in a message box if users enter data that violates the cell's validation rule.

A trusted location is usually any computer that is used only by one person.

New or casual Excel users usually prefer to create a macro using the ____, an excellent choice for automating tasks that you perform using the keyboard or mouse.

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

When printing worksheet formulas, especially for the purposes of documentation, it is very helpful to set the print options to ____.

A #VALUE! error in a worksheet cell indicates ____.

A(n) digital certificate should contain a digital signature, which confirms that the signer created the macro and that the macro has not been changed since its digital certificate was created. _________________________

The formula auditing tool called Evaluate Formula displays the different parts of a nested formula, evaluated in the order the formula is written.