Class 7 Computer & AI Chapter 2: Spreadsheets: Formulas, Functions and Charts — practice questions with answers
Free practice for Class 7 Computer & AI, Chapter 2: Spreadsheets: Formulas, Functions and Charts. Try the solved questions below, then take a free test with instant marking and explanations.
25 questions10 easy, 11 medium, 4 hardNCERT · CBSE · State boards
Sample questions with solutions
Q1. In a spreadsheet, which is the address of the cell in column C, row 5?
- C5
- 5C
- CC5
- R5C
Show answer
Answer: A. C5
Why: Column letter first, then row number. [NAL syllabus, Class 7 Unit 2]
Why: Column letter first, then row number. [NAL syllabus, Class 7 Unit 2]
Q2. Every formula in a spreadsheet begins with which symbol?
- =
- #
- @
- +
Show answer
Answer: A. =
Why: Typing = tells the spreadsheet a formula follows. [NAL syllabus, Class 7 Unit 2]
Why: Typing = tells the spreadsheet a formula follows. [NAL syllabus, Class 7 Unit 2]
Q3. A1 = 12 and B1 = 8. What does =A1+B1 show?
Show answer
Answer: 20 (± 0)
Why: 12 + 8 = 20. [NAL syllabus, Class 7 Unit 2]
Why: 12 + 8 = 20. [NAL syllabus, Class 7 Unit 2]
Q4. A1 = 12 and B1 = 8. What does =A1*B1 show?
Show answer
Answer: 96 (± 0)
Why: * means multiply: 96. [NAL syllabus, Class 7 Unit 2]
Why: * means multiply: 96. [NAL syllabus, Class 7 Unit 2]
Q5. A2 = 50 and B2 = 5. What does =A2/B2 show?
Show answer
Answer: 10 (± 0)
Why: / means divide: 10. [NAL syllabus, Class 7 Unit 2]
Why: / means divide: 10. [NAL syllabus, Class 7 Unit 2]
Q6. For the same marks, what does =MAX(B2:B6) show?
Show answer
Answer: 90 (± 0)
Why: The highest mark is 90. [NAL syllabus, Class 7 Unit 2]
Why: The highest mark is 90. [NAL syllabus, Class 7 Unit 2]
Practise all 25 questions free
Timed test, marked instantly, with the correct answer and explanation for every question and a chapter-wise report.
Start the free testFrequently asked questions
How many practice questions are there for Class 7 Computer & AI Chapter 2: Spreadsheets: Formulas, Functions and Charts?
25 questions (10 easy, 11 medium, 4 hard). A few are solved on this page; the free test shows the answer and explanation for every question after you submit.
Is this chapter from the NCERT book?
Yes — it follows the NCERT Class 7 Computer & AI syllabus, used by CBSE and many state boards.