M.S. Office, Excel, PowerPoint, Word
36K subscribers
143 photos
44 links
Knowledge Sharing
Download Telegram
Question:-
What is Row and Column?

Answer:-
MS Excel is in tabular format consisting of rows and columns. Row runs horizontally while Column runs vertically. Each row is identified by row number, which runs vertically at the left side of the sheet. Each column is identified by column header, which runs horizontally at the top of the sheet.
Question:-
What is Cell in Excel?

Answer:-
1. A cell is the intersection between a row and a column on a spreadsheet that starts with cell A1. In the following example, a highlighted cell is shown. D8 (column D, row 8) is the highlighted cell that's also known as the cell address and cell reference. Any modifications made while this cell is highlighted will be limited to this cell in the spreadsheet.
M.S. Office, Excel, PowerPoint, Word pinned «Question:- What is Row and Column? Answer:- MS Excel is in tabular format consisting of rows and columns. Row runs horizontally while Column runs vertically. Each row is identified by row number, which runs vertically at the left side of the sheet. Each column is…»
Question:-
What is Formula Bar?

Answer:-
The Formula Bar is where data or formulas you enter into a worksheet appear for the active cell. The Formula Bar can also be used to edit data or formula in the active cell. The active cell displays the results of its formula while we see the formula itself in the Formula Bar.
M.S. Office, Excel, PowerPoint, Word pinned «Question:- What is Formula Bar? Answer:- The Formula Bar is where data or formulas you enter into a worksheet appear for the active cell. The Formula Bar can also be used to edit data or formula in the active cell. The active cell displays the results of…»
Expanding Or Contracting The Formula Bar
The Formula Bar can be expanded either vertically or horizontally depending on your needs.

To expand the Formula Bar horizontally, move the mouse cursor to the area between the Name Box and the the Formula Bar until the cursor turns into a horizontal double ended arrow. Left click and drag to adjust the horizontal size.

To expand the Formula Bar vertically, move the mouse cursor to the bottom of the Formula Bar area until the cursor turns into a vertical double ended arrow. Left click and drag to adjust the horizontal size.

On the right hand side of the Formula Bar there is a expand or contract toggle. Use this to quickly adjust the Formula Bar.
Question:-
How to Hide and Unhide the Formula Bar?

Answer:-
You can hide the Formula Bar entirely by going to the View tab and uncheck the Formula Bar option.
Dear Friends,
Please read the above details and ask your doubts to get the benefit.

Thanks and regards
Good Morning !
Dear Friends,

Please read the above details and ask your doubts to get the benefit.

This group has created with the aim to serve and guide the new comers. So please don't hesitate to ask your doubts. This will help you to get the new thinking to do the working on excel.

Thanks and regards
Entering And Editing Data In The Formula Bar

Enter data into any cell.

Select the cell where you want to enter your data and start typing.

As you type the data notice the data also appear in the Formula Bar.

To accept the data either click the Check Mark or press Enter. To discard the data either click the X or press Esc.

 

The process for entering a formula is the same except all formulas need to start with “=” (without the quotation marks). To edit any data and formula in any cell, select the cell and either click into the Formula Bar or press F2 to enter editing mode.
M.S. Office, Excel, PowerPoint, Word pinned «Entering And Editing Data In The Formula Bar Enter data into any cell. Select the cell where you want to enter your data and start typing. As you type the data notice the data also appear in the Formula Bar. To accept the data either click the Check Mark or…»
Question:-
How to use Zoom control?

Answer:-
In most cases, you can use the minus and plus symbols in the status bar to quickly zoom the document. Use the buttons on the View tab to zoom to a specific percentage and to zoom to a selection.

Option 1:-
1. To quickly zoom the document, use the minus a plus symbols in the status bar.