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

Question

Share Report Error

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

A. Ctrl + G

B. Ctrl + F

C. Ctrl + H

D. F5

Answer: Option B

Solution (By JKSSB Mock Tests)

Ctrl+F opens Find and Replace with Find tab. Ctrl+G is Go To, Ctrl+H is Replace, F5 also 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, what does the 'PMT' function calculate?

A. The interest rate of a loan

B. The future value of an annuity

C. The payment for a loan based on constant payments and interest rate

D. The present value of an investment

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
PMT computes the periodic payment for a loan or annuity with constant payments and a fixed interest rate. PV calculates present value, FV future value, RATE calculates interest rate.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, the function =IFERROR(A1/B1, "Error") returns "Error" if:

A. If A1 is blank

B. A1/B1 results in any error value

C. If B1 is zero

D. Only if #DIV/0!

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
IFERROR catches all error types and returns specified value.

This question belongs to: Computer Microsoft Office

Question #3

What is the function of the keyboard shortcut 'Ctrl + D' when a shape, text box, or slide is selected in MS PowerPoint?

A. Duplicates the item

B. Centers the alignment

C. Downloads the item

D. Deletes the item

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + D acts as a shortcut to quickly duplicate any selected object, shape, text box, or active slide layout within PowerPoint.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs