Question
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
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.
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
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!
