Electronic Spreadsheet Advanced MCQs – CBSE Class 10 Computer Science NCERT Based
Electronic Spreadsheet Advanced MCQs – CBSE Class 10 Computer Science
Class: 10
Subject: Computer Science
Unit: Unit 2 – Electronic Spreadsheet
Topic: Electronic Spreadsheet Advanced MCQs (NCERT Based)
Board: CBSE Board Examinations
Q1. Which function is used to count numeric values in a range?
Answer: A. COUNT
Explanation: COUNT counts only numeric values. COUNTA counts all non‑empty cells, while COUNTIF applies conditions.
Explanation: COUNT counts only numeric values. COUNTA counts all non‑empty cells, while COUNTIF applies conditions.
Q2. The intersection of a row and column is called?
Answer: B. Cell
Explanation: A cell is the basic unit where data is entered. Example: A1, B5.
Explanation: A cell is the basic unit where data is entered. Example: A1, B5.
Q3. Which symbol is used to start a formula?
Answer: B. =
Explanation: All spreadsheet formulas begin with an equal (=) sign.
Explanation: All spreadsheet formulas begin with an equal (=) sign.
Q4. Which function returns the highest value?
Answer: A. MAX
Explanation: MAX identifies the largest number in a selected range.
Explanation: MAX identifies the largest number in a selected range.
Q5. A group of selected cells is called?
Answer: C. Range
Explanation: Example of range: A1:C5.
Explanation: Example of range: A1:C5.
Q6. Which chart represents data using bars?
Answer: C. Bar
Explanation: Bar charts compare categories using horizontal/vertical bars.
Explanation: Bar charts compare categories using horizontal/vertical bars.
Q7. The default alignment of numbers is?
Answer: B. Right
Explanation: Numbers align right for calculation clarity.
Explanation: Numbers align right for calculation clarity.
Q8. Which function calculates average?
Answer: C. AVERAGE
Explanation: Adds values and divides by count.
Explanation: Adds values and divides by count.
Q9. Workbook is a collection of?
Answer: C. Worksheets
Explanation: A workbook contains multiple sheets.
Explanation: A workbook contains multiple sheets.
Q10. Which key edits active cell?
Answer: B. F2
Explanation: F2 enables cell editing mode.
Explanation: F2 enables cell editing mode.
Q11. SUM function shortcut AutoSum key?
Answer: B
AutoSum quickly inserts SUM.
AutoSum quickly inserts SUM.
Q12. Relative reference changes when copied?
Answer: A
Example: A1 → B1.
Example: A1 → B1.
Q13. Absolute reference symbol?
Answer: B
$A$1 remains constant.
$A$1 remains constant.
Q14. Function to find lowest value?
Answer: A
Returns smallest number.
Returns smallest number.
Q15. Chart showing proportions?
Answer: A
Pie charts show percentage share.
Pie charts show percentage share.
Q16. Spreadsheet file extension (Excel)?
Answer: B
Modern Excel format.
Modern Excel format.
Q17. Rows are labeled as?
Answer: A
Columns use alphabets.
Columns use alphabets.
Q18. Formula without function?
Answer: A
Uses operators only.
Uses operators only.
Q19. Conditional counting?
Answer: B
Counts based on criteria.
Counts based on criteria.
Q20. Intersection reference example?
Answer: A
Column A + Row 1.
Column A + Row 1.
