In Excel, a cell address $A1 is an example of: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, a cell address $A1 is an example of:

A. Mixed reference

B. Absolute reference

C. Relative reference

D. Circular reference

Answer: Option A

Solution (By JKSSB Mock Tests)

$A1 has column absolute, row relative, so it's mixed.

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

What is the shortcut key to select all content in MS Office?

A. Ctrl + Shift + A

B. Alt + A

C. Ctrl + A

D. Ctrl + E

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+A selects all.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which function calculates the number of cells that contain numbers in a range?

A. COUNTIF()

B. COUNT()

C. COUNTA()

D. SUM()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
COUNT counts numeric cells. COUNTA counts non-empty cells of any type.

This question belongs to: Computer Microsoft Office

Question #3

What is the shortcut to check spelling and grammar in MS Word?

A. F7

B. Shift + F7

C. Ctrl + F7

D. Alt + F7

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F7 runs the Spelling & Grammar check. Shift+F7 is thesaurus.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs