Question 1

VBA interprets ____ as "ignore these lines of text" because these lines do not contain commands that Excel should perform.

Accepted Answer

A)  apostrophes 
B)  question marks 
C)  exclamation points 
D)  forward slashes 
A)  apostrophes 
B)  question marks 
C)  exclamation points 
D)  forward slashes

Question 2

You can assign a macro to a(n) ____________________, which is a combination of keystrokes you press to run the macro.

Accepted Answer

shortcut k

Question 3

EPS is the amount of ____________________ that has been earned by each share on average, which measures the earning power of the product.

Accepted Answer

The answer of EPS is the amount of ____________________ that...

Question 4

For optimal password security, Microsoft recommends that you always assign a password to open and view a file.

Accepted Answer

A) True 
 B)False

Question 5

If you know a document came from a trustworthy source and contains only safe macros, you can store it in a trusted location, allowing any macros in it to run without being checked by security settings in the ____________________.

Accepted Answer

The answer of If you know a document came from...

Question 6

To help prevent a user from entering data that doesn't satisfy the validation rule for a cell, you can display a(n) ____ message that identifies the kind of data the user should enter.

Accepted Answer

A)  input 
B)  error 
C)  data 
D)  data table 
A)  input 
B)  error 
C)  data 
D)  data table

Question 7

____________________ refers to all the records that describe how and why a system has been developed, and how it should be used.

Accepted Answer

The answer of ____________________ refers to all the records that...

Question 8

You can obtain a(n) ____________________ from a commercial certification authority or, in some cases, from your system administrator.

Accepted Answer

The answer of You can obtain a(n) ____________________ from a...

Question 9

The steps you want to automate are stored as ____ commands in the macro, and are performed in sequence when you run the macro.

Accepted Answer

A)  VBA 
B)  HTML 
C)  HTTP 
D)  JAVA 
A)  VBA 
B)  HTML 
C)  HTTP 
D)  JAVA

Question 10

A(n) ____________________ is a note that you attach to a cell, separate from other cell content.

Accepted Answer

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

Question 11

An Excel application can be a DSS, a tool that helps managers or other users make decisions or solve problems.

Accepted Answer

A) True 
 B)False

Question 12

____________________ protection protects the contents of a worksheet to prevent anyone from changing, moving, or deleting its data.

Accepted Answer

The answer of ____________________ protection protects the contents of a...

Question 13

MATCHING
   
Identify the letter of the choice that best matches the tools listed above.
-Remove Arrows

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 
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 14

____ tracer arrows point to another cell that provides data for the active cell.

Accepted Answer

A)  Blue 
B)  Yellow 
C)  Green 
D)  Orange 
A)  Blue 
B)  Yellow 
C)  Green 
D)  Orange

Question 15

A(n) dependent cell uses the value in the active cell in its formula. _________________________

Accepted Answer

A) True 
 B)False

Question 16

You control how Excel handles macros that are not stored in trusted locations by choosing one of four macro settings in its Trust Center. Please list and describe each of the four settings.

Accepted Answer

•Disable all macros without notification

Question 17

It is best to include a workbook's filename, worksheet name, and date on cell formula printouts that are used for documentation. The worksheet's ____ is a handy location for this kind of information.

Accepted Answer

A)  header or footer 
B)  filename 
C)  range name 
D)  first column 
A)  header or footer 
B)  filename 
C)  range name 
D)  first column

Question 18

You can use up to three levels of security and protection to control who can access and change your Excel data. These levels do NOT include ____.

Accepted Answer

A)  worksheet protection 
B)  workbook protection 
C)  file protection 
D)  data table protection 
A)  worksheet protection 
B)  workbook protection 
C)  file protection 
D)  data table protection

Question 19

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 opens the Data Validation dialog box. What options will she be able to change using this dialog box?

Accepted Answer

A)  VBA settings 
B)  input messages 
C)  cell ranges 
D)  all of the above 
A)  VBA settings 
B)  input messages 
C)  cell ranges 
D)  all of the above

Question 20

