What is the shortcut key to open the 'Replace' dialog in MS Excel? MCQ with Answer and Explanation

Question

Share Report Error

What is the shortcut key to open the 'Replace' dialog in MS Excel?

A. Ctrl + H

B. F5

C. Ctrl + F

D. Ctrl + G

Answer: Option A

Solution (By JKSSB Mock Tests)

Ctrl+H opens Find and Replace with Replace tab active. Ctrl+F opens Find, Ctrl+G is Go To.

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 Excel, which function is used to concatenate text strings?

A. CONCAT

B. CONCATENATE

C. TEXTJOIN

D. All of the above

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
CONCAT, CONCATENATE, and TEXTJOIN all concatenate text (TEXTJOIN with delimiter).

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, to sort records in ascending order in a query, use:

A. Both A and B

B. Group By

C. Ascending order in the Sort row of the query design grid

D. ORDER BY ASC in SQL

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Both design grid sort and SQL ORDER BY ASC work.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, to name a range, you can:

A. Select range, type name in Name Box and press Enter

B. Formulas -> Define Name

C. Insert -> Name

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Both methods work.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs