Basic Formulas Quiz - CBSE Class 7 ICT

Free practice quiz: Basic Formulas (CBSE Class 7 ICT). 20 multiple-choice questions with answers and explanations. Play online, no sign-up needed.

This CBSE Class 7 ICT practice quiz has 20 multiple-choice questions on Basic Formulas. Try the 5 sample questions below (tap an option to check yourself), then play the full quiz online. No sign-up needed.

Sample questions

1. What is a formula in a spreadsheet?

   1. A way to format text
   2. A way to perform calculations
   3. A way to change colors
   4. A way to insert images
   Show answer

   Answer: B. A way to perform calculations

2. What is the result of the formula =A1*2 if A1 contains 3?

   1. 3
   2. 6
   3. 5
   4. Error
   Show answer

   Answer: B. 6

3. What is the correct way to reference cell C3 in a formula?

   1. C3
   2. #C3
   3. C$3
   4. C.3
   Show answer

   Answer: A. C3

4. How can you create a formula that multiplies A2 by B2 and then adds C2?

   1. =A2*B2+C2
   2. =A2+B2*C2
   3. =C2*A2+B2
   4. =B2+C2*A2
   Show answer

   Answer: A. =A2*B2+C2

5. Using the formula =IF(A1>10, 'High', 'Low'), what does 'High' mean?

   1. A1 is greater than 10
   2. A1 is less than 10
   3. A1 is equal to 10
   4. A1 has no value
   Show answer

   Answer: A. A1 is greater than 10

More questions in this quiz

Answers and explanations are in the full quiz.

1. Which symbol is used to start a formula in a spreadsheet?
2. What will the formula =5+10 calculate?
3. Which of the following operations can be done using basic formulas?
4. If you want to subtract numbers in a spreadsheet, which symbol would you use?
5. In a formula, what does the function SUM(A1:A5) do?
6. Which formula would you use to find the average of numbers in cells B1 to B10?
7. Which formula will give you the number of entries in the cells D1 to D10?
8. What does the formula =MAX(E1:E10) return?
9. In a spreadsheet, what does the error #DIV/0! indicate?
10. Which formula is correct to multiply cell A1 by the number 10?
11. What happens if you enter the formula =A1/B1 when B1 is zero?
12. If you wanted to concatenate text from A1 and A2, which formula would you use?
13. What will the formula =IF(B1=1, 'Yes', 'No') return if B1 is 2?
14. How would you check if cell C3 is empty in a formula?
15. Which formula correctly combines a conditional and a sum?

More quizzes

• Understanding Rows and Columns▶ Play

Browse all Introduction to Spreadsheets quizzes

More to play