MS EXCEL

• An excel file is actually a workbook or a collection of electronic spreadsheets
• spreadsheets in excel is called worksheets
• basic parts of ms excel

  • title bar
  • menu bar
  • ribbon
  • formula bar
  • name box
  • cell
  • rows
  • columns
  • worksheet tab
  • status bar
• title bar - displays the file name of current workbook
• menu bar - shows menu for different task
• ribbon - holds command buttons that is used to modify, edit and activates commands and task
• formula bar - shows the content of active cell
• name box - holds the cell reference of active or selected cell
• cell - intersection of rows and columns
• rows - horizontal line across the worksheet
• columns - vertical lines along the worksheet
• worksheet tab - located at the bottom of the worksheet, it is used to switch between worksheets
• status bar - shows information about the content of workbook like functions, viewing preference, and zoom level
• workbook - is 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 cells (box), with black border
• border - bounding lines between cells
• hyperlink - words or graphics that lets you jump or move to another location within your workbook or file on your computer
• formula - is an equation that performs mathematical operations to solve a problem
• function - is a pre-defined formula that automatically computes or analyze data
• data - is a collection of facts and information
• by default, a workbook initially contains three worksheets
• each worksheet consists of a grid 256 columns wide and 65,536 rows long
• each labeled at the top section with letters from A to IV
• there are 16,777,126 cells in a single worksheet
• sheets - pages in workbook
• default row height - 15.00
• default column width - 8.43