IF, Date & LookUp Functions

What function should a sales manager use to indicate whether a salesperson met the goal of $6,000 sales this month? 

• Count
• CountA
• Fill Series
• If

Which function can an accounting department use in Cell A2 that will result in the current date? 

• Count
• CountA
• Days360
• Now

Which function can a credit card company use to determine the time that has elapsed since a customer's payment was received? 

• Count
• CountA
• Days360
• Now

Ernie uses a spreadsheet to maintain inventory at his store and wants to use a formula that will automatically reorder items when they reach a certain quantity. Which function should he use? 

• If
• LookUp
• Max
• Min

What function will display the word "Yes" when the value in Cell A1 is greater than the value in Cell B1 and "No" when otherwise? 

• If
• LookUp
• Max
• Min

The number of hours worked is recorded in Cell D7. Hourly rate is recorded in Cell E7. Overtime hours occur anytime the number of hours worked is greater than 40. Which formula correctly determines how many (if any) overtime hours have occurred? 

• =IF(D7<40),1.5*E7
• =IF(D7>40,D7-40)
• =MAX(D1:D7)*1.5
• =OVERTIME(D7*E7)

What function will produce results that indicate whether a student has passed or failed a course by entering the text "Pass" or "Fail"? 

• Count
• CountA
• If
• Sum

What function should Ester use to calculate the length of time that will elapse between now and when her car is paid in full? 

• Count
• Days360
• If
• LookUp

Which formula will determine the amount of overtime hours worked if regular hours = 40 and the number of hours worked is in D7? 

• =IF(D7<40,D7-40,0)
• =IF(D7=40,D7-40,0)
• =IF(D7>=40,D7-40,0)
• =IF(D7>40,D7-40,0)

Which function ca a credit card company use to determine the time that has elapsed since a customer's payment was received?

• Days360
• Count
• NOW
• CountA