Question

State whether the following statements are true (T) or false (F).
1. Absolute referencing is based on the relative position of the cell in which the
formula is being written
2. The Sort& Filter group of buttons appears on the Data tab.
3. Filtering can be used to rearrange data in a particular sequence.
4. Both cell formats and data values can be used to filter cells.
5. The shortcut key to filter data is Ctrl+Shift+L.​

Answer 1

Answer:

1.T

2.F

3.F

4.T

5.T

answers your question

Answer 2

Answer:

1) False

2) True

3) True

4) False

5) True