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

Question Report Error

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

A. Mixed reference

B. Absolute reference

C. Circular reference

D. Relative reference

Answer: Option A

Solution (By JKExamLibrary)

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

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error

The shortcut to open the 'Page Setup' dialog in MS Excel is:

A. F12

B. Ctrl + P

C. Alt + P, S, P (or Page Layout tab)

D. Ctrl + F2

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
No direct single shortcut; you can use Alt+P, S, P. Or from Page Layout tab. I'll ask: Which tab contains Page Setup group? Answer: Page Layout. So I'll adjust.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

What is the keyboard shortcut to open the 'Font' dialog box in MS Word?

A. Ctrl + Shift + F

B. Both A and B

C. Ctrl + F

D. Ctrl + D

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Ctrl+D opens Font dialog. Ctrl+Shift+F also opens Font dialog with Font tab selected.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In MS Access, to import data from another Access database, use:

A. File -> Open

B. Create -> Import Table

C. Database Tools -> Import

D. External Data -> Access

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
External Data tab has import from Access.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs