38.9k views
1 vote
____________ reference is used when you want to use the same calculation across multiple rows or columns.



2 Answers

7 votes

Answer:

relative cell

Step-by-step explanation:

So, if you want to repeat the same calculation across several columns or rows, you need to use relative cell references. For example, to multiply numbers in column A by 5, you enter this formula in B2: =A2*5. When copied from row 2 to row 3, the formula will change to =A3

User Kapcash
by
4.5k points
8 votes

Answer:

Relative

Step-by-step explanation:

Relative reference is used when you want to use the same calculation across multiple rows or columns.

User Chao Ruan
by
5.2k points