Chapter Exam

Chapter-9 Electronic Spreadsheet — Online MCQ Test

Q: Which symbol is used to denote absolute reference in a cell address?

Answer: B. $ (dollar sign) — The dollar sign ($) is used in spreadsheets to denote absolute reference, making the reference fixed when copying formulas (e.g., $A$1).

Q: Which of the following is an example of relative reference?

Answer: C. A1 — Relative reference (A1) changes when a formula is copied to other cells, adjusting automatically based on the new position.

Q: When copying a formula with mixed reference A$1 from cell C1 to cell D1, what will it become?

Answer: B. B$1 — In mixed reference A$1, the column (A) is relative and the row (1) is absolute. When copied to D1, the column changes to B while the row stays at 1.

Q: Consider a formula =SUM($A$2:$A$10)+AVERAGE(B2:B10). If copied from C2 to D5, which reference would change its column designation?

Answer: B. Only B2:B10 would change to C2:C10 — $A$2:$A$10 is absolute and will not change. B2:B10 is relative and will change to C2:C10 when copied one column to the right.

INFORMATION TECHNOLOGY · Grade 9 · CBSE(NCERT)

Practice Chapter-9 Electronic Spreadsheet with a free chapter-wise online MCQ test for CBSE(NCERT) Grade 9 INFORMATION TECHNOLOGY. This chapter covers: Cell pointer - Range selection - Relative/Absolute/Mixed referencing - Formula bar - Functions - SUM - AVERAGE - MAX - MIN - COUNT - Chart elements - Fill handle - Sorting and filt.... AI-generated questions from basic to board-exam level, with instant results and explanations.

Questions

20m

Time Limit

Attempts Left

10 random questions from this chapter (mixed difficulty)
Questions you've seen before won't repeat until the pool resets
You have 20 minutes — exam auto-submits when time is up
Maximum 3 attempts per chapter
Results and explanations shown immediately after submission

New here? Register free — includes 3 free chapter exams.

Chapter-9 Electronic Spreadsheet — Important Questions & Answers (FAQ)

Frequently asked questions from CBSE(NCERT) Grade 9 INFORMATION TECHNOLOGY — Chapter-9 Electronic Spreadsheet, with answers and explanations. These are sample questions; the exam has its own separate question set.

What is a cell pointer in an electronic spreadsheet?

A. A visual indicator showing the currently selected cell ✓
B. A formula that points to another spreadsheet
C. A tool for drawing shapes in cells
D. A function that calculates cell values

Answer: A. A visual indicator showing the currently selected cell
A cell pointer is the highlighted border or indicator that shows which cell is currently active or selected in the spreadsheet.

Which symbol is used to denote absolute reference in a cell address?

A. & (ampersand)
B. $ (dollar sign) ✓
C. # (hash)
D. @ (at sign)

Answer: B. $ (dollar sign)
The dollar sign ($) is used in spreadsheets to denote absolute reference, making the reference fixed when copying formulas (e.g., $A$1).

Which of the following is an example of relative reference?

A. $A$1
B. A$1
C. A1 ✓
D. $A1

Answer: C. A1
Relative reference (A1) changes when a formula is copied to other cells, adjusting automatically based on the new position.

When copying a formula with mixed reference A$1 from cell C1 to cell D1, what will it become?

A. A$1
B. B$1 ✓
C. A$2
D. D$1

Answer: B. B$1
In mixed reference A$1, the column (A) is relative and the row (1) is absolute. When copied to D1, the column changes to B while the row stays at 1.

Consider a formula =SUM($A$2:$A$10)+AVERAGE(B2:B10). If copied from C2 to D5, which reference would change its column designation?

A. Only $A$2:$A$10 would change
B. Only B2:B10 would change to C2:C10 ✓
C. Both ranges would change
D. Neither would change because both are absolute

Answer: B. Only B2:B10 would change to C2:C10
$A$2:$A$10 is absolute and will not change. B2:B10 is relative and will change to C2:C10 when copied one column to the right.