Skip to main content

Microsoft Excel – Presentation 02: The Formula Bar — Part 3

Microsoft Excel Essentials: Ribbon Commands and Formula Bar (Part 3)

Explore “Ribbon Commands and Formula Bar” in this Microsoft Excel Essentials 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.

Cover slide of Microsoft Excel - Presentation 02
Original source: Microsoft Excel – Presentation 02.

Lesson topics

  • The Ribbon : In Microsoft Excel 2007 , the ribbon is used to issue commands .
  • The Formula Bar

Contents

  1. Read the original document
  2. The Ribbon : In Microsoft Excel 2007 , the ribbon is used to issue commands .
  3. The Formula Bar

REQUEST THE COMPLETE DOCUMENT ON WHATSAPP

Read the original source document

Microsoft Excel – Presentation 02: original teaching slides for this study series.

Open the original document in Google Drive

The Ribbon : In Microsoft Excel 2007 , the ribbon is used to issue commands .

The Ribbon : In Microsoft Excel 2007 , the ribbon is used to issue commands . The ribbon is located near the top of the excel windows ,below the quick access toolbar. At the top of the ribbon are several tabs ; clicking a tab displays several related command groups . Within each group are related command buttons You click buttons to issue commands or to access menus and dialog boxes. Worksheets:

Each worksheets in MS-Excel contains columns and rows . The columns are lettered A to Z and the containing AA, AB, AC, AD and so on. There are 65,536 rows and 256 columns in a worksheet in general . The combination of a column coordinate and a row coordinate make up a cell address.

The Formula Bar

The Formula Bar If the formula bar is turned on , the cell addredss of the cell you are in displays in the name box which is located on the left side of the Formula Bar . Cell entries display on the right side of the Formula bar . If you do not see the Formula bar in your window , choose the view tab & click Formula bar in the show/hide group . The Formula bar appears. The Status Bar

The status bar appears at the very bottom of the excel window and provides such information as the sum , average , minimum and maximum value of selected numbers. You can change what displays on the status bar by right clicking on the status bar and clicking on the status bar and selecting the options you want from your customised status bar menu. You click a menu item to

select it. You click it again to de select it. A check mark next to an item means the item is selected.

Review questions and answers

What are the key points about The Ribbon : In Microsoft Excel 2007 , the ribbon is used to issue commands .?

The Ribbon : In Microsoft Excel 2007 , the ribbon is used to issue commands . The ribbon is located near the top of the excel windows ,below the quick access toolbar. At the top of the ribbon are several tabs ; clicking a tab displays several related command groups . Within each group are related command buttons You click buttons to issue commands or to…

What are the key points about The Formula Bar?

The Formula Bar If the formula bar is turned on , the cell addredss of the cell you are in displays in the name box which is located on the left side of the Formula Bar . Cell entries display on the right side of the Formula bar . If you do not see the Formula bar in your window , choose the view tab & click Formula bar in the show/hide group . The Formula…

More lessons from this document

  1. Microsoft Excel – Presentation 02 — Part 1
  2. Microsoft Excel – Presentation 02 — Part 2
  3. Microsoft Excel – Presentation 02 — Part 3
  4. Microsoft Excel – Presentation 02 — Part 4
  5. Microsoft Excel – Presentation 02 — Part 5

Conclusion

The important points in The Formula Bar 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.

REQUEST THE COMPLETE DOCUMENT ON WHATSAPP

Scroll to Top
Changia Notes / Document