Which of the following is the correct shortcut to open the 'Go To' dialog in Excel? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is the correct shortcut to open the 'Go To' dialog in Excel?

A. Ctrl + F

B. Ctrl + G

C. Both A and B

D. F5

Answer: Option C

Solution (By JKSSB Mock Tests)

Both F5 and Ctrl+G open the Go To dialog in Excel.

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 return the number of rows in a range?

A. COLUMNS

B. ROW

C. ROWS

D. COUNT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
ROWS returns the count of rows in a reference. ROW returns the row number of a reference. COLUMNS returns column count.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which of the following formulas calculates the monthly payment for a loan of ₹5,00,000 at 10% annual interest for 5 years?

A. =FV(10%, 5, 500000)

B. =PMT(10%/12, 5*12, -500000)

C. =PMT(10%, 5, 500000)

D. =PV(10%/12, 5*12, -500000)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
PMT requires rate per period, total periods, present value. Monthly rate is 10%/12, periods 60, PV -500000.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, the error '#REF!' indicates:

A. Invalid cell reference (cell may have been deleted)

B. Formula name not recognized

C. Wrong data type

D. Division by zero

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
#REF! means a reference is invalid. #DIV/0! division by zero, #NAME? unrecognized text, #VALUE! wrong type.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs