Multiple Choice
Chloe is creating an Excel spreadsheet using a number of formulas to help make some business decisions regarding her company's customers. Please refer to the figure above as you answer the questions below.
-The CEO of Chloe's company reviews the chart and hands her this formula: AND(C5,NOT(OR(C5:E5) ) ) . The formula will be entered for Aster Construction, and then copied to the remaining rows. Which companies, if any, will return a TRUE value as a result of this formula?
A) Aster Construction
B) Ember Trading Company
C) Belami Homes
D) Davis & Sons
Correct Answer:
Verified
Correct Answer:
Verified
Q111: =OR(FALSE,TRUE,TRUE) results in the final value of
Q112: Excel provides _ tools, which are tools
Q113: The _ of the NOT function is
Q114: One approach to determining if none of
Q115: Identify the letter of the choice that
Q117: In the formula =IF(F9>0,G$2,IF(E9>0,G$3,IF(D9>0,G$4,0))), Excel will evaluate
Q118: Use the _ button to launch the
Q119: You can use the _ logical functions
Q120: Briefly describe each of the arguments in
Q121: In cases where you want to test