Multiple Choice
Case 9-1
You are presenting a two-hour seminar on using Excel features to professionals at an annual convention of accounting managers. The seminar will be followed by a brief Q&A session. Half-way through the seminar, you give the seminar participants a break.
-On her way to the break room, one of the participants stops to ask you how she can improve her efficiency when working with unfamiliar workbooks sent to her from accounting personnel located in different branch offices. You suggest that ____.
A) she use the formula auditing tools in the Formula Auditing group on the FORMULAS tab to trace formula precedents and dependents in order to better understand how each worksheet is structured
B) she ask each branch office accountant to also send an outline document describing all the formulas and other features included in each workbook
C) unfortunately, Excel does not have any built-in tools she can use to become more familiar with the workbooks she receives
D) she ask the branch office accountants to send her all the necessary information so that she can create her own workbooks
Correct Answer:

Verified
Correct Answer:
Verified
Q101: The error code #DIV/0! indicates that there
Q102: One of the tools that Excel provides
Q103: _ will try many possible solutions to
Q104: Which of the following is the path
Q105: The Goal Seek command is located on
Q107: Which of the following is NOT an
Q108: Obvious formula errors in a worksheet are
Q109: Which of the following are methods or
Q110: You can use _ to manage two
Q111: You can use scenario auditing to review