Functions of the menu bar

Functions of the menu bar

A spreadsheet program has two main bars at the top of the interface: the Title bar and the Menu bar.

Title bar

1. The title bar displays the file name of the workbook currently in use and the name of the application software (e.g., Microsoft Excel).
2. When you open Excel for the first time, the workbook gets a default name, such as Book1.
3. After naming and saving the workbook (e.g., saving it as School Equipment), the title bar updates to reflect the saved file name.

Menu bar

The menu bar displays a list of tabs used to issue commands in Excel. Each tab opens a ribbon containing groups of commands that allow users to work efficiently. Below is a breakdown of the main tabs and their functions:

1. File Tab — Contains ribbon commands for file management tasks such as saving, opening, printing, and sharing workbooks.
2. Home Tab
   • Provides tools for common tasks, including:
     • Formatting text (e.g., bold, underline).
     • Copying and pasting content.
     • Applying formats to cells in a worksheet.
3. Insert Tab
   • Allows users to insert:
     • Tables, illustrations, charts, and reports.
     • Apps, filters, links, texts, symbols, and spark lines.
4. Page Layout Tab
   • Contains tools for formatting the page, such as:
     • Themes.
     • Page setup and scaling.
     • Sheet options and arranging elements.
5. Formulas Tab
   • Provides options for working with formulas, such as:
     • Accessing the Function Library.
     • Managing defined names and formula auditing.
     • Performing calculations.
6. Data Tab
   • Used for managing and analyzing data. Features include:
     • Importing external data.
     • Sorting and filtering data.
     • Data tools for making connections and outlining.
7. Review Tab
   • Enables proofing and collaboration tasks, such as:
     • Checking spelling and grammar.
     • Changing the language.
     • Adding comments.
     • Protecting sheets and tracking changes.
8. View Tab
   • Displays commands that control the view of the workbook, including:
     • Workbook views (e.g., Normal, Page Layout).
     • Display options, zoom tools, and window management.
     • Macros for automating tasks.