Chapter Exam

Chapter-2 Data Analysis in Spreadsheets (MS Excel) — Online MCQ Test

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

Answer: B. A1 — A relative reference like A1 changes when copied to another cell, whereas absolute references use dollar signs ($) to remain fixed.

Q: In the reference $A1, which part is absolute and which is relative?

Answer: B. A is absolute, 1 is relative — A mixed reference $A1 has an absolute column (A) and a relative row (1), so only the column remains fixed when copied.

Q: Scenario: You have sales data for 12 months in cells B1:B12. You want to apply a filter to show only sales above ₹50,000. Which feature should you use?

Answer: B. Filtering with criteria — Filtering with specific criteria (like values > ₹50,000) allows you to display only rows meeting that condition without modifying the original data.

Q: A student copies a formula =B$5+C5 from D5 to E6. What will the formula become in E6?

Answer: B. =B$5+C6 — In the mixed reference B$5, the column B changes to C (relative), but the row 5 stays fixed (absolute). C5 becomes C6 (both relative). Result: =B$5+C6.

INFORMATION TECHNOLOGY · Grade 7 · CBSE(NCERT)

Practice Chapter-2 Data Analysis in Spreadsheets (MS Excel) with a free chapter-wise online MCQ test for CBSE(NCERT) Grade 7 INFORMATION TECHNOLOGY. This chapter covers: cell referencing - absolute reference - relative reference - mixed reference - formulas - functions - SUM - AVERAGE - IF - charts - sorting - filtering. 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-2 Data Analysis in Spreadsheets (MS Excel) — Important Questions & Answers (FAQ)

Frequently asked questions from CBSE(NCERT) Grade 7 INFORMATION TECHNOLOGY — Chapter-2 Data Analysis in Spreadsheets (MS Excel), with answers and explanations. These are sample questions; the exam has its own separate question set.

What is a cell reference in MS Excel?

A. The address of a cell identified by its column letter and row number ✓
B. The formula written inside a cell
C. The background color of a cell
D. The data type stored in a cell

Answer: A. The address of a cell identified by its column letter and row number
A cell reference uniquely identifies a cell's location using column letter (A, B, C...) and row number (1, 2, 3...), such as A1 or B5.

Which of the following is an example of a relative cell reference?

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

Answer: B. A1
A relative reference like A1 changes when copied to another cell, whereas absolute references use dollar signs ($) to remain fixed.

In the reference $A1, which part is absolute and which is relative?

A. Both are absolute
B. A is absolute, 1 is relative ✓
C. A is relative, 1 is absolute
D. Both are relative

Answer: B. A is absolute, 1 is relative
A mixed reference $A1 has an absolute column (A) and a relative row (1), so only the column remains fixed when copied.

Scenario: You have sales data for 12 months in cells B1:B12. You want to apply a filter to show only sales above ₹50,000. Which feature should you use?

A. Sorting
B. Filtering with criteria ✓
C. Creating a chart
D. Copying the data

Answer: B. Filtering with criteria
Filtering with specific criteria (like values > ₹50,000) allows you to display only rows meeting that condition without modifying the original data.

A student copies a formula =B$5+C5 from D5 to E6. What will the formula become in E6?

A. =B$5+C5
B. =B$5+C6 ✓
C. =B$6+C6
D. =C$5+D6

Answer: B. =B$5+C6
In the mixed reference B$5, the column B changes to C (relative), but the row 5 stays fixed (absolute). C5 becomes C6 (both relative). Result: =B$5+C6.