What is Microsoft Excel?

INTRODUCTION:

Microsoft Excel is a program mostly used for mathematical calculations. Excel has by default three sheets on a single workbook. A workbook is a collection of worksheets. A worksheet is a single sheet or page in excel. Excel sheet is made up of rows and columns. Combination of rows and columns is called a table. It is a easy way to make list and perform mathematical calculations. Excel mostly used in accounting work. 

Microsoft Excel has rows and columns, columns are vertical and rows are horizontal lines. Column headings are alphabet a-z and more, rows headings are indicated by numbers. A cell in Excel is a combination of rows and columns. Microsoft Excel is used for making list of employees, making salary sheet of employees, making tables for recording data in the tabular form.

There are number of manners by which you can get Microsoft Excel. You can get it from an equipment PC shop that likewise sells programming. Microsoft Excel is a piece of the Microsoft Office suite of projects. On the other hand, you can download it from the Microsoft site yet you should purchase the permit key.

How to Start Microsoft Excel? 

Running Excel isn't unique in relation to running some other Windows program. On the off chance that you are running Windows with a GUI like (Windows XP, Vista, and 7) follow the accompanying advances.

1) Click on start menu 

2) Click on all programs 

3) Click on MS office

4) Click on Microsoft Excel 

On the other hand, you can likewise open it from the beginning menu in the event that it has been included there. You can likewise open it from the work area alternate way on the off chance that you have made one.

Microsoft Excel is a subpart of MS Office. As we know excel sheet consists of rows, columns, mathematical functions, formatting tools, charts and graphs and many more features, some of them are given below:

1. Large amount of data can be organized.

2.There are several built-in functions for faster calculations.

3.Data can be automatically updated in Excel.

4.In Excel data can be represented in the form of graph and chart.

5.In Excel data can be sent to or received from other persons via e-mail import/export option.

COMPONENTS OF EXCEL WINDOW:

   1.Title bar: In MS Excel Title bar display the name of the workbook. Title bar also include Quick Access Toolbar and Control buttons.

a.Quick Access Toolbar: Quick Access Toolbar consist some options that can be frequently used. It includes save, undo, redo, print, e-mail etc.

b.Control Buttons: Control buttons means Minimize, Restore and Close button. Minimize button is used for minimize the excel window. Restore button is used to restore or maximize the excel window. Close button is used to close excel window.

   2. Office button: Office button is present on left upper corner of the Excel window. When you will click on this button a drop-down list will be display. Drop-down list consist some options like-New, open, save, save as, print, print preview, prepare, publish and close.

a.New: New option is used to create new workbook in MS Excel.

b.Open: Open option is used to open existing Excel file.

c.Save: Save option is used to save excel file.

d.Save as: Save as option is used to rename excel file.

e.Print: Print option is used to print excel file.

f.Print Preview: This option is used to display the print preview.

g.Close: Close option is used to close MS Excel window.

  3.Ribbon: The Ribbon is a strip in MS Excel that consist seven tabs i.e. Home tab, Insert tab, Page Layout tab, Formula tab, Data tab, Review tab and View tab.

Each tab present in the Ribbon contains several groups and each group in a single tab contains several options for formatting excel file.

a.Home Tab: Home tab contains several groups’ like- Clipboard, font,Alignment, Styles, Number, Cells, and Editing. Each group has different options.

b.Insert Tab: Insert tab contains many groups like- Table, Illustration, Charts, Links, and Text. Each group has many options.

c.Page Layout tab: Page Layout tab contains many groups like- Themes, Page setup, Scale to fit, Sheet options and Arrange.

d.Formula: Formula tab contains many groups like- Function library, Defined names, Formula Auditing and Calculation.

e.Data: Data tab contains many groups’ like- Get External data, Connections, Sort & Filter, Data tools and Outline.

f.Review: Review tab contains several groups like- Proofing, Comments and Changes.

g.View Tab: View tab contains many groups’ like- Workbook views, show/hide, Zoom, Window and Macros.

    4.Formula bar: Formula bar is used to enter the formula in Excel sheet. Formula bar also show the selected text, so the text can be edited in the formula bar.

   5.Scroll bar: In MS Excel there are two scrolls bar i.e. horizontal and vertical scroll bar. Horizontal scroll bar shows the excel sheet width wise. Vertical scroll bar shows the excel sheet vertically or lengthwise.

   6.Active cell address box: As the name indicates that this box shows the address of active cell or it shows the selected cell address.

    7.Work Area: Work Area is called a Workbook in MS Excel. A Workbook is a collection of worksheets stored in a single workbook. Worksheet is a combination of rows and columns. We can say that worksheet is made up of rows and columns. As we know that the columns are vertical and rows are horizontal. Column headings are alphabets i.e. A, B, C…….. and Rows headings are numbers i.e. 1, 2, 3………. .

Intersection of rows and columns is called a Cell or Cell is made up of column and row. A column represents record and a row represents a field in Excel.

Significant Excel alternate ways: 
1. Ctrl+P is used to open the print window.

2. Ctrl+N is used to open new window.

3. Ctrl+S is used to save the Excel file.

4. Ctrl+C is used to copy the text.

5. Ctrl+V is used to paste the copied text.

        Some other links:

• What is MS Word?(How to Start,New document, Save, Open, Close):
• Formatting(Character formatting and Paragraph formatting):
• Column Formatting,Find & Replace,Page- Margin, Orientation,Size & Print:
• Inserting Picture, WordArt, Shapes, Symbols in MS Word:
• Data- Input, Edit, Select and Modifying in MS Excel:
• Inserting Charts, WordArt, Shapes, ClipArt in MS Excel:
• Functions in MS Excel: