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

What is the shortcut to open the 'Replace' dialog in MS Excel?
A. Ctrl + R
B. Ctrl + H
C. F5
D. Ctrl + F
Answer: Option B
Solution (By JKSSB Mock Tests)
Ctrl+H for Replace.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Excel, what type of referencing style is used when a formula contains a cell reference formatted as B$4?
A. Absolute Reference
B. Relative Reference
C. External reference link
D. Mixed Reference

Correct Answer: Option D


Explanation:
A mixed cell reference locks down either the column or the row while leaving the other free to shift relatively during formula copy-paste procedures.

This question belongs to: Computer Microsoft Office
Question #2
Which feature in MS PowerPoint allows you to pick an active application window on your desktop and insert a static snapshot image of it directly onto a slide?
A. Cameo live video stream
B. Screen Recording video
C. SmartArt graphic layout
D. Screenshot

Correct Answer: Option D


Explanation:
The Screenshot tool captures a static image snapshot of any open window on your desktop and embeds it directly onto the active presentation slide.

This question belongs to: Computer Microsoft Office
Question #3
What will be the output of the MS Excel formula =NETWORKDAYS(DATE(2026,6,15), DATE(2026,6,19)) if there are no holidays during this period?
A. 3
B. #VALUE!
C. 4
D. 5

Correct Answer: Option D


Explanation:
The NETWORKDAYS function calculates the number of working days (Monday through Friday) between two dates, inclusive of both start and end dates. June 15, 2026 (Monday) to June 19, 2026 (Friday) is exactly 5 business days.

This question belongs to: Computer Microsoft Office