Question

1) Which of these is an absolute cell reference?

a) A1 + A @ 2
b) $ A $2
c) @ A2 @

2) Which of the following is showing a range of cells?

a) A2 + B3
b) A3 : E3
c) A2 & C2​

Answer 1

Answer:

1. answer is b $ A $ B

2. answer is again b A3: E3

Explanation:

1.

2. The semi colon is used to show a range of cells.

Hope it helps you

Mark me as the brainliest.