In Excel, which of the following is NOT a valid data validation criteria? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which of the following is NOT a valid data validation criteria?

A. List

B. Formula only

C. Whole number

D. Decimal

Answer: Option B

Solution (By JKSSB Mock Tests)

Data validation allows Any value, Whole number, Decimal, List, Date, Time, Text length, Custom. There is no 'Formula only'.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

In Access, which of the following is a valid field size for a Number data type?

A. Integer

B. All of the above

C. Single

D. Long Integer

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Number field sizes include Byte, Integer, Long Integer, Single, Double, Decimal, etc. So all are valid.

This question belongs to: Computer Microsoft Office

Question #2

What happens when you select a cell in MS Excel and press 'Ctrl + ;' (Control + Semicolon)?

A. The column is completely deleted

B. The cell formulas are hidden

C. The current system time is inserted

D. The current system date is inserted

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + ; inserts the current system date into the cell, whereas Ctrl + Shift + : (Colon) inserts the current system time.

This question belongs to: Computer Microsoft Office

Question #3

Which Access data type would be most suitable for storing lengthy descriptive text up to about 1 GB?

A. OLE Object

B. Text

C. Hyperlink

D. Long Text (Memo)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Long Text (formerly Memo) stores large amounts of text. Text holds up to 255 characters. OLE Object stores binary objects.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs