Microsoft Excel Essentials: Inserting, Deleting and Clearing Rows (Part 5)
Explore “Inserting, Deleting and Clearing Rows” in this Microsoft Excel Essentials lesson. Part 5 of the five-part series brings together the source material and lesson topics. Use the contents links to find a section, read the notes, and consult the complete original teaching slides below.
Lesson topics
- Inserting/Deleting/Clearing column or row
Contents
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel – Presentation 02: original teaching slides for this study series.
Inserting/Deleting/Clearing column or row
Inserting/Deleting/Clearing column or row Select the column or row where you want to insert the new column or row; Excel will insert the same number of columns or rows as you select. In the cells group on the home tab , click the Insert button. Clearing data from a work sheet removes the data but leaves the blank cells. Deleting data from the worksheet removes both the data and cells. Entering A Formula
A formula is an expression that returns a value. A formula is written using operators that combine different values , returning a single value that is then displayed in the cell . The most commonly used operators are arithmetic operators.
Review questions and answers
What are the key points about Inserting/Deleting/Clearing column or row?
Inserting/Deleting/Clearing column or row Select the column or row where you want to insert the new column or row; Excel will insert the same number of columns or rows as you select. In the cells group on the home tab , click the Insert button. Clearing data from a work sheet removes the data but leaves the blank cells. Deleting data from the worksheet…
More lessons from this document
- Microsoft Excel – Presentation 02 — Part 1
- Microsoft Excel – Presentation 02 — Part 2
- Microsoft Excel – Presentation 02 — Part 3
- Microsoft Excel – Presentation 02 — Part 4
- Microsoft Excel – Presentation 02 — Part 5
Conclusion
The important points in Inserting/Deleting/Clearing column or row should be reviewed alongside the definitions, examples and comparisons given above. Continue with the other four articles to cover the rest of the source material.