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. Data Validation -> List

C. Conditional Formatting -> List

D. Insert -> Drop-down

Answer: Option B

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

Share Report

What type of special validation error alert is thrown by MS Excel if a formula includes an invalid numeric argument or out-of-bounds parameter, such as finding the square root of a negative number via =SQRT(-9)?

A. #VALUE!

B. #NUM!

C. #DIV/0!

D. #NAME?

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The #NUM! error indicates a problem with a number in a formula, such as an argument that falls outside a function's supported domain (e.g., performing a square root on a negative number).

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS PowerPoint, what occurs if you select an item block and press the shortcut key combination Ctrl + Shift + C?

A. Centers the text alignment within a container bounding box

B. Clones the active slide canvas layout

C. Inserts a comment block on the active presentation slide

D. Copies the formatting and visual style properties of the selected object

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Shift + C copies only the style formatting properties of a selected object or text block. Pressing Ctrl + Shift + V applies those copied styles to a new selection.

This question belongs to: Computer Microsoft Office