In Excel, the 'Go To Special' dialog can be opened by: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the 'Go To Special' dialog can be opened by:

A. Ctrl + G

B. F5 -> Special button, or Home tab -> Find & Select -> Go To Special

C. Alt + F5

D. Ctrl + Shift + G

Answer: Option B

Solution (By JKSSB Mock Tests)

F5 opens Go To, then click Special. Alternatively, Home > Find & Select > Go To Special.

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 MS Access, a 'Make-Table' query is an example of:

A. Crosstab query

B. Parameter query

C. Select query

D. Action query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Action queries modify data or structure.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, how can you quickly increase indent of a paragraph?

A. Press Ctrl + M

B. Press Ctrl + T

C. Press Tab at the beginning of the paragraph

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+M increases left indent; Tab at start of paragraph increases first-line indent (if allowed). But both increase indentation. So C.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which function returns the number of cells in a range that meet multiple criteria?

A. SUMIFS()

B. COUNTIF()

C. COUNTIFS()

D. DCOUNT()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
COUNTIFS handles multiple criteria.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs