Computer Science, asked by Chandubisht29, 1 month ago

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?​

Answers

Answered by gouravgupta65
4

Answer:

1) Select one or more cells

  • Click on a cell to select it. Or use the keyboard to navigate to it and select it.
  • To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. ...
  • To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.

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 Alt+H > O > R, and type the new name.

4) Sorting is any process of arranging items systematically, and has two common, yet distinct meanings: ordering: arranging items in a sequence ordered by some criterion; categorizing: grouping items with similar properties

Hope this help you

Mark me brainliest

Similar questions