MICROSOFT EXCEL

• Microsoft Excel is a software application designed for creating tables to input and organize data. It provides a user-friendly way to analyze and work with data.
• Quick Access Toolbar This toolbar is located in the upper left corner of the screen. Its objective is to show the most frequently used Excel commands.
• File Tab Excel 2007's Office button has been replaced by the File tab. We can click it to check the Backstage view, where we can open or save files, create new sheets, print sheets, and perform other file-related operations.
• Title Bar of the spreadsheet is at the top of the window. It displays the active document's name.
• Control Buttons are the symbols that are present in the upper-right side of the window, enabling us to change the labels, minimize, maximize, share, and close the sheet.
• Menu Bar Under the diskette or save icon or the excel icon (this will depend on the version of the program), labels or bars which enable changing the sheet which is shown
• Ribbon/Toolbar Each menu bar contains several different elements. On the selection of the menu, a sequence of command options/icons will show on a ribbon. For example, if we select the "Home" tab, we will see cut, copy, paste, bold, italic, underline, and more commands.
• Ribbon/Toolbar is a set of commands organized into three sections.
• Tabs They are the Ribbon's top part, and they include groups of related commands. Ribbon tabs include Home, Insert, Page Layout, Formula, Data.
• Groups They organize related commands; the name of each group is displayed below the Ribbon. For example, a set of commands related to fonts or a group of commands related to alignment, etc.
• Commands They appear within each group, as previously stated.
• Dialog Box Launcher is a very little down arrow that is present in the lower-right corner of a command group on the Ribbon. By clicking on this arrow, we can explore more options related to the concerned group.
• Name box Show the location of the active cell, row, or column. We have the option of selecting multiple options.
• Formula Bar permits us to observe, insert or edit the information/formula entered in the active cell.
• Scrollbars are the tools that enable us to move the document's vertical and horizontal views.
• Spreadsheet Area It is the place where we enter our data.
• Leaf bar is present at the bottom of the spreadsheet, which says sheet1 is shown.
• Columns Bar are a vertically ordered series of boxes across the full sheet.
• The row bar is the left part of the sheet where a sequence of numbers is expressed.
• Cells are those parallelepipeds that divide the spreadsheet into many pieces, separating rows and columns.
• The status bar is present at the bottom of the window that displays critical information.
• Normal view displays the Excel page in normal view.
• View buttons are a set of three buttons arranged at the left of the Zoom control, close the screen's rightbottom corner.
• The Page Layout view shows the precise layout of an Excel page it will be printed.
• This displays page break preview before printing.
• The zoom control is present at the lower-right side of the window. It enables us to ZOOM-IN or ZOOMOUT a specific area of the spreadsheet.
• Create a workbook

  1. Open Excel.

  2. Select Blank workbook or press Ctrl+N.

  3. Start typing.
• Create a workbook from a template

  1. Select File > New.

  2. Double-click a template.

  3. Click and start typing.
• To open MS Excel on your computer, follow the steps given below:

  1. Click on Start.
  2. Then All Programs.
  3. Next step is to click on MS Office.
  4. Then finally, choose the MS-Excel option.
• How to Save the Workbook

  1. Click on the Office Button or the File tab.

  2. Click on Save As option.

  3. Write the desired name of your file.

  4. Click OK.