How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell?

A. The Settings tab under the menu Format -> Cells
B. The Settings tab under the menu Data -> Validation
C. The Settings tab under the menu Data -> Filter-> Advanced Filter
D. The settings tab under the menu Format -> Conditional Formatting

Answer

Correct Answer: B. The Settings tab under the menu Data -> Validation

Detail about MCQs

In MS Excel, in Settings tab under the menu Data – Validation is used to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.

Write a Comment

Your email address will not be published. Required fields are marked *

error: Content is protected !!