Parts of microsoft excel 2010 environment

As mentioned, each workbook defaults to three worksheets. These worksheets are represented by tabs—named Sheet1, Sheet2 and Sheet3—that appear at the bottom of the Excel window. By the end of this lesson, you should be able to: Identify the parts of the Excel window Understand the differences between a workbook and a worksheet Understand a cell and its importance to Excel Move around a workbook. Workbook Also called a spreadsheet, the workbook is a unique file created by Excel XP.

Title bar The title bar displays both the name of the application and the name of the spreadsheet. Menu bar The menu bar displays all of the menus available for use in Excel XP.

Toolbar Some commands in the menus have pictures or icons associated with them. Column headings Each Excel spreadsheet contains columns. Row headings Each spreadsheet contains 65, rows. Each row is named by a number. Name box This shows the address of the current selection or active cell. Formula bar The formula bar isplays information entered—or being entered as you type—in the current or active cell.

Cell A cell is an intersection of a column and row. Navigation buttons and sheet tabs Navigation buttons allow you to move to another worksheet in an Excel workbook. Workbooks and worksheets A workbook automatically shows in the workspace when you open Microsoft Excel XP. Important terms A workbook is made up of three worksheets. The worksheets are labeled Sheet1, Sheet2 , and Sheet3. Each Excel worksheet is made up of columns and rows.

In order to access a worksheet , click the tab that says Sheet. The cell An Excel worksheet is made up of columns and rows. Important terms Each cell has a unique cell address composed of a cell's column and row. The active cell is the cell that receives the data or command you give it. A darkened border, called the cell pointer , identifies it.

Moving around the worksheet You can move around the spreadsheet in several ways. Microsoft Excel. Study now. See answer 1.

Best Answer. Environment for Microsoft Excel includes the following: Microsoft Office Excel various version available with the most current one being Microsoft Excel This is only available as part of Microsoft Office SharePoint Server as opposed to Microsoft SharePoint Services which is a free component available with Microsoft Windows Server onwards It is used to distribute Excel spreadsheets.

One has the ability to allow for only specific cells to be edited by the user and could be used in, for example, a budgeting process. Study guides. Microsoft Excel 20 cards. How much can you sell a mirraco icon option for. Road wheel torque settings for peugeot 1. What kind of data do you write on a data table. What tab or dialog box do you use to organize your sources. Q: What are the parts of Microsoft Excel environment?

Write your answer Related questions. What are the part of Microsoft Excel environment then give its function? Can a person complete calculations in Microsoft Excel ? What are the different parts of Microsoft Excel ? Who are the creators of Microsoft Excel? How do you launch Microsoft Excel? Are there any Games in Microsoft Excel ? What are the parts and functions of Microsoft Word environment?

Label the parts of Microsoft Word environment? What is the meaning of Microsoft Excel environment? Where can you find a labeled diagram of Microsoft Excel on the Internet? Is Microsoft Excel is a software? Microsoft Excel is an example of a? Does the iPad have Microsoft Excel on it? Quick Access Toolbar — Collection of buttons that provide one click access to commonly used commands such as Save, Undo or Redo.

You can also customize this according to your preference, we have instruction how to customize here. Ribbon — The main set of commands and controls organized task in Tabs and groups, you can also customize the ribbon according to your preference, we got it covered in this instruction.

Column Headings — The letters that appear along the top of the worksheet to identify the different columns in the worksheet. Worksheet Window — A window that displays an Excel worksheet, basically this is where you work all the tasks. Vertical Scroll Bar — Scroll bar to use when you want to scroll vertically through the worksheet window.

Horizontal Scroll Bar — Scroll bar to use when you want to scroll horizontally through the worksheet window. Zoom Controls — Used for magnifying and shrinking of the active worksheet. View Shortcuts — Buttons used to change how the worksheet content is displayed. Sheet Tabs — Tabs the display the name of the worksheet in the workbook, by default its name sheet 1, sheet 2, etc.