Identify the choice that best completes the statement or answers the question. W
ID: 3828375 • Letter: I
Question
Identify the choice that best completes the statement or answers the question. When you set up a work you should use cell references in formulas whenever possible, rather than values. logical constant consistent calculated Which of the following formulas contains an absolute cell reference? =$B4 =B$4 =$B$4 =B$4 =B4 The function is useful when you want to assign a value to a cell based on a logical test. IF NOW AND OR A(n) IF function is one in which the action to be taken for the true or false function included other nested duplicate Indicate whether the statement is true or false. The syntax of the IF function is IF(logical res), value if false, value if true). You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow. Decision Support Systems (DSS) are computer programs use to help managers solve complex business problems. A DSS program is actually a model representing a quantitative business problem. The Excel spreadsheet program is not useful for a business's DSS needs. The Excel tool called Solver can be used to compute answers to optimization problems.Explanation / Answer
1. When you set up a worksheet, you should use cell references in formulas whenever
possible, rather than calculated values.
This is because, a formula will keep the result values consistent with the related
fields, and they need not be modified manually by the user every time.
So, the answer is: d. calculated.
2. Which of the following formula contains an absolute cell reference.
c =$B$4 is the formula containing absolute cell reference.
3. The IF function is useful when you want to assign a value to a cell based on a logical
test.
IF will take a condition, and will evaluate to decide on.
So, the answer is: a. IF.
4. A nested IF function is one in which the action to be taken for the true or false
case includes yet another IF function.
so, the answer is: c. nested.