Multiple Choice
If purchase quantities of 25 units or higher are found to be large orders, and orders less than 25 are considered to be small, what IF function should be entered in H4 to be copied to H5:H10 to calculate each order's size?
A) =IF(D4=AND=OR=25,"Large","Small")
B) =IF(D4<>25,"Small") =AND(D4=25,"Large")
C) =IF(D4=25,"Large") =OR("Small")
D) =IF(D4>=25,"Large","Small")
Correct Answer:

Verified
Correct Answer:
Verified
Q1: Explain the different Lookup functions in Excel.
Q2: For which of the following columns can
Q3: To find the average of the total
Q4: Use the data given below to
Q6: Use the data given below to
Q7: If cell G7 contains the function ,
Q8: What is the Insert function in Excel?
Q9: If, in the spreadsheet, cells B9 and
Q10: To copy a formula from a single
Q11: For which of the following MATCH functions