Which of the following is TRUE about hard-coded values?
A) In the formula =J5*12 the 12 is a hard-coded value.
B) A formula such as =P1*Q2 contains a hard-coded value.
C) Hard-coding is recommended when you have a value that may change.
D) Hard-coding makes it easier to update data and adapt to change.

Question

Quizplus · Accepted Answer

Hard-coded values are those values that are manually entered directly into a formula or cell, and do not have any relationship with other cell values or formulas. In the formula =J5*12, the number 12 is a hard-coded value.

Answer: C 
 Hard-coding is not recommended when you have a value that may change, as it requires manual updating of the formula or value each time it changes. It's better to reference a cell that contains the value, as this will automatically update the formula or value when the cell changes.

Answer: None 
 Option B is incorrect as it does not contain any hard-coded value. Option D is incorrect as hard-coding does not make it easier to update data and adapt to change, instead it makes the spreadsheet more rigid and difficult to update.

Which of the Following Is TRUE About Hard-Coded Values