Parts of Excel for Windows in Study

By Rebecca Johnson, Excel Assignment and Excel-Easy Contributor

Microsoft Excel is a spreadsheet program, which runs in the Windows environment. Spreadsheets can be used for organizing information and performing calculations. You may also use Excel spreadsheets to maintain small databases. The Excel screen can be broken down into five main parts: the Quick Access Toolbar, the Office Button, the Ribbon Bar, the Name Box and the Formula Bar, and the Worksheet itself.

Quick Access Toolbar.

The Quick Access Toolbar is a customizable toolbar that allows a user to easily access frequently used commands. The toolbar can be placed either above or below the Ribbon.

To add a button to the Quick Access Toolbar, click the “Customize” button. Select the item to add. Once clicked, it will appear in the toolbar. If the item is not in the list, click “More Commands” and select the item.

Office Button

The Office button is located in the upper left hand corner of the Excel screen. Commands that were located in the File menu of prior versions of Excel are here. Along with common tasks like New, Open and Print, the Office Button also contains recent documents, encrypting, publishing to a blog.

The Ribbon Bar

As a part of the Microsoft Office Fluent user interface, the Ribbon Bar was created to replace menus and toolbars from the previous version of Excel. The ribbon is designed to help users find tools quickly and easily by grouping the items together by tasks. Many items will appear on the ribbon based on the task the user is performing.

The Name Box and the Formula Bar

The Name Box shows what cell is currently selected. It is important for the user to know the selected cell for creating formulas.

The Formula Bar displays the contents of the selected cell. The cell itself may show a number or text but the Formula Bar shows how the value was derived. For example, the cell displays 15. By viewing the Formula Bar, the user sees the formula A2+B2.

Worksheet

The Worksheet is the heart and soul of Excel and is composed of many parts.

A. Sheet Selector–selects the entire worksheet when clicked.

B. Column Headings–are letters identifying the column; they represent the first half of the cell address and there can be 16,384 columns.

C. Row Headings –numbers identifying the row; they represent the second half of the cell address and there can be 1,048,576 rows.

D. Worksheet Tabs–appear at the bottom of the worksheet. New workbooks have three worksheets by default. Additional sheets can be added, extra sheets removed, and the sheets named more appropriately. The number of sheets available in Excel is limited by memory available.

Leave a Reply

Your email address will not be published. Required fields are marked *