Question Paper
Class / Subject: Class 6 (ICSE) · Computer Applications
Chapter: Chapter 2 — Chapter 2: Advanced Spreadsheet Skills
Time Allowed: 32 minutes
Max Marks: 16
1. What do we do first to create a chart? [1]
(A) Select the data
(B) Choose a printer
(C) Delete the data
(D) Ignore the data
2. What does a bar chart do? [1]
(A) Compares quantities
(B) Shows parts of a whole only
(C) Prints documents
(D) Sends emails
3. What does a pie chart do? [1]
(A) Shows parts of a whole
(B) Compares quantities using bars
(C) Prints documents
(D) Sends emails
4. What do charts need to be clear? [1]
(A) Titles and labels
(B) Nothing specific
(C) Only colours
(D) Only numbers
5. What do charts help us do with data? [1]
(A) Spot patterns and compare information
(B) Hide information
(C) Confuse readers
(D) Delete data
6. Why present data as a chart? [1]
(A) To present findings clearly
(B) To make data confusing
(C) No reason
(D) Only for decoration
7. What type of chart shows percentages well? [1]
(A) A pie chart
(B) A bar chart only
(C) Neither type
(D) No chart can show this
8. What type of chart compares different categories? [1]
(A) A bar chart
(B) A pie chart only
(C) Neither type
(D) No chart can do this
9. What does the AVERAGE function calculate? [1]
(A) The mean of a group of numbers
(B) The largest number
(C) The smallest number
(D) Nothing useful
10. What does the MAX function find? [1]
(A) The largest number
(B) The smallest number
(C) The average
(D) Nothing
11. What does the MIN function find? [1]
(A) The smallest number
(B) The largest number
(C) The average
(D) Nothing
12. What might AVERAGE be used for? [1]
(A) Finding average marks
(B) Finding the highest score only
(C) Finding the lowest score only
(D) Nothing useful
13. What might MAX be used for? [1]
(A) Finding the highest score
(B) Finding the average
(C) Finding the lowest score
(D) Nothing useful
14. What might MIN be used for? [1]
(A) Finding the lowest temperature
(B) Finding the highest score
(C) Finding the average
(D) Nothing useful
15. Why use these functions? [1]
(A) To save time and analyse data quickly
(B) To waste time
(C) To confuse data
(D) No reason
16. Do these functions require manual calculation? [1]
(A) No, they calculate automatically
(B) Yes, always manual
(C) They cannot calculate
(D) They are unrelated to calculation