CGS 2518 CHAPTER #4 EXAM
QUESTIONS AND ANSWERS
Write a formula to determine if (TRUE or FALSE) only the required items (R) are within
budget. Note that this formula does not have to work if the optional/required categories
are later modified. - Answer-=IF(B3="R"&D3<C3,TRUE,FALSE)
Are the following two Boolean logical expressions equivalent?
=NOT(OR(E3:E8))
=AND(NOT(E3),NOT(E4),NOT(E5),NOT(E6),NOT(E7),NOT(E8)) - Answer-Yes, they
are the same.
OR evaluates to be TRUE if one of the values is TRUE and NOT evaluates to be TRUE
if the value is false, hence OR evaluates to be TRUE and NOT evaluates to be false.
The AND functions evaluate to be TRUE if all values are TRUE hence NOT is evaluated
for each of the value.
Is the following formula valid? Why or why not?
=NOT(E3:E8) - Answer-No, it is not valid as it denotes the error in the value specified
within the expression.
What value would the following formula return:
=IF(D4<=C4,"within budget","over budget") - Answer-"within budget" because D4 is the
actual and C4 is the budget therefore D4 is actually less than C4 which makes it in
budget.
What value would the following formula return:
=IF(SUM(D7:D8)<100,"go to both",IF(SUM(D7:D8)>200,"go to neither","choose one")) -
Answer-"go to both" because the sum of D7 and D8= 93 therefore it is less than 100.
Write a formula in cell G3 that can be copied down the column to return the following:
-If this item has an actual cost of less than $300, then return the text "Minor Component
Cost"
-If this item has an actual cost of $300 or more, then return the text "Major Component
Cost" - Answer-=IF(D3<300,"Minor Component Cost",IF(D3>300,"Major Component
Cost","Normal"))
Write the formula in cell H3 that was copied down the column to calculate the cost of
this component for a larger scales meeting based on the following:
-If this item is optional as indicated in column B, then the cost will be equal to the
original budgeted amount.
-If this item is required as indicated in column B, then the cost will be two times the
original budgeted amount. - Answer-=IF(B3="R",C3,IF(B3="O",2*C3,"No change"))
QUESTIONS AND ANSWERS
Write a formula to determine if (TRUE or FALSE) only the required items (R) are within
budget. Note that this formula does not have to work if the optional/required categories
are later modified. - Answer-=IF(B3="R"&D3<C3,TRUE,FALSE)
Are the following two Boolean logical expressions equivalent?
=NOT(OR(E3:E8))
=AND(NOT(E3),NOT(E4),NOT(E5),NOT(E6),NOT(E7),NOT(E8)) - Answer-Yes, they
are the same.
OR evaluates to be TRUE if one of the values is TRUE and NOT evaluates to be TRUE
if the value is false, hence OR evaluates to be TRUE and NOT evaluates to be false.
The AND functions evaluate to be TRUE if all values are TRUE hence NOT is evaluated
for each of the value.
Is the following formula valid? Why or why not?
=NOT(E3:E8) - Answer-No, it is not valid as it denotes the error in the value specified
within the expression.
What value would the following formula return:
=IF(D4<=C4,"within budget","over budget") - Answer-"within budget" because D4 is the
actual and C4 is the budget therefore D4 is actually less than C4 which makes it in
budget.
What value would the following formula return:
=IF(SUM(D7:D8)<100,"go to both",IF(SUM(D7:D8)>200,"go to neither","choose one")) -
Answer-"go to both" because the sum of D7 and D8= 93 therefore it is less than 100.
Write a formula in cell G3 that can be copied down the column to return the following:
-If this item has an actual cost of less than $300, then return the text "Minor Component
Cost"
-If this item has an actual cost of $300 or more, then return the text "Major Component
Cost" - Answer-=IF(D3<300,"Minor Component Cost",IF(D3>300,"Major Component
Cost","Normal"))
Write the formula in cell H3 that was copied down the column to calculate the cost of
this component for a larger scales meeting based on the following:
-If this item is optional as indicated in column B, then the cost will be equal to the
original budgeted amount.
-If this item is required as indicated in column B, then the cost will be two times the
original budgeted amount. - Answer-=IF(B3="R",C3,IF(B3="O",2*C3,"No change"))
