Question Paper
Class / Subject: Class 7 (ICSE) · Computer Applications
Chapter: Chapter 2 — Chapter 2: Advanced Spreadsheet Functions
Time Allowed: 32 minutes
Max Marks: 16
1. What does the IF function do? [1]
(A) Checks a condition and returns different values
(B) Always returns the same value
(C) Deletes data
(D) Sorts data only
2. What is the format of an IF function? [1]
(A) IF(condition, true value, false value)
(B) IF(value, value, value, value)
(C) IF only takes one value
(D) IF has no format
3. What does IF(A1>50, 'Pass', 'Fail') check? [1]
(A) If A1 is greater than 50
(B) If A1 equals 50
(C) If A1 is less than 50
(D) Nothing specific
4. What does the IF function show if the condition is true? [1]
(A) The 'true' value specified
(B) The 'false' value always
(C) Nothing
(D) An error
5. What does the IF function show if the condition is false? [1]
(A) The 'false' value specified
(B) The 'true' value always
(C) Nothing
(D) An error
6. What is the IF function useful for? [1]
(A) Automatically categorising data
(B) Deleting data
(C) Printing documents
(D) Nothing useful
7. Why learn the IF function? [1]
(A) To use spreadsheets more powerfully
(B) No reason
(C) It's not useful
(D) Only for tests
8. What does IF help avoid? [1]
(A) Manually checking data
(B) Using spreadsheets at all
(C) Sorting data
(D) Filtering data
9. What does sorting do? [1]
(A) Arranges data in a specific order
(B) Deletes data
(C) Hides all data
(D) Creates new data
10. What is an example of sorting? [1]
(A) Arranging names alphabetically
(B) Deleting a file
(C) Printing a document
(D) Nothing specific
11. What does filtering do? [1]
(A) Shows only data meeting certain criteria
(B) Deletes all data
(C) Sorts data alphabetically only
(D) Nothing useful
12. What is an example of filtering? [1]
(A) Showing only scores above 80
(B) Deleting all scores
(C) Printing everything
(D) Nothing specific
13. Where can we sort and filter data easily? [1]
(A) Spreadsheets
(B) Only on paper
(C) Nowhere
(D) Only in books
14. What do filters help with? [1]
(A) Narrowing down large datasets
(B) Making data bigger
(C) Deleting data permanently
(D) Nothing useful
15. Why learn sorting and filtering? [1]
(A) To manage and analyse data efficiently
(B) No reason
(C) It's not useful
(D) Only for tests
16. What can sorting help us find? [1]
(A) Information more easily
(B) Nothing useful
(C) Only random data
(D) Errors only