Insert/delete rows and columns MCQs Quiz | Class 9
This quiz is for Class IX students studying Computer Applications (Code 165). It covers Unit 3: Office Tools (Spreadsheets), focusing on topics like sheet structure and managing data tables. Test your knowledge on how to insert and delete rows and columns. After submitting, you can review your answers and download a PDF of your results.
Understanding Spreadsheet Structure
A spreadsheet is a powerful tool for organizing, analyzing, and storing data in a tabular format. The fundamental structure of a spreadsheet consists of a grid of cells, organized into rows and columns. Understanding this structure is key to effectively managing your data.
Key Components of a Worksheet
- Cell: The basic unit of a worksheet, formed by the intersection of a row and a column. Each cell can hold data like text, numbers, or formulas.
- Row: A horizontal series of cells in a worksheet. Rows are identified by numbers (1, 2, 3, …).
- Column: A vertical series of cells in a worksheet. Columns are identified by letters (A, B, C, …).
- Active Cell: The currently selected cell, indicated by a bold border. Data is entered into the active cell.
- Cell Address: The unique identifier for a cell, which is a combination of its column letter and row number (e.g., A1, B2, C5).
Managing Rows and Columns
As your data grows, you will often need to add or remove rows and columns to keep your worksheet organized. These operations are straightforward but important to master.
Inserting Rows and Columns
You can insert new, blank rows or columns anywhere in your worksheet.
- To Insert a Row: Select the row number below where you want the new row to appear. Right-click and choose “Insert”. The existing rows from that point downwards will shift down.
- To Insert a Column: Select the column letter to the right of where you want the new column to appear. Right-click and choose “Insert”. The existing columns from that point will shift to the right.
- To Insert Multiple Rows/Columns: Select the same number of rows or columns that you want to insert, then right-click and choose “Insert”. For example, to insert 3 new rows, select 3 existing rows first.
Deleting Rows and Columns
Deleting removes the entire row or column, not just its content. This is different from clearing the content (using the Delete key), which leaves the cells empty but keeps the structure intact.
- To Delete a Row: Select the row number(s) you want to remove. Right-click on the selection and choose “Delete”. The rows below will shift up to fill the gap.
- To Delete a Column: Select the column letter(s) you want to remove. Right-click on the selection and choose “Delete”. The columns to the right will shift left.
Quick Keyboard Shortcuts
Using shortcuts can significantly speed up your work in a spreadsheet.
| Action | Common Shortcut |
|---|---|
| Select an entire row | Shift + Spacebar |
| Select an entire column | Ctrl + Spacebar |
| Insert a new row/column (after selecting) | Ctrl + Shift + + (Plus sign) |
| Delete a selected row/column | Ctrl + – (Minus sign) |
Quick Revision Points
- Rows are horizontal and numbered. Columns are vertical and lettered.
- Inserting a row pushes existing rows down.
- Inserting a column pushes existing columns to the right.
- Deleting a row or column permanently removes it and its data.
- Clearing content just empties the cells, leaving the row/column structure.
- To select an entire column, click on its header letter.
- To select an entire row, click on its header number.
Practice Questions
- What happens if you select column D and press Ctrl + -?
- You need to add a new entry between row 5 and row 6. Which row should you select before inserting?
- How can you insert three new columns between column A and column B?
- What is the difference between pressing the ‘Delete’ key on a selected row and choosing the ‘Delete Row’ option?
- If you are in cell Z10 and press the right arrow key, what will be the address of the next cell?
