Title Bar is the bar holding title of the excel file. But apart from showing title, it also contains many other important functionalities. so let's get familiar with Title Bar in this blog post.
Title Bar is divided in 03 parts:1. Quick Access Toolbar2. File Name
3. Minimize, Maximize/Restore, Close buttons
The commands which we are using frequently can be added to Quick Access Toolbar. Following steps will help you to add desired commands here. 1. Right click on the desired command. (In below screenshot we have selected “Format Painter” as a desired command)
The commands which we are using frequently can be added to Quick Access Toolbar. Following steps will help you to add desired commands here.
1. Right click on the desired command. (In below screenshot we have selected “Format Painter” as a desired command)
2. Select option “Add to Quick Access Toolbar”.
5. Now, you will see "Format Painter" command is removed from Quick Access Toolbar.
It shows the file name which we have given to our excel file. In below screenshot, “Title Bar” is the name of excel file and “- Excel” indicates that this is excel file.
These buttons are found on right side of the Title Bar.
1. Minimize: This button is similar in look like minus sign. If we click on this button excel window will move to the Taskbar (Taskbar is located at the bottom of the screen).
2. Maximize/Restore: If we click on this, then the excel window will fit to the full screen. If we click this button when excel window is already fit to full screen, then excel window will appear in smaller size which allows us to resize the window.
3. Close: If we want to close excel file then click on this button.
This was all about “Title Bar”. In next blog post we will see details about “Ribbons”. Stay tuned!!!
Lesson 1: Getting Familiar with Microsoft Excel
This course teaches Microsoft Excel basics. Although knowledge of how to navigate in a Windows environment is helpful, this course was created for the computer novice. To begin, open Microsoft Excel. The screen shown here will appear.
The Title Bar
This lesson will familiarize you with the Microsoft Excel screen. We will start with the Title bar, which is located at the very top of the screen. On the Title bar, Microsoft Excel displays the name of the workbook you are currently using. At the top of your screen, you should see "Microsoft Excel - Book1" or a similar name.
The Menu Bar
The Menu bar is directly below the Title bar and displays the menu. The menu begins with the word File and continues with the following: Edit, View, Insert, Format, Tools, Data, Window, and Help. You use the menu to give instructions to the software. Point with your mouse to a menu option and click the left mouse button. A drop-down menu will appear. You can now use the left and right arrow keys on your keyboard to move left and right across the Menu bar options. You can use the up and down arrow keys to move up and down the drop-down menu. To select an option, highlight the item on the drop-down menu and press Enter. An ellipse after a menu item signifies additional options; if you select that option, a dialog box will appear.
Do the following exercise, which demonstrates using the Microsoft Excel menu.
The Standard Toolbar
The Formatting Toolbar
Toolbars provide shortcuts to menu commands. Toolbars are generally located just below the Menu bar. Before proceeding with the lesson, make sure the toolbars we will use -- Standard and Formatting -- are available. Follow the steps outlined here:
Microsoft Excel consists of worksheets. Each worksheet contains columns and rows. The columns are lettered A to IV; the rows are numbered 1 to 65536. The combination of column and row coordinates make up a cell address. For example, the cell located in the upper left corner of the worksheet is cell A1, meaning column A, row 1. Cell E10 is located under column E on row 10. You enter your data into the cells on the worksheet.
The Formula Bar
If the Formula bar is turned on, the cell address displays on the left side of the Formula bar. Cell entries display on the right side of the Formula bar. Before proceeding, make sure the Formula bar is turned on.
If the Status bar is turned on, it appears at the very bottom of the screen. Before proceeding, make sure the Status bar is turned on.
The Num Lock key is a toggle key. Pressing it turns the numeric keypad on and off. You can use the numeric keypad to enter numbers as if you were using a calculator. The letters "NUM" on the Status bar in the lower right corner of the screen indicate that the numeric keypad is on.
Make sure the Scroll Lock and End indicators are off and complete the following exercises.
The Down Arrow Key
You can use the down arrow key to move downward on the screen one cell at a time.
You can use the Up Arrow key to move upward on the screen one cell at a time.
You can use the right and left arrow keys to move right or left one cell at a time.
The Page Up and Page Down keys move the cursor up and down one page at a time.
The Status Bar
The End key, used in conjunction with the arrow keys, causes the cursor to move to the far end of the spreadsheet in the direction of the arrow.
The Home Key
The Home key, used in conjunction with the End key, moves you to cell A1 -- or to the beginning of the data area if you have entered data.
The Status Bar
Scroll Lock moves the window, but not the cell pointer.
If you wish to perform a function on a group of cells, you must first select those cells by highlighting them. To highlight cells A1 to E1:
You can also highlight an area by holding down the left mouse button and dragging the mouse over the area. In addition, you can select noncontiguous areas of the worksheet by doing the following:
This is the end of Lesson One. Close Microsoft Excel.