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. Mixed reference (column absolute, row relative)

B. Circular reference

C. Absolute reference

D. Relative reference

Answer: Option A

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 MS Access, which property defines the pattern for data entry (like phone number)?

A. Validation Rule

B. Format

C. Default Value

D. Input Mask

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Input Mask controls entry format.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Access, the 'Validation Rule' property is used to:

A. Define the input mask pattern

B. Specify a condition that data must satisfy to be entered

C. Require that a value be entered

D. Set a default value

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Validation Rule checks data against an expression (e.g., >=0). Validation Text provides message.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS PowerPoint, what occurs when you click the 'B' key on the keyboard during an active, full-screen slide show presentation?

A. Launches the drawing pen annotation tool

B. Moves the presentation instantly to the previous slide layout

C. Blacks out the screen display completely

D. Whites out the screen display completely

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Pressing the 'B' key during a live presentation blacks out the screen. Pressing the 'W' key turns the screen completely white. Pressing either key again returns to the slide show.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs