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.

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 quizzes

• Creating Charts
• Introduction to Spreadsheets

Browse all Spreadsheets quizzes