d. indicates the desired output value Case-Based Critical Thinking Questions Case 4-1 Purchases Good Credit Rating Customer Good Payment History In Good Standing Currently 000) TRUE TRUE 5 Aster Construction 6 Belami Homes 7 Chrenin Builders 8 Davis & Sons 9 Embar Trading Company 10 Total: TRUE TRUE FALSE TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE FALSE 074 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. Chloe also wants to know if total purchases ever fall below $150,000. The current value is $162,000. She writes the formula . Select one: a. -AND(B5:B9)150 d. =SUM(B5:39)