To help minimize the errors users make as they enter data into worksheets, Excel provides a ____ tool.

Accepted Answer

A)  data validation 
B)  data 
C)  data message 
D)  data-entry 
A)  data validation 
B)  data 
C)  data message 
D)  data-entry

VBA interprets ____ as "ignore these lines of text" because these lines do not contain commands that Excel should perform.

You can assign a macro to a(n) ____________________, which is a combination of keystrokes you press to run the macro.

EPS is the amount of ____________________ that has been earned by each share on average, which measures the earning power of the product.

For optimal password security, Microsoft recommends that you always assign a password to open and view a file.

If you know a document came from a trustworthy source and contains only safe macros, you can store it in a trusted location, allowing any macros in it to run without being checked by security settings in the ____________________.

To help prevent a user from entering data that doesn't satisfy the validation rule for a cell, you can display a(n) ____ message that identifies the kind of data the user should enter.

____________________ refers to all the records that describe how and why a system has been developed, and how it should be used.

You can obtain a(n) ____________________ from a commercial certification authority or, in some cases, from your system administrator.

The steps you want to automate are stored as ____ commands in the macro, and are performed in sequence when you run the macro.

A(n) ____________________ is a note that you attach to a cell, separate from other cell content.

An Excel application can be a DSS, a tool that helps managers or other users make decisions or solve problems.

____________________ protection protects the contents of a worksheet to prevent anyone from changing, moving, or deleting its data.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Remove Arrows

____ tracer arrows point to another cell that provides data for the active cell.

A(n) dependent cell uses the value in the active cell in its formula. _________________________

You control how Excel handles macros that are not stored in trusted locations by choosing one of four macro settings in its Trust Center. Please list and describe each of the four settings.

It is best to include a workbook's filename, worksheet name, and date on cell formula printouts that are used for documentation. The worksheet's ____ is a handy location for this kind of information.

You can use up to three levels of security and protection to control who can access and change your Excel data. These levels do NOT include ____.

To help minimize the errors users make as they enter data into worksheets, Excel provides a ____ tool.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What-If Analysis

Enhancing Decision Making with Solver

Filters

Exam 10: Troubleshooting Workbooks and Automating Excel Applications

VBA interprets ____ as "ignore these lines of text" because these lines do not contain commands that Excel should perform.

You can assign a macro to a(n) ____________________, which is a combination of keystrokes you press to run the macro.

EPS is the amount of ____________________ that has been earned by each share on average, which measures the earning power of the product.

For optimal password security, Microsoft recommends that you always assign a password to open and view a file.

If you know a document came from a trustworthy source and contains only safe macros, you can store it in a trusted location, allowing any macros in it to run without being checked by security settings in the ____________________.

To help prevent a user from entering data that doesn't satisfy the validation rule for a cell, you can display a(n) ____ message that identifies the kind of data the user should enter.

____________________ refers to all the records that describe how and why a system has been developed, and how it should be used.

You can obtain a(n) ____________________ from a commercial certification authority or, in some cases, from your system administrator.

The steps you want to automate are stored as ____ commands in the macro, and are performed in sequence when you run the macro.

A(n) ____________________ is a note that you attach to a cell, separate from other cell content.

An Excel application can be a DSS, a tool that helps managers or other users make decisions or solve problems.

____________________ protection protects the contents of a worksheet to prevent anyone from changing, moving, or deleting its data.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Remove Arrows

____ tracer arrows point to another cell that provides data for the active cell.

A(n) dependent cell uses the value in the active cell in its formula. _________________________

You control how Excel handles macros that are not stored in trusted locations by choosing one of four macro settings in its Trust Center. Please list and describe each of the four settings.

It is best to include a workbook's filename, worksheet name, and date on cell formula printouts that are used for documentation. The worksheet's ____ is a handy location for this kind of information.

You can use up to three levels of security and protection to control who can access and change your Excel data. These levels do NOT include ____.

To help minimize the errors users make as they enter data into worksheets, Excel provides a ____ tool.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What-If Analysis

Enhancing Decision Making with Solver

Filters