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.
-Another way that Chloe could write the formula that would show if total purchases ever fell below $150,000 would be ____. The current value is $162,000.
Definitions:
Equal Pay Act
A law that requires men and women to be given equal pay for equal work in the same establishment.
Night Shift
A work schedule involving labor during the night hours, typically covering the period from late evening to early morning.
United States Supreme Court
The highest federal court in the U.S., with ultimate judicial authority to interpret and decide questions of federal law, including constitutional issues.
Sexual Harassment
Unwanted or inappropriate sexual advances, requests for sexual favors, and other verbal or physical harassment of a sexual nature in the workplace.
Q19: In the FIND function, _ is the
Q36: The _ gallery in the Insert Shapes
Q44: Not equal to<br>A)=3+5=8<br>B)=100>MAX(5,10,20)<br>C)=B3<C3 where cell B3=5 and
Q44: The TRIM function removes all spaces in
Q44: Julia wants to take a count of
Q63: An Excel chart requires _ numeric data
Q71: Doughnut chart type<br>A)Compares values across categories in
Q85: A function named IFWRONG can be used
Q115: Greater than<br>A)=3+5=8<br>B)=100>MAX(5,10,20)<br>C)=B3<C3 where cell B3=5 and cell
Q136: Relational operators can be used to evaluate