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.

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 quizzes

• Understanding Rows and Columns

Browse all Introduction to Spreadsheets quizzes