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

Question Report Error

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

A. Decimal

B. List

C. Whole number

D. Formula only

Answer: Option D

Solution (By JKExamLibrary)

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

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error

In PowerPoint, the 'Selection Pane' shows:

A. Transition settings

B. Animation timeline

C. Slide thumbnails

D. A list of all objects on the slide, allowing you to hide, rename, reorder them

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
Selection Pane (Home -> Select -> Selection Pane) manages objects.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In Excel, what does the 'VLOOKUP' function stand for?

A. Vertical Lookup

B. Vector Lookup

C. Value Lookup

D. Variable Lookup

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
VLOOKUP stands for Vertical Lookup, used to search for a value in the first column of a table and return a value in the same row from another column.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In PowerPoint, which key stops a running slide show and returns to the previous view?

A. Ctrl + Break

B. End

C. Esc

D. Break

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Esc exits slide show.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs