Excel Purpose & Interface | Lecture 1 - Part 2

This is Microsoft Learn & Earn Series by Muhammad Nasir. In this Video Lecture  you will be able to learn the following Topics.

1. Excel Software Interface
2. Title Bar in Excel
3. Home Tab Command Groups.
4. Font Command Group in Excel
5. What is Formula Bar in Excel?
6. What is Name Box in Excel?
7. What is Workspace in Excel?
8. Status Bar in Excel (Zoom-in, Zoom-out, Layouts) 

Excel Purpose & Interface

If you find the video helpful, share it with others.. Thank you!

Download Practice File

What is Title Bar in Microsoft Excel ?

The title bar displays both the name of the application and the name of the spreadsheet. It also have Quick Access Tool Bar (QAT), which provide quick options to perform certain tasks such as Saving a file, Undo , Redo etc. On the Right side of the Title Bar, there is a X icon to close the Microsoft Excel Window / Software.

What is the use of font group commands in excel?

The Font group options let you change the text / writing style, size and color of text. Font command group also contains Bold, Italic and Underline options. But one most important options are borders and fill color. Because MS Excel is spreadsheet software, so in order to make data stand out or prominent on the software, Borders and fill color plays a vital role.

What is Formula Bar in Excel with an Example?

The Formula Bar in Excel can be seen directly above the worksheet area. Following are the main functions and purposes of the Formula bar.

• The formula bar could be used to apply formula or enter data into the selected cell(s). 
• Moreover, It can also be used to check whether the cells has a value or the formula.
• If the formula in the cell is being showed in  multiple lines, so, formula bar can expand it us to have a better sight on it.

What is the Name Box in ms Excel explain with example?

The Name Box in Microsoft Excel , refers to an input box directly to the left of the formula bar. It displays the address of the "active cell" on the worksheet. We can use Name Box to assign a name to multiple / range of cells. For example, We can name cells from A1 to A100 (A1:A100) "Ages of Students". So, it becomes easy to use cells ranges in the functions / formulas.

What is the Function of Status bar in excel?

The status bar is a name for the lower edge of the worksheet window, which displays various information about an Excel worksheet. The status bar can be configured to display things like sum, count, and average of the currently selected cells.