Performing Calculations Quiz - CBSE Class 7 ICT

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

This CBSE Class 7 ICT practice quiz has 19 multiple-choice questions on Performing Calculations, and 19 of them come with an explanation. 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 cell in a spreadsheet?

   1. A single data point
   2. A row of data
   3. A column of data
   4. The entire spreadsheet
   Show answer

   Answer: A. A single data point

   In a spreadsheet, a cell is the smallest unit where data can be entered, representing a single data point.

2. How do you refer to cell A1 in a formula?

   1. A1
   2. 1A
   3. Cell A1
   4. A_1
   Show answer

   Answer: A. A1

   In a spreadsheet formula, cells are referred to by their column letter followed by their row number, so 'A1' refers to the cell in column A and row 1.

3. What does the COUNT function do?

   1. Counts the total number of rows
   2. Counts the number of cells with numbers
   3. Adds all the numbers
   4. Finds the maximum number
   Show answer

   Answer: B. Counts the number of cells with numbers

   The COUNT function is used to count how many cells in a specified range contain numerical values.

4. What does the IF function do?

   1. Performs a calculation
   2. Checks a condition and returns a value based on if it’s true or false
   3. Counts cells
   4. Finds the maximum value
   Show answer

   Answer: B. Checks a condition and returns a value based on if it’s true or false

   The IF function evaluates a condition; if true, it returns one value, and if false, it returns another.

5. What does the CONCATENATE function do?

   1. Joins two or more strings together
   2. Counts characters in a cell
   3. Calculates the average
   4. Finds the minimum value
   Show answer

   Answer: A. Joins two or more strings together

   The CONCATENATE function combines multiple text strings into one single string.

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 does the SUM function do?
3. What is the purpose of the AVERAGE function?
4. Which function would you use to determine the highest number in a set?
5. What will the formula =10*5 return?
6. If cell A1 contains 5 and cell A2 contains 10, what does the formula =A1+A2 return?
7. Which formula correctly finds the average of values in cells A1 to A5?
8. What is the result of the formula =10/(5-5)?
9. How can you round a number in a spreadsheet?
10. If cell B1 contains a formula that results in #DIV/0!, what does it mean?
11. Which formula would you use to display the current date?
12. If you need to change the cell reference from A1 to B1 in a formula, what will you use?
13. If you use the formula =COUNTIF(A1:A10, '>5'), what does it do?
14. What does the function VLOOKUP do?

More quizzes

• Creating Charts▶ Play
• Introduction to Spreadsheets▶ Play

Browse all Spreadsheets quizzes

More to play