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 ____.
Definitions:
Defense of Marriage Act
A federal law enacted in 1996 that defined marriage as the union between one man and one woman, denying federal recognition of same-sex marriages until it was ruled unconstitutional in 2013.
Windsor v. United States
A landmark Supreme Court case that declared Section 3 of the Defense of Marriage Act (DOMA) unconstitutional, advancing the rights of same-sex couples.
Same-Sex Marriage
The legally or socially recognized marriage between two individuals of the same gender.
State-Level
Pertaining to the individual states within a federation, as opposed to the national or federal government, focusing on policies and governance at the state level.
Q5: The values TRUE and FALSE are referred
Q24: Mark writes a formula to look up
Q27: In the FIND function, _ is the
Q45: If a lookup_value is smaller than the
Q82: When working with the RAND and RANDBETWEEN
Q85: A function named IFWRONG can be used
Q96: The PivotTable _ task pane contains a
Q103: Use the Label options on the Chart
Q117: column_num<br>A)#1<br>B)#2<br>C)#3<br>D)#4<br>E)#5
Q143: _ returns the cumulative interest paid on