Case-Based Critical Thinking Questions
Case 12-1
Chantal is building a kiosk-based Excel application.She wants to make some modifications to the screen elements in order to keep users from being distracted by parts of the application that are irrelevant to her application.She turns to Jason for guidance as she knows he built a similar solution earlier this year.
-Where in the Excel Options dialog box would Chantal find the setting to turn off AutoComplete for cell values?
A) Advanced options,Display section
B) Advanced options,Editing options section
C) Save options
D) Formulas options

Question

Quizplus · Accepted Answer

The option to turn off AutoComplete for cell values can be found under the Editing options section in the Advanced options dialog box in Excel. This option will help Chantal achieve her goal of modifying screen elements to reduce distractions for her users.