In Excel, the formula =$A1 is an example of: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the formula =$A1 is an example of:

A. Absolute reference

B. Relative reference

C. Mixed reference (column absolute, row relative)

D. Circular reference

Answer: Option C

Solution (By JKSSB Mock Tests)

$A locks column A, row remains relative.

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

Share Report

In PowerPoint, which tab allows you to add a video from YouTube?

A. Insert -> Video -> Online Video

B. Slide Show -> Video

C. Design -> Video

D. Animations -> Video

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Online Video is in Insert tab.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the shortcut key combination to double-underline a selected block of text in MS Word?

A. Ctrl + Shift + D

B. Alt + Shift + D

C. Ctrl + U

D. Ctrl + Shift + U

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + Shift + D applies a double-line underline style to selected text blocks in MS Word, while Ctrl + U applies a single underline.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Word, 'SmartArt' is used to:

A. Create visual representations like lists, processes, and hierarchies

B. Insert copyright-free images

C. Add mathematical equations

D. Create charts

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
SmartArt provides pre-designed diagram templates.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs