Chapter-2 Data Analysis in Spreadsheets (MS Excel) — Online MCQ Test
INFORMATION TECHNOLOGY · Grade 7 · CBSE(NCERT)
Practice Chapter-2 Data Analysis in Spreadsheets (MS Excel) with a free chapter-wise online MCQ test.
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.
Chapter-2 Data Analysis in Spreadsheets (MS Excel) — Important Questions & Answers
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.
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.
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.
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.
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.
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.