Microsoft Excel Guide: Data Entry, Sorting and Workbook Formatting (Part 3)
Explore “Data Entry, Sorting and Workbook Formatting” in this Microsoft Excel Guide lesson. Part 3 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
- OVERVIEW OF THE EXCEL SCREEN
- TIPS FOR ENTERING DATA
- SORTING DATA:
- FORMATTING WORKBOOKS
Contents
- Read the original document
- OVERVIEW OF THE EXCEL SCREEN
- TIPS FOR ENTERING DATA
- SORTING DATA:
- FORMATTING WORKBOOKS
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel – Presentation 02: original teaching slides for this study series.
OVERVIEW OF THE EXCEL SCREEN
OVERVIEW OF THE EXCEL SCREEN The Name Box indicates what cell you are in. This cell is called the “active cell.” This cell is highlighted by a black box. The “=” is used to edit your formula on your selected cell. The Formula Bar indicates the contents of the cell selected. If you have created a formula, then the formula will appear in this space.
TIPS FOR ENTERING DATA
TIPS FOR ENTERING DATA To highlight a series of cells click and drag the mouse over the desired area. To move a highlighted area, click on the border of the box and drag the box to the desired location.
SORTING DATA:
SORTING DATA: You can sort data (alphabetically, numerically, etc). By highlighting cells then pressing the sort shortcut key.
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
TIPS FOR ENTERING DATA
TIPS FOR ENTERING DATA You can cut and paste to move data around. To update your worksheets, you can use the find and replace action (under the Edit Menu). To change the order of worksheets, click and drag the worksheet tab to the desired order.
FORMATTING WORKBOOKS
FORMATTING WORKBOOKS To add borders to cells, you can select from various border options. To add colors to text or cells, you can select the text color option or the cell fill option, then select the desired color. To change the alignment of the cells, highlight the desired cells and select any of the three alignment options.
Review questions and answers
What are the key points about OVERVIEW OF THE EXCEL SCREEN?
OVERVIEW OF THE EXCEL SCREEN The Name Box indicates what cell you are in. This cell is called the “active cell.” This cell is highlighted by a black box. The “=” is used to edit your formula on your selected cell. The Formula Bar indicates the contents of the cell selected. If you have created a formula, then the formula will appear in this space.
What are the key points about TIPS FOR ENTERING DATA?
TIPS FOR ENTERING DATA To highlight a series of cells click and drag the mouse over the desired area. To move a highlighted area, click on the border of the box and drag the box to the desired location.
What are the key points about SORTING DATA:?
SORTING DATA: You can sort data (alphabetically, numerically, etc). By highlighting cells then pressing the sort shortcut key.
What are the key points about FORMATTING WORKBOOKS?
FORMATTING WORKBOOKS To add borders to cells, you can select from various border options. To add colors to text or cells, you can select the text color option or the cell fill option, then select the desired color. To change the alignment of the cells, highlight the desired cells and select any of the three alignment options.
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 OVERVIEW OF THE EXCEL SCREEN 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.