Use the data given below to answer the following questions) .
Below is a spreadsheet of purchase orders for a computer hardware retailer.
-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) =IFD4=AND=OR=25,"Large","Small")
B) =IFD4<>25,"Small") =ANDD4=25,"Large")
C) =IFD4=25,"Large") =OR"Small")
D) =IFD4>=25,"Large","Small")
Correct Answer:
Verified
Q1: What is a database?
A) a structured collection
Q2: is a logical function that returns one
Q3: The sort buttons in Excel can be
Q4: Use the data given below to
Q6: Use the data given below to
Q7: Give the logical function for the following:
Q8: Use the data given below to
Q9: In a database file, which is organized
Q10: Use the data given below to
Q11: The function returns a value or reference
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents