Question

Answer in detail:

1. How do you select a range?

2. Explain the types of cell references in brief?

3. Write steps to rename a worksheet?

4. What is sorting? What are two types of sorting available in Excel?

5. How do you remove a filter?
tell me the answers ​

Answer 1

1)

Select the first cell in the range using any method, hold down the Shift key and click the last cell in the range, and then release the Shift key.

...

Selecting a contiguous range in Excel.

2)

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

3)

Rename a worksheet

Double-click the sheet tab, and type the new name.

Right-click the sheet tab, click Rename, and type the new name.

Use the keyboard shortcut A

lt+H > O > R, and type the new name.