Parts Of Ms Excel Environment And Its Definition

broken image
Parts Of Ms Excel Environment And Its Definition

Markup text editor. Working in the Word Environment. As with all programs in the 2007 Microsoft Office release, the most common way to start Word is from the Start menu displayed when you click the Start button at the left end of the Microsoft Windows taskbar. If Word is the first program in the 2007 Office system that you have used, you are in for a surprise! Excel is a workbook with sheets similar to a book. These tabs are used to insert worksheets or charts into a workbook. A name can be applied to each tab indicating what type. So therefore, the basic of the user is to identify first the part of the User Interface.Such as the MS-EXcel UI, so that to familiarized the around of the applications. Lets talk the most basic parts and functions: 1. Control Tool Box - this buttons are used to close windows, restore or maximized, and minimized the application window. Download the latest from Windows, Windows Apps, Office, Xbox, Skype, Windows 10, Lumia phone, Edge & Internet Explorer, Dev Tools & more.

Logic pro 9 manual pdf. The importance of MS Excel can be seen in the different departmental units it is used as follows. Graphing This package plays a very important role in graphing as it has the ability to produce a variety of different charts, which may be used by different departments to represent statistical data in more visual way. Since the formulae.

ACTIVE CELL

  • The active cell is recognized by its black outline. Data is always entered into the active cell. Different cells can be made active by clicking on them with the mouse or by using the arrow keys on the keyboard.

ADD SHEET ICON

  • Adding additional worksheets can be done by clicking on the add sheet icon next to the sheet tab at the bottom of the screen or you can use this keyboard shortcut to add a new worksheet.

CELL

  • Cells are the rectangular boxes located in central area of a worksheet.
  • Data entered into a worksheet is stored in a cell. Each cell can hold only one piece of data at a time.
  • A cell is the intersection point of a vertical column and a horizontal row.
  • Each cell in the worksheet can be identified by a cell reference, which is a combination of letters and numbers such as A1, F456, or AA34.

FORMULA BAR

  • Located above the worksheet, this area displays the contents of the active cell. The forumula bar can also be used for entering or editing data and formulas.

QUICK ACCESS TOOLBAR

  • This toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display available options.

NAME BOX

  • Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.

COLUMN LETTERS

  • Columns run vertically on a worksheet and each one is identified by a letter in the column header.

RIBBON

Parts of ms excel environment and its definition

Markup text editor. Working in the Word Environment. As with all programs in the 2007 Microsoft Office release, the most common way to start Word is from the Start menu displayed when you click the Start button at the left end of the Microsoft Windows taskbar. If Word is the first program in the 2007 Office system that you have used, you are in for a surprise! Excel is a workbook with sheets similar to a book. These tabs are used to insert worksheets or charts into a workbook. A name can be applied to each tab indicating what type. So therefore, the basic of the user is to identify first the part of the User Interface.Such as the MS-EXcel UI, so that to familiarized the around of the applications. Lets talk the most basic parts and functions: 1. Control Tool Box - this buttons are used to close windows, restore or maximized, and minimized the application window. Download the latest from Windows, Windows Apps, Office, Xbox, Skype, Windows 10, Lumia phone, Edge & Internet Explorer, Dev Tools & more.

Logic pro 9 manual pdf. The importance of MS Excel can be seen in the different departmental units it is used as follows. Graphing This package plays a very important role in graphing as it has the ability to produce a variety of different charts, which may be used by different departments to represent statistical data in more visual way. Since the formulae.

ACTIVE CELL

  • The active cell is recognized by its black outline. Data is always entered into the active cell. Different cells can be made active by clicking on them with the mouse or by using the arrow keys on the keyboard.

ADD SHEET ICON

  • Adding additional worksheets can be done by clicking on the add sheet icon next to the sheet tab at the bottom of the screen or you can use this keyboard shortcut to add a new worksheet.

CELL

  • Cells are the rectangular boxes located in central area of a worksheet.
  • Data entered into a worksheet is stored in a cell. Each cell can hold only one piece of data at a time.
  • A cell is the intersection point of a vertical column and a horizontal row.
  • Each cell in the worksheet can be identified by a cell reference, which is a combination of letters and numbers such as A1, F456, or AA34.

FORMULA BAR

  • Located above the worksheet, this area displays the contents of the active cell. The forumula bar can also be used for entering or editing data and formulas.

QUICK ACCESS TOOLBAR

  • This toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display available options.

NAME BOX

  • Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.

COLUMN LETTERS

  • Columns run vertically on a worksheet and each one is identified by a letter in the column header.

RIBBON

  • The Ribbon is the strip of buttons and icons located above the worksheet. When clicked on, these buttons and icons activate the various features of program. First introduced in Excel 2007, the ribbon replaced the menus and toolbars found in Excel 2003 and earlier versions.

RIBBON TABS

  • Tabs are part of the horizontal ribbon menu that contains links to various features of the program. Each tab – such as Home, Page Layout, and Formulas – contains a number of related features and options that are activated by clicking on the appropriate icon.

Parts Of Ms Excel Environment And Its Definition

THE FILE TAB

  • The File tab was introduced in Excel 2010 replacing the Excel 2007 Office Button, and it works differently than the others tabs.
  • Instead of having its options display on the horizontal ribbon, clicking on the File tab opens a drop down menu on the left side of the screen.
  • This tab also contains items that are mostly related to file and document management – such as opening new or existing worksheet files, saving, and printing.
  • The options item, which is also located on the menu, is used to alter the look of the program as a whole by choosing which screen elements to display, such as scroll bars and gridlines. It also contains options for activating a number of settings – such as automatic recalculation of worksheet files and choosing which languages to use for spell check and grammar.

SHEET TABS

  • By default there is one worksheet in an Excel 2013 file.
  • The tab at the bottom of a worksheet tells you the name of the worksheet – such as Sheet1, Sheet2 etc.
  • Renaming a worksheet or changing the tab color can make it easier to keep track of data in large spreadsheet files.
  • Switching between worksheets can be done by clicking on the tab of the sheet you wish to access or by using this keyboard shortcut to change between worksheets.

ROW NUMBERS

  • Rows run horizontally in a worksheet and are identified by a number in the row header.

ZOOM SLIDER

  • Located in the bottom right corner of the Excel screen, the zoom slider is used to change the magnification of a worksheet by dragging the slider box back and forth or by clicking on the Zoom Out and Zoom In buttons located at either end of the slider.

STATUS BAR

Parts Of Ms Excel Environment And Its Definitions

  • The status bar, which runs horizontally along the bottom of screen, can be customized to display a number of options, most of which give the user information about the current worksheet, data the worksheet contains, and even the user's keyboard – such as whether the Caps Lock, Scroll Lock, and Num Lockkeys are turned on or off.
  • The status bar also contains the zoom slider, discussed below, which allows users to alter the magnification of a worksheet.




broken image