In Excel, to create a drop-down list in a cell, use: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, to create a drop-down list in a cell, use:

A. Home -> Sort & Filter

B. Insert -> Drop-down

C. Data Validation -> List

D. Conditional Formatting -> List

Answer: Option C

Solution (By JKSSB Mock Tests)

Data Validation with List restriction creates a drop-down.

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

Which of the following is the shortcut to save the current workbook in Excel?

A. Ctrl + S

B. Ctrl + Shift + S

C. F12

D. Alt + F4

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + S saves. F12 opens Save As. Alt + F4 closes Excel.

This question belongs to: Computer Microsoft Office

Question #2

Which MS Excel function returns the serial number of the current system date and time simultaneously?

A. NOW()

B. TIME()

C. TODAY()

D. DATE()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The NOW() function returns both the current system date and time. In contrast, TODAY() returns only the current system date without the exact time.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which function is used to calculate the arithmetic mean of a set of numbers?

A. AVERAGE

B. MEDIAN

C. MODE

D. AVERAGEA

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
AVERAGE is the arithmetic mean. AVERAGEA includes logical values, MEDIAN is middle value, MODE is most frequent.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs