Learn MS Excel In English

MS Excel in English

What is Excel in English

Microsoft Excel This is an electronic spreadsheet that is used to arrange data and calculate clickable in rows and columns. You can easily do things like salary sheets, mark sheets, and quotations.

The file in Excel is called Workbook and in a workbook, there are 3 sheets by default, which you can add or delete. An Excel 2010 sheet has 1,048,576 rows and 16,384 columns, which is 1500% more crystalline than Excel 2003 and 6,300% more columns.

Getting Started MS Excel 2010:

To start Excel 2010, click on the Excel 2010 icon of the desktop or go to Start -All Programs - Microsoft Office - Microsoft Excel 2010



The Excel 2010 window looks like this-

Learn MS Excel

MS Excel 2010 Element:

1) Title Bar:

It is located at the top of the Excel window. It displays the name of the workbook you are currently working on. On the right side of the title bar, there are buttons for Minimize, Maximize / Restore and Close. And there's a quick access toolbar in the left side.

2) Ribbon:

Ribbons have come in the earlier version of the menus and toolbars. It has tabs to browse specific tasks related commands. Next, to this, tabs are divided into groups.

We can also hydrate this ribbon, right click anywhere on this ribbon, right click on the Minimize the Ribbon button, or click on the Ride Side Minimize the Ribbon (Ctrl + F1) button. When you hid the ribbon, you get more space to work. Click the Expand the Ribbon (Ctrl + F1) button to unhide the ribbon again.

Ribbon Contains Three Main Parts -

i) Tabs - These tasks are oriented and are located at the top of the ribbon.

ii) Groups- Each tab is further divided into all Tasks. For example, the Home tab is divided into Clipboard, Font, Paragraph, Styles, and Editing Group. Each group has a small arrow on the right side, which is called Dialog Box Launcher. Additional options are available upon clicking on it.

iii) Command Buttons - These buttons are relative to each group. For example, Font Group includes the Bold, Italic, Underline, etc. command buttons.



Tabs That Appear Only When You Need Them

In addition to the above tabs, there are other types of tabs here too. But they appear when you are doing tasks related to them.

Contextual Tools: When you are working on an object and when you select that object, you will see this tab.

e.g. -

Insert an image in Excel.

When you select the image, you can see the Format Tab on the right side of the Ribbon.

Here are the commands to work on the selected image.

3) File Button:

This button is in the left corner above the Excel window. This button has a command button like New, Open, Save, Save As, Print and Close.

 

4) Quick Access Toolbar:

In the right side of the Office Buttons, there is a Quick Access Toolbar, which contains buttons for the items that are always used. E.g., Save, and Undo or Redo buttons. To add more buttons to this toolbar, click on its small size of the ride side.

5) The Status Bar:

The status bar is located at the bottom of the window and has the current page number, section, number of words in the documents, etc. By right clicking on this bar, you can select an error option.

Learn MS Excel 

6) Name Box:

The cell which is active in Excel means the number of the cell that we clicked, the number of that cell is displayed here. This box is on the left side of the formula bar.

7) Formula Bar:

You can see the formula typed in a cell here, whereas its ancestor looks in the cell.

Excel Formulas, which you should definitely know about

8) The Status Bar:

The status bar is located at the bottom of the window and has the current page number, Caps Lock, Num Lock, etc. By right clicking, on this time you can select other options.



Learn MS Excel

9) Zoom Slider:

It has a Zoom slider on the status bar in the right corner of the window. Click on the Plus or Minus button to view the worksheet's different zoom passages.

10) View Buttons:

To change the layout of the workbook in the left side of the Zoom Slider, here is the option of Print Layout, Full Screen, Web Layout, Outline or Draft.