Mission 7: Simple Data Editing
Learning Objective
Learn how to perform basic data manipulations such as inserting rows and columns, editing cells, and deleting data.
Dataset
Download the required dataset: business_transaction.xlsx
Getting Started
First, open the data you want to edit.
Basic Editing Operations
Editing a Cell
Double-click on any cell and edit the value directly.
Note
When entering a new value, make sure it's compatible with the column type. For example, if it's a decimal column, you cannot enter text.
Inserting a Row
- Right-click anywhere in a row
- Select either "Insert a new row after" or "Insert a new row before"
Inserting a Column
- Right-click on a column header
- Select either "Insert a new column before" or "Insert a new column after"
Deleting One or Multiple Rows
- Select one or multiple rows by dragging the mouse over the row numbering
- Right-click inside the selection
- Click "Delete selected rows"
Deleting One or Multiple Columns
- Select one or multiple columns by holding and dragging the mouse over the column headers
- Right-click inside the selection
- Click "Delete selected columns"
Quick Reference
| Action | How To |
|---|---|
| Edit Cell | Double-click on cell |
| Insert Row | Right-click row → Insert before/after |
| Insert Column | Right-click column header → Insert before/after |
| Delete Rows | Select rows → Right-click → Delete |
| Delete Columns | Select column headers → Right-click → Delete |
Summary
You've successfully learned how to:
✓ Edit individual cell values
✓ Insert new rows and columns
✓ Delete single or multiple rows
✓ Delete single or multiple columns
✓ Perform basic data table manipulations