Multiple Choice
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.
Correct Answer:

Verified
Correct Answer:
Verified
Q19: The Statistical Function Category is used when
Q20: Match the answers to the examples .Each
Q21: The Show Formulas view is when cells
Q22: To switch to the Show Formulas view,hold
Q23: According to a formula's syntax,match the following
Q25: There are two methods for creating functions:
Q26: Which of the following is the argument
Q27: Names for named ranges must start with
Q28: A(n)_ allows users to refer to a
Q29: The PMT function requires users to enter