Microsoft Excel Guide: View, Insert and Format Menus (Part 2)
Explore “View, Insert and Format Menus” in this Microsoft Excel Guide lesson. Part 2 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
- VIEW MENU
- INSERT MENU
- FORMAT MENU
- HELP MENU AND OFFICE ASSISTANT
- OVERVIEW OF THE EXCEL SCREEN
Contents
- Read the original document
- VIEW MENU
- INSERT MENU
- FORMAT MENU
- HELP MENU AND OFFICE ASSISTANT
- OVERVIEW OF THE EXCEL SCREEN
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel – Presentation 02: original teaching slides for this study series.
VIEW MENU
VIEW MENU The View menu allows you different options of viewing your work. You can enable a Full Screen view that changes the view to include just the worksheet and Menu bar. You can zoom in on your worksheet to focus on a smaller portion.
VIEW MENU
VIEW MENU You can change the view of your work so that it is page by page. You can insert Headers and Footers to your work. You can add comments about a specific cell for future reference.
INSERT MENU
INSERT MENU The Insert Menu allows you to: Add new worksheets, rows, and columns to an existing. You can also insert charts, pictures, and objects onto your worksheet.
FORMAT MENU
FORMAT MENU You can change row and column width and height in the “Row” and “Column” options. You can rename worksheets and change their order in the “Sheet” option. The “AutoFormat” option allows you to apply pre-selected colors, fonts, and sizes to entire worksheets.
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
FORMAT MENU
FORMAT MENU You can change the colors, borders, sizes, alignment, and font of a certain cell by going to the “Cell” option in the Format Menu.
HELP MENU AND OFFICE ASSISTANT
HELP MENU AND OFFICE ASSISTANT The Help Menu is used to answer any questions you many have with the program. You can also get online assistance if it is needed. The Office Assistant is a shortcut to the Help Menu. You can ask the assistant a question and it will take you directly to an index of topics that will help you solve your problem.
OVERVIEW OF THE EXCEL SCREEN
OVERVIEW OF THE EXCEL SCREEN Microsoft Excel consists of workbooks. Within each workbook, there is an infinite number of worksheets. Each worksheet contains columns and rows. There is 65,536 number of rows & 256 number of columns Where a column and a row intersect is called the cell. For example, cell B6.We enter our data into the cells on the worksheet.
The tabs at the bottom of the screen represent different worksheets within a workbook.
Review questions and answers
What are the key points about VIEW MENU?
VIEW MENU The View menu allows you different options of viewing your work. You can enable a Full Screen view that changes the view to include just the worksheet and Menu bar. You can zoom in on your worksheet to focus on a smaller portion.
What are the key points about INSERT MENU?
INSERT MENU The Insert Menu allows you to: Add new worksheets, rows, and columns to an existing. You can also insert charts, pictures, and objects onto your worksheet.
What are the key points about FORMAT MENU?
FORMAT MENU You can change row and column width and height in the “Row” and “Column” options. You can rename worksheets and change their order in the “Sheet” option. The “AutoFormat” option allows you to apply pre-selected colors, fonts, and sizes to entire worksheets.
What are the key points about HELP MENU AND OFFICE ASSISTANT?
HELP MENU AND OFFICE ASSISTANT The Help Menu is used to answer any questions you many have with the program. You can also get online assistance if it is needed. The Office Assistant is a shortcut to the Help Menu. You can ask the assistant a question and it will take you directly to an index of topics that will help you solve your problem.
What are the key points about OVERVIEW OF THE EXCEL SCREEN?
OVERVIEW OF THE EXCEL SCREEN Microsoft Excel consists of workbooks. Within each workbook, there is an infinite number of worksheets. Each worksheet contains columns and rows. There is 65,536 number of rows & 256 number of columns Where a column and a row intersect is called the cell. For example, cell B6.We enter our data into the cells on 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 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.