Which feature in Excel restricts the type of data that can be entered into a cell? MCQ with Answer and Explanation

Question

Share Report Error

Which feature in Excel restricts the type of data that can be entered into a cell?

A. Goal Seek

B. Protect Sheet

C. Data Validation

D. Conditional Formatting

Answer: Option C

Solution (By JKSSB Mock Tests)

Data Validation controls allowed inputs (e.g., whole numbers, lists). Conditional Formatting changes appearance, Goal Seek performs what-if analysis, Protect Sheet restricts editing.

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

Share Report

Which field data type property in MS Access is ideal for fields that store long descriptions or logs that exceed 255 characters?

A. Short Text

B. Long Text

C. OLE Object Data Type

D. Hyperlink text block

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
In modern versions of MS Access, the 'Long Text' data type (previously known as Memo) stores up to 1 gigabyte of alphanumeric characters, whereas 'Short Text' is capped at 255 characters.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

Which feature in MS Word allows you to automatically add a reference list at the end of a document for cited sources?

A. Table of Contents

B. Bibliography

C. Cross-reference

D. Index

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Bibliography feature in Word creates a list of sources cited in the document. Table of Contents lists headings, Index lists keywords, Cross-reference links to other parts.

This question belongs to: Computer Microsoft Office