adplus-dvertising
frame-decoration

Question

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

Posted under MS Office

Answer: (b).The Settings tab under the menu Data -> Validation

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

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

Similar Questions

Discover Related MCQs

Q. Clear the contents by pressing “DELETE” key from a keyboard will clear

View solution

Q. Which of the following shortcuts can be used to insert a new line in the same cell?

View solution

Q. What is the quickest way to select entire worksheet?

View solution

Q. A smart tag will be removed from a cell when

View solution

Q. Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

View solution

Q. Selecting the Rows 5 & 6 then choose Insert->Row. What will happen?

View solution

Q. If 4/6 entered in a cell without applying any formats, Excel will treat this as

View solution

Q. How to fit long texts in a single cell with multiple lines?

View solution

Q. If particular workbook have to open each time Excel started, where that workbook should be placed?

View solution

Q. If the cell B1 contains the formula = $A$1, which of the following statements is true

View solution

Q. Worksheet can be renamed by

View solution

Q. What is the shortcut key to hide entire row?

View solution

Q. What is the shortcut key to insert a new comment in a cell?

View solution

Q. Which option allows you to Bold all the negative values within the selected cell range:

View solution

Q. What is the shortcut key to insert new sheet in current workbook?

View solution

Q. Which one is the last column header in Excel 2007?

View solution

Q. In maximum, how many sheets can be set as default while creating new workbook?

View solution

Q. “New Comment” option can be found under _________ tab

View solution

Q. In Excel, by default Numeric Values appears in

View solution

Q. To show/hide the grid lines in Microsoft Excel 2007

View solution
View All MCQs on MS Office

Suggested Topics

Are you eager to expand your knowledge beyond MS Office? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

Software Engineering

Learn about the systematic approach to developing software with our Software...

Data Warehousing and OLAP

Strengthen your knowledge of Data Warehousing and OLAP with our specialized MCQs....

Neural Networks

Dive into the world of Artificial Intelligence with our Neural Networks MCQs. Uncover...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....