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