Microsoft Excel Interface

• Founders of Microsoft

  Bill Gates and Paul Allen
• Microsoft Excel 2016


  It helps users efficiently manage, analyze, and present data for informed decision-making.
• PARTS OF EXCEL

  1. File Tab
  2. Quick Access Toolbar
  3. Title Bar
  4. Ribbon
  5. Ribbon Tabs
  6. Contextual Tabs
  7. Groups
  8. Gallery
  9. Name Bar
  10. Formula Bar
  11. Columns
  12. Rows
  13. Cell
  14. Sheet Tabs
  15. Status Bar
  16. Views Toolbar
  17. Zoom Control
• File Tab

  • It is located on the upper left corner of the screen which displays the the Microsoft Office Backstage View when clicked.
  • In Excel 2007, it was called the Office Button
  • The Backstage View gives you various options for opening, saving, printing, viewing and managing your database.
• Quick Access Toolbar

  • This contains shortcuts for frequently-used commands.
  • By default, it displays three buttons: Save, Undo and Redo.
• To add command in the Quick Access Toolbar:

  1. Click the Customize button which has a small arrow pointing down on the right side of the Quick Access Toolbar.
  2. Click the desired command on the menu.
• Title Bar


  It displays the name of the application and the name of the workbook you are currently working on.
• Workbook

  • A workbook is comprised of one or more worksheets where data are entered.
  • The work you do in Excel is performed in a workbook file
• Ribbon

  • It is a long bar below the Title Bar
  • It contains a Ribbon, also called Command Tab
  • It has group-related functions into one tab to make it easier to use.
• Ribbon Tabs


  Group the commands into top-level categories.
• Contextual Tab


  A command tab that appears depending on the task.
• Groups


  These are consolidated and function-related commands within a tab
• Gallery


  A list of choices that usually appears if a control has several choices to choose from.

  Example of this is Font Color then choose a color
• Name Bar


  It indicates the location of the active cell, which is the selected cell.

  It also shows the name assigned to a cell or range of cells
• Parts of the Name Bar

  • Active Cell
  • Active Cell Indicator
• Active Cell


  It has black border indicating that data are ready for entry
• Active Cell Indicator


  This is the dark outline surrounding the active cell.
• Formula Bar

  • It is located just below the Ribbon.
  • It display the data or formulas you type in a cell.
  • This is also used to enter and modify data entry.
• Columns

  • These are vertical blocks of cells which can be identified by alphabetical letters.
  • Columns are labeled from A to XFD, a total of 16,384 columns per worksheet
  • Clicking the column letter will select the entire column
• Rows

  • These are horizontal blocks of cells running across the entire width of the spreadsheet.
  • Rows are sequentially numbered from the top, from 1 to 1,048,576
  • Clicking the row number will select the entire row of cells.
• Cell

  • An individual cell lies at the intersection between a row and a column.
  • A rectangular highlight specifies the on-screen location of an active cell.
• Cell reference or Cell address.


  A combinations of both a column letter and row number
• Sheet Tabs


  Located at the bottom part that allows the user to view a specific sheet.
• Status Bar

  • It is a rectangular bar found on a lower part of the screen.
  • It provides information related to what you are doing.
  • On its right is the Views Toolbar
  • Zoom Control is also located just beside the Views Toolbar
• Views Toolbar


  allows you to switch between available views depending on your workbook
• Zoom Control


  is also located just beside the Views Toolbar, which is used to increase or decrease the viewing size of the work area