Question

1. Write the steps involved in Auto Formatting
2. What are the steps for creating formula using Point and click method
3.How will you edit a formula in MS Excel?
4.Write the steps for filtering numbers and text​

Answer 1

Answer:

Please mark as brainliest.

Step-by-step explanation:

Ans-1

1. Click the File tab.
2. Choose Options. The Word Options dialog box appears.
3. Select Proofing from the left side of the window.
4. Click the button labeled AutoCorrect Options. The AutoCorrect dialog box appears.
5. Click the AutoFormat as You Type tab.

Ans-2

1. To create a simple formula using the point-and-click method:
2. Type the numbers you want to calculate in separate cells (for example, type 128 in cell B2 and 345 in cell B3).
3. Click the cell where the answer will appear (B4, for example).
4. Type the equals sign (=) to let Excel know a formula is being defined.

Ans-3

1. To edit a formula:
2. Select the cell containing the formula you want to edit. ...
3. Click the formula bar to edit the formula. ...
4. A border will appear around any referenced cells. ...
5. When you're finished, press Enter on your keyboard or click the checkmark in the formula bar.

Ans-4

1. Filter a range of data
2. Select any cell within the range.
3. Select Data > Filter.
4. Select the column header arrow .
5. Select Text Filters or Number Filters, and then select a comparison, like Between.
6. Enter the filter criteria and select OK.

Hopes it helps you.