what can we do in M.S Excel

M.S EXCEL

• Have you heard about Alladin's magic Lamp? Do you want to know about a wonderful package like Alladdin's magic lamp?

• It is the wonderful package in M.S Office that performs different types of calculations, formulae etc.
• Not only calculation,  Excel converts them into wonderful graphs and charts. we will learn about the magic package in this chapter.

what can we do in M.S Excel?

Excel is a wonderful package in M.S Office. The following tasks can be done in M.S Excel.

1. Performing calculations 

       All formula entries begin with an equal sign (=). For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use  — the plus sign (+) to add, the minus sign (-) to subtract, the asterisk (*) to multiply, and the forward slash (/) to divide. Then, press ENTER, and Excel instantly calculates and displays the result of the formula.

 

2. Applying Formula & Functions

        You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Simple formulas always start with an equal sign (=), followed by constants that are numeric values and calculation operators such as plus (+), minus (-), asterisk(*), or forward slash (/) signs.

3. Graphs & Charts 

 

         Select the data for which you want to create a chart. Click INSERT > Recommended Charts. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look.

4. converting Excel sheets into required designs

       After you create an Excel table, you may only want the table style without the table functionality. To stop working with your data in a table without losing any table style formatting that you applied, you can convert the table to a regular range of data on the worksheet.

5. Data Sorting / Filtering

 

          To focus on a specific set of your data, you can filter a range of cells or a table. Click any cell in the range or table. On the HOME tab, click Sort & Filter, and click Filter. Click a drop-down arrow at the top of one of the columns to display its filter options.