Question

Write the important features of : 1)Microsoft word , 2)Microsoft excel​

Answer 1

Answer:

$\displaystyle\huge\red{\underline{\underline{IMPORTANCE}}}$

✫MICROSOFT WORD✫

The HOME Tab

And there lies its most significant utility: formatting. You see, this is where Microsoft Word features wins heads over any other Word processing software tool (including Microsoft's own WordPad), as it provides users with a host of complex formatting features all available with a mouse-click or two

✫MICROSOFT EXCEL✫

1. Add Header and Footer

MS Excel allows us to keep the header and footer in our spreadsheet document.

2. Find and Replace Command

MS Excel allows us to find the needed data (text and numbers) in the workbook and also replace the existing data with a new one.

3. Password Protection

It allows the user to protect their workbooks by using a password from unauthorized access to their information.

4. Data Filtering

Filtering is a quick and easy way to find and work with a subset of data in a range. A filtered range displays only the rows that meet the criteria you specify for a column. MS Excel provides two commands for filtering ranges:

• AutoFilter; which includes filter by selection, for simple criteria

• Advanced Filter; for more complex criteria

5. Data Sorting

Data sorting is the process of arranging data in some logical order. MS Excel allows us to sort data either in ascending or descending order.

6. Built-in formulae

MS Excel has got many built-in formulae for sum, average, minimum, etc. We can use those formulae as per our needs.

7. Create different charts (Pivot Table Report)

MS Excel allows us to create different charts such as bar graph, pie- charts, line graphs, etc. This helps us to analyze and compare data very easily.

8. Automatically edits the result

MS Excel automatically edits the result if any changes are made in any of the cells.

9. Formula Auditing

Using formula auditing we can graphically display or trace the relationships between cells and formulas with blue arrows. We can trace the precedents (the cells that provide data to a specific cell) or the dependents (the cells that depend on the value in a specific cell).

Answer 2

Answer:

Useful Features in Microsoft Word

Convert a List to a Table.

Convert a Bulleted List to SmartArt.

Create a Custom Tab.

Quick Selection Methods.

Add Placeholder Text.

Changing Case.

Quick Parts.

Touch/ Mouse Mode in Word 2013.....and

Features of Microsoft Excel........

Add Header and Footer. MS Excel allows us to keep the header and footer in our spreadsheet document.

Find and Replace Command. ...

Password Protection. ...

Data Filtering. ...

Data Sorting. ...

Built-in formulae. ...

Create different charts (Pivot Table Report) ...

Automatically edits the result.