Understanding Rows and Columns Quiz - CBSE Class 7 ICT

Free practice quiz: Understanding Rows and Columns (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 Understanding Rows and Columns. 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 row in a spreadsheet?

   1. A horizontal group of cells
   2. A vertical group of cells
   3. A label for a cell
   4. A formula in a cell
   Show answer

   Answer: A. A horizontal group of cells

2. How can you identify the active cell in a spreadsheet?

   1. It’s highlighted
   2. It has a border
   3. It’s bold
   4. It’s colored blue
   Show answer

   Answer: A. It’s highlighted

3. In a spreadsheet, which of the following actions can you perform on a row?

   1. Insert a new column
   2. Delete a cell
   3. Sort data
   4. Change the font of a cell
   Show answer

   Answer: C. Sort data

4. How can you quickly select an entire column in a spreadsheet?

   1. Click the cell
   2. Click the column header
   3. Double-click a cell
   4. Right-click any cell
   Show answer

   Answer: B. Click the column header

5. What is the typical format of referring to a cell in a spreadsheet like Excel?

   1. RowNumber ColumnLetter
   2. ColumnLetter RowNumber
   3. CellID
   4. Column_Row
   Show answer

   Answer: B. ColumnLetter RowNumber

More questions in this quiz

Answers and explanations are in the full quiz.

1. What does a column represent in a spreadsheet?
2. Which of the following is true about rows and columns?
3. In spreadsheets, what is the intersection of a row and a column called?
4. What happens when you click on a cell in a spreadsheet?
5. What do you call a set of data in a single cell?
6. If you enter data into a cell, what is the maximum number of characters you can typically enter?
7. What is the primary purpose of using rows and columns in a spreadsheet?
8. What does it mean to freeze a row in a spreadsheet?
9. Which feature allows you to view both the title row and the data as you scroll down?
10. In spreadsheet software, what is the maximum number of columns usually available?
11. What tool would you use to analyze data in rows and columns?
12. When resizing a column, what happens to the other columns?
13. If you want to quickly navigate to the last row of data in a column, what key would you press?
14. Which of the following methods can you use to sort rows based on the values in a column?
15. To highlight rows based on certain criteria, which feature would you use?

More quizzes

• Basic Formulas▶ Play

Browse all Introduction to Spreadsheets quizzes

More to play