Microsoft Excel Guide: Formulas and Chart Creation (Part 4)
Explore “Formulas and Chart Creation” in this Microsoft Excel Guide lesson. Part 4 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
- FORMATTING WORKBOOKS
- ENTERING FORMULAS
- CREATING CHARTS
Contents
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel – Presentation 02: original teaching slides for this study series.
FORMATTING WORKBOOKS
FORMATTING WORKBOOKS To check the spelling of your data, highlight the desired cells and click on the spell check button. When entering dollar amounts, you can select the cells you desire to be currency formatted, then click on the “$” button to change the cells. You can bold, italicize, or underline any information in the cells, as well as change the styles and fonts of those cells.
ENTERING FORMULAS
ENTERING FORMULAS When entering numerical data, you can command Excel to do any mathematical function. Start each formula with an equal sign (=). To enter the same formulas for a range of cells, use the colon sign “:” ADDITION FORMULAS To add cells together use the “+” sign. To sum up a series of cells, highlight the cells, then click the auto sum button. The answer will appear at the bottom of the highlighted box.
ENTERING FORMULAS
ENTERING FORMULAS SUBTRACTION FORMULAS To subtract cells, use the “-” sign. DIVISION FORMULAS To divide cells, use the “/” sign. MULTIPLICATION FORMULAS To multiply cells, use the “*” sign.
CREATING CHARTS
CREATING CHARTS With the Excel program you can create charts with the “Chart Wizard.” Step 1: Choose a chart type. Step 2: Highlight the data that you wish to be included in the chart.
Review questions and answers
What are the key points about FORMATTING WORKBOOKS?
FORMATTING WORKBOOKS To check the spelling of your data, highlight the desired cells and click on the spell check button. When entering dollar amounts, you can select the cells you desire to be currency formatted, then click on the “$” button to change the cells. You can bold, italicize, or underline any information in the cells, as well as change the…
What are the key points about ENTERING FORMULAS?
ENTERING FORMULAS When entering numerical data, you can command Excel to do any mathematical function. Start each formula with an equal sign (=). To enter the same formulas for a range of cells, use the colon sign “:” ADDITION FORMULAS To add cells together use the “+” sign. To sum up a series of cells, highlight the cells, then click the auto sum button.…
What are the key points about CREATING CHARTS?
CREATING CHARTS With the Excel program you can create charts with the “Chart Wizard.” Step 1: Choose a chart type. Step 2: Highlight the data that you wish to be included in the chart.
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 Important Concepts 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.