Question

"In spreadsheet programs, labels and constant values are always copied exactly to the new location; what happens to formulas when they are copied depends on whether they use relative cell referencing or__________

Answer 1

Answer: Absolute cell referencing

Explanation:

 The absolute cell referencing is one of the type of cell reference address that basically contain the dollar sign in the spreadsheet applications. It is one of the important element as it helps in referring the constant values in the spreadsheet programs.

• The absolute cell referencing is copied and also moved from one cell to another in the new location.
• The size and also the shape are also remain constant in the spreadsheet.

According to the given question, the absolute cell referencing is also known as the relative cell referencing as they use the formulas for copied the values in the microsoft office excel for find out the data.

 Therefore, Absolute cell referencing is the correct answer.