Case EX 11-2 Sharon has a large collection of books at her home and she has catalogued them and stored that information in a worksheet titled Books in a workbook that also contains other worksheets. Sharon wants to make sure that whenever she enters the information for a new book in her worksheet, it is entered in the correct format and as accurately as possible. She needs to use the ____ feature.
A) Subtotal
B) Data Validation
C) Watch Window
D) Data Checking

Question

Quizplus · Accepted Answer

Sharon needs to use the Data Validation feature, which allows her to set rules and conditions for the data entry in her worksheet to ensure that the information is entered in the correct format and as accurately as possible.

Case EX 11-2 Sharon Has a Large Collection of Books