Chloe Is Creating an Excel Spreadsheet Using a Number of Formulas

question 140

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.
-Chloe also wants to know if total purchases ever fall below $150,000. The current value is $162,000. She writes the formula ____.

• A) =SUM(B5:B9)<150
• B) =AND(B5:B9)<150
• C) =SUM(B5:B9)<>150
• D) =AND(B5:B9)<=150

---

Definitions:

FERPA

The Family Educational Rights and Privacy Act, a federal law that protects the privacy of student education records.

School Records

Official documents, reports, and files pertaining to the administration, students, faculty, and activities of an educational institution.

Educational Records

Official documents and data pertaining to a student's educational history and achievements, kept by educational institutions.

Test Records

Documentation of the performance and results of individuals on assessments or evaluations.