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

Question

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

Quizplus · Accepted Answer

The formula checks if there is a value in cell C5, and if there are no values in cells D5 and E5. Only Aster Construction has a value in C5 and no values in D5 and E5, so it will return a TRUE value. The other companies either have no value in C5 or have values in D5 or E5, so they will not meet the criteria of the formula and return a FALSE value.

Chloe Is Creating an Excel Spreadsheet Using a Number of Formulas