MS Excel 2010

MS Excel is a spreadsheet application developed by Microsoft Corporation.

It is commonly used to organize data and perform financial analysis.

Features of MS Excel:

Microsoft Office Button: The Microsoft Office button is located in the upper left corner of the MS-Word window.

Working in Microsoft Excel

 To create a New Blank Workbook:

Steps

1.    Click on the File Menu. Backstage view will appear.

2.    Click on New.

3.    Click on Blank Workbook.

4.    A new Blank Workbook will appear.

 

To Save an Existing Workbook:

Steps

1. Click on the File Menu.

2. Click on the Save option.

3. Click on the Browse Option

4. The Save Dialog Box will appear.

5. In the save dialog box, select file location and type fine name.

6. Click on the Save Button.

 

To Close an Existing Workbook:

Steps

1.    Click on the File Menu. Backstage view will appear.

2.    Click on the Close.

3.    The Workbook will close.

 

To open an Existing Workbook:

Steps

1.    Click on the File Menu. Backstage view will appear.

2.    Click on Open.

3.    Select Computer, then click Browse.

4.    The Open dialog box will appear. Locate and select your Workbook, then click Open.

5.    The Workbook will open.

 

To pin a workbook:

If you frequently work with the same workbook, you can pin it to Backstage view for faster access.

Steps

1.    Click on the File Menu.

2.    Your Recently edited Workbooks will appear.

3.    Hover the mouse over the Workbook you want to pin. A Pushpin Icon will appear next to the Workbook. Click the Pushpin Icon.

 

Working in Microsoft Excel with Keyboard.

How to Start Microsoft Excel from the keyboard?

Steps

1.    Press Windows Logo Key from the keyboard.

2.    Type Excel in the Search Box.

3.    Select Excel and click on the Excel Program.

4.    The Microsoft Excel program will be appeared on the Desktop.

 

Method to Create, Close, Open and Save in Microsoft Excel.

To Create new Microsoft Excel Workbook from the Keyboard.

Shortcut Keys: Press Ctrl + N

 

To Close Microsoft Excel Workbook from the Keyboard.

Shortcut Keys: Press Ctrl + W

 

To Open Microsoft Excel Workbook from the Keyboard.

Shortcut Keys: Press Ctrl + O

 

To Save Microsoft Excel Existing Workbook from the Keyboard.

Shortcut Keys: Press Ctrl + S

Some Questions and Answers about Excel

What is cell in Excel?

A cell is a rectangular area formed by the intersection of a column and a row.

What is range of cells in Excel?

A cell range in Excel is a collection of chosen cells.

What is a column in Excel?

A column arranges data vertically from top to bottom.

What is a row in Excel?

A row arranges data horizontally from left to right.

What is Name box in Excel?

The box located to the left side of the formula bar which addresses the selected cell or group of cells in the spreadsheet is called Name box.

What is a formula bar in Excel?

A formula bar is a special toolbar at the top of the Excel worksheet window, labeled with function symbol (fx).