CGS 2518 Chapter 4 questions and
answers graded A+
Evaluate the expression: =OR(FALSE,TRUE,TRUE) - correct answer ✔✔the solution is TRUE.
Evaluate the expression: =AND(3>5,TRUE) - correct answer ✔✔the solution is FALSE.
Evaluate the expression: =NOT(OR(FALSE,FALSE,TRUE)) - correct answer ✔✔the solution is
FALSE.
Evaluate the expression: =AND(A2>6,NOT(FALSE)) where A2 contains the value 25. - correct
answer ✔✔the solution is TRUE.
Describe how you would format a cell so that if its value is less than 20 the cell would be
automatically bolded. - correct answer ✔✔Select the cells to be formatted, go to the
conditional formatting menu and select the highlight cell rules and in that less than or whatever
is needed for comparison is selected, dialog box will open to select a value to be compared and
format options are provided and select the option as custom format, in custom format select
font type as bold.
Write a formula in cell E3 that can be copied down the column to determine (TRUE or FALSE) if
this item is over budget. - correct answer ✔✔E3= IF(D3>C3,TRUE,FALSE), it states that the value
of budget and actual is compared and the result is displayed in the over budget column and is
TRUE.
Write a formula to determine if all of the items are over budget. - correct answer
✔✔=IF(AND(E3:E8),TRUE,FALSE), it displays TRUE if all the values are over budgeted otherwise
it displays FALSE.
answers graded A+
Evaluate the expression: =OR(FALSE,TRUE,TRUE) - correct answer ✔✔the solution is TRUE.
Evaluate the expression: =AND(3>5,TRUE) - correct answer ✔✔the solution is FALSE.
Evaluate the expression: =NOT(OR(FALSE,FALSE,TRUE)) - correct answer ✔✔the solution is
FALSE.
Evaluate the expression: =AND(A2>6,NOT(FALSE)) where A2 contains the value 25. - correct
answer ✔✔the solution is TRUE.
Describe how you would format a cell so that if its value is less than 20 the cell would be
automatically bolded. - correct answer ✔✔Select the cells to be formatted, go to the
conditional formatting menu and select the highlight cell rules and in that less than or whatever
is needed for comparison is selected, dialog box will open to select a value to be compared and
format options are provided and select the option as custom format, in custom format select
font type as bold.
Write a formula in cell E3 that can be copied down the column to determine (TRUE or FALSE) if
this item is over budget. - correct answer ✔✔E3= IF(D3>C3,TRUE,FALSE), it states that the value
of budget and actual is compared and the result is displayed in the over budget column and is
TRUE.
Write a formula to determine if all of the items are over budget. - correct answer
✔✔=IF(AND(E3:E8),TRUE,FALSE), it displays TRUE if all the values are over budgeted otherwise
it displays FALSE.
