EMTECH 3

• Excel file


  A workbook or a collection of electronic spreadsheets
• Spreadsheets in excel

  Called worksheets
• Basic Parts of MS Excel

  • Quick Access Toolbar
  • Title Bar
  • Menu Bar
  • File Menu
  • Ribbon
  • Formula Bar
  • Address Bar
• Quick Access Toolbar


  • Displays function shortcuts
• Title Bar


  • Displays the file name of current work book
• Menu Bar


  • Shows Menu for different task
• File Menu


  • Shows the menu file
• Ribbon


  • Holds command buttons that is used to modify, edit and activates commands and task
• Formula Bar


  • Shows the content of Active Cell
• Address Bar


  • Holds the cell reference of active or selected cell
• Basic Parts of MS Excel

  • Cell
  • Rows
  • Column
  • Worksheet Tab
  • Status Bar
• Cell


  • Intersection of Rows and Columns, stacked of boxes in the worksheet
• Rows


  • Horizontal line across the worksheet that is referenced by numbers on the right
• Column


  • Vertical lines along the worksheet that is referred by the letters on top of worksheet
• Worksheet Tab


  • Located at the bottom of worksheet, it is used to switch between worksheets
• Status Bar


  • Shows information about the content of workbook like functions, viewing preference, and zoom level
• By default, a workbook initially contains three worksheets
• Worksheet

  • 256 columns wide and 65,536 rows long
• An intersection of a row and column is known as a cell
• There are 16,777,216 cells in a single worksheet
• Workbook


  A file created and stored using spreadsheet application like MS Excel
• Worksheet


  Electronic spreadsheet consist of horizontal and vertical lines that creates box stacked on one another
• Active Cell


  Selected cell/s(box), with black border
• Border


  Bounding lines between cells
• Hyperlink


  Word/s or graphics that lets you jump or move to another location within your workbook or file on your computer
• Formula


  An equation that performs mathematical operations to solve a problem
• Function


  A pre-defined formula that automatically computes or analyze data
• Data


  A collection of facts and information