Filters
Question type
Study Flashcards

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


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

E) C) and D)
F) A) and B)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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.


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

E) C) and D)
F) B) and D)

Correct Answer

verifed

verified

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 ____.


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

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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. _________________________

A) True
B) False

Correct Answer

verifed

verified

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 ____.


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

E) All of the above
F) A) and D)

Correct Answer

verifed

verified

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


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

E) All of the above
F) None of the above

Correct Answer

verifed

verified

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


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

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

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) error alert
B) alarm
C) caution
D) stop and look

E) A) and D)
F) C) and D)

Correct Answer

verifed

verified

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 ____. A) a macro B) another worksheet C) a formula in a cell D) another file 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 ____.


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

E) A) and B)
F) C) and D)

Correct Answer

verifed

verified

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


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

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

MATCHING MATCHING Identify the letter of the choice that best matches the tools listed above. -Trace Dependents A) #1 B) #2 C) #3 D) #4 E) #5 F) #6 G) #7 H) #8 I) #9 J) #10 K) #11 L) #12 Identify the letter of the choice that best matches the tools listed above. -Trace Dependents


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

M) B) and C)
N) D) and L)

Correct Answer

verifed

verified

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. _________________________

A) True
B) False

Correct Answer

verifed

verified

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 ____.


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

E) A) and C)
F) A) and B)

Correct Answer

verifed

verified

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


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

E) A) and B)
F) B) and D)

Correct Answer

verifed

verified

MATCHING MATCHING Identify the letter of the choice that best matches the tools listed above. -Error Checking menu A) #1 B) #2 C) #3 D) #4 E) #5 F) #6 G) #7 H) #8 I) #9 J) #10 K) #11 L) #12 Identify the letter of the choice that best matches the tools listed above. -Error Checking menu


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

M) C) and F)
N) H) and K)

Correct Answer

verifed

verified

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


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

E) A) and D)
F) C) and D)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


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

E) B) and C)
F) C) and D)

Correct Answer

verifed

verified

Showing 121 - 140 of 150

Related Exams

Exam 1

Applying Fundamental Excel Skills and Tools in Problem Solving

150 Questions

Exam 2

Solving Problems with Statistical Analysis Tools

150 Questions

Exam 3

Determining Effective Data Display with Charts

150 Questions

Exam 4

Applying Logic in Decision Making

150 Questions

Exam 5

Retrieving Data for Computation, Analysis, and Reference

150 Questions

Exam 6

Evaluating the Financial Impact of Loans and Investments

150 Questions

Exam 7

Organizing Data for Effective Analysis

150 Questions

Exam 8

Using Data Tables and Excel Scenarios for What-If Analysis

150 Questions

Exam 9

Enhancing Decision Making with Solver

150 Questions

Show Answer