Mila wants to restrict a cell to accept only whole numbers between 1 and 100.What should she select as X in the following clicks/entries/selections: Select cell.Data Data Validation Settings tab Validation Criteria Allow X Data (select)between Minimum (select)1 Maximum (select)10 OK Enter number between 1 and 100 in cell?
A) Decimal
B) List
C) Text length
D) Whole number

Question

Mila wants to restrict a cell to accept only whole numbers between 1 and 100.What should she select as X in the following clicks/entries/selections: Select cell.Data > Data Validation > Settings tab > Validation Criteria > Allow > X > Data > (select)between > Minimum > (select)1 > Maximum > (select)10 > OK > Enter number between 1 and 100 in cell?
A) Decimal
B) List
C) Text length
D) Whole number

Quizplus · Accepted Answer

Selecting "Whole number" as X will ensure that the cell only accepts integers. From there, Mila can select "between" and then set the minimum to 1 and the maximum to 100, which will restrict the cell to only accept whole numbers between 1 and 100.

Mila Wants to Restrict a Cell to Accept Only Whole