Chapter-9 Electronic Spreadsheet — Online MCQ Test
INFORMATION TECHNOLOGY · Grade 9 · CBSE(NCERT)
Practice Chapter-9 Electronic Spreadsheet with a free chapter-wise online MCQ test.
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.
Chapter-9 Electronic Spreadsheet — Important Questions & Answers
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.
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).
The dollar sign ($) is used in spreadsheets to denote absolute reference, making the reference fixed when copying formulas (e.g., $A$1).
What is the formula bar used for?
- A. To display charts and graphs
- B. To enter and edit formulas and data in cells
- C. To sort data in ascending order
- D. To apply filters to columns
Answer: B. To enter and edit formulas and data in cells
The formula bar is the input area at the top of a spreadsheet where users can enter, view, and edit formulas or data for the selected cell.
The formula bar is the input area at the top of a spreadsheet where users can enter, view, and edit formulas or data for the selected cell.
What does the SUM function do?
- A. Counts the number of cells with data
- B. Calculates the average of selected cells
- C. Adds all the numbers in a range of cells
- D. Finds the maximum value in a range
Answer: C. Adds all the numbers in a range of cells
The SUM function is used to calculate the total sum of all numeric values in a specified range of cells.
The SUM function is used to calculate the total sum of all numeric values in a specified range of cells.
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.
Relative reference (A1) changes when a formula is copied to other cells, adjusting automatically based on the new position.
What happens when you use absolute reference ($A$1) in a formula and copy it to another cell?
- A. The reference changes to the new cell location
- B. The reference remains fixed to the original cell
- C. The formula is deleted
- D. The cell displays an error
Answer: B. The reference remains fixed to the original cell
Absolute references with dollar signs ($) remain fixed and do not change when the formula is copied to other cells.
Absolute references with dollar signs ($) remain fixed and do not change when the formula is copied to other cells.
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.
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.
A spreadsheet contains student IDs in column A (50 students) and their respective marks in column B. To count how many students scored marks, which formula is most appropriate?
- A. =SUM(B1:B50)
- B. =COUNT(B1:B50)
- C. =AVERAGE(B1:B50)
- D. =MAX(B1:B50)
Answer: B. =COUNT(B1:B50)
COUNT function is used to count cells containing numeric values; it will count how many marks entries exist in the range B1:B50.
COUNT function is used to count cells containing numeric values; it will count how many marks entries exist in the range B1:B50.
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.
$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.
In a complex spreadsheet, you have data sorted by region, but within each region, you also need it sorted by sales in descending order. What is the most efficient approach?
- A. Perform a single sort by region only
- B. Manually rearrange each region's data
- C. Use multi-level sorting: first by region (ascending), then by sales (descending) within each region
- D. Create separate spreadsheets for each region
Answer: C. Use multi-level sorting: first by region (ascending), then by sales (descending) within each region
Multi-level or custom sorting allows you to sort by multiple criteria simultaneously, organizing data by region first and then by sales within each region efficiently.
Multi-level or custom sorting allows you to sort by multiple criteria simultaneously, organizing data by region first and then by sales within each region efficiently.