In this lesson, we will explore the basic parts of Microsoft Excel Window. Below is a screenshot of the startup window of Excel application. In this window, you can see a simple layout and icons of different commands of excel 2019 window.
Basic Parts of Microsoft Excel Window
|1||Quick Access Toolbar||10||Scroll Bars|
|2||File Tab||11||Spreadsheet Area|
|3||Title Bar||12||Leaf Bar|
|4||Control Buttons||13||Column Bar|
|5||Menu Bar||14||Row Bar|
|7||Dialog Box Launcher||16||Status Bar|
|8||Name Box||17||View Buttons|
|9||Formula Bar||18||Zoom Control|
Quick Access Toolbar
You will see this toolbar on the left-upper corner of the screen. Its purpose is to display the most frequently used commands of the Excel. You can customize this toolbar based on your choice commands.
In Excel 2007, it was an “Office” button. This menu do file related operation, i.e. create new excel documents, open an existing file, save, save as, print file, etc.
The header or title bar of the spreadsheet located at the top of the window. It presents the name of the active document.
They are those symbols in the upper-right of the window that allows you to modify the labels, minimize, maximize, share and close the sheet.
Under the diskette or save icon or the Excel icon (this will depend on the version of the program); labels or bars that allow modifying the sheet are displayed. These are the menu bar, and consist of a File, Insert, Page Layout, Formulas, Data, Review, View, Help, and a Search Bar with a light bulb icon. These menus have subcategories that simplify the distribution of information and analysis of calculations.
There are a series of elements that are part of each menu bar. On the selection of any menu, a series of command options/icons will display on a ribbon. For example, if you press the “Home” tab, you will see cut, copy, paste, bold, italic, underline, and etc commands. Similarly, if you click on the “Insert” tab, you will see tables, illustrations, additional, recommended graphics, graphics, maps, among others. On the other hand, if we press the option “Formulas”. Insert functions, auto sum, recently used, finances, logic, text, date and time, etc.
Toolbar/Ribbon is a group of organized commands in three sections.
- Tabs: They are the top section of the Ribbon and contain groups of related commands. Home, Insert, Page Layout, Formula, Data, etc, are examples of ribbon tabs.
- Groups: They organize related commands; the name of each group appears below the Ribbon. For example, a group of commands related to fonts or group of commands related to alignment, etc.
- Commands: They appear within each group as mentioned above.
Dialog Box Launcher
This is a very small down arrow located in the lower-right corner of a command group on the Ribbon. By clicking this arrow explore more options about the concerned group.
Show the location of the active cell, row or column. You can make more than one selection.
It is a bar that allows you to observe, insert or edit the information/formula entered in the active cell.
Those are the tools that allow you to mobilize both the vertical and horizontal view of the document. They can be activated by clicking on the internal bar of your platform, or on the arrows you have on the sides. In addition to that, you can use the mouse wheel to automatically scroll up or down; or use the directional keys.
It is the working area where you enter your data. It constitutes the entire spreadsheet with its rows, cells, columns and built-in information. By means of shortcuts, we can carry out the activities of the toolbar or formulas of arithmetic operations (add, subtract, multiply, etc.). The blinking vertical bar called “cursor” is the insertion point. It indicates the insertion location of the typing.
At the bottom, a text that says sheet1 is displayed. This sheet bar explains the spreadsheet that is currently being worked on. Through this, we can alternate several sheets at our convenience or add a new one.
Columns are a series of boxes vertically organized in the entire sheet. It columns bar is located below the formula bar. The columns are listed with letters of the alphabet. Start with the letter A to Z, and then after Z, it will continue as AA, AB and so on. The maximum limit of columns is 16,384.
It is that left part of the sheet where a sequence of numbers is expressed. Start with number one (1) and as we move the cursor down, more rows will be added. The maximum number of rows goes to 1,048,576.
Cells are those parallelepipeds that divide the spreadsheet into several segments that allow rows to be separated from columns. The first cell of a spreadsheet is represented by the initial letter of the alphabet and the number one (A1).
This bar located at the bottom of the window which shows very important information. It also shows when something is wrong, or the document is ready to be delivered or printed.
This displays quick calculation of the selected digits, like sum, average, count, maximum, minimum, and etc.
You can configure the status bar by right-clicking on the status bar. You can insert or remove any command from the provided list.
It is a group of three buttons arranged at the left of the Zoom control, close the right-bottom of the screen. Through this, you can see three different types of excel’s sheet views.
- Normal view: This displays the Excel page in normal view.
- Page Layout view: This displays the exact view of Excel’s page as they will be printed.
- Page Break view: This shows page break preview before printing.
Zoom control is located at the lower-right area of the window. It allows you to ZOOM-IN or ZOOM-OUT a particular area of the spreadsheet. It is represented by magnifying icons with the symbols of maximizing (+) or minimizing (-). In the most modern versions, it consists of a segment with the icons of more, less and an element that separates both options; which allows you to manipulate them by clicking on any of these.
On the other hand, it also explains how many times the document has been moved away or approached in percentages (%). In the version of Microsoft Excel 2019, it allows you to zoom out by 10% and zoom up to 400%.