Which function calculates the Reduction in C2 to be filled through the rest of the reduction column if silver members have a 5% discount, gold 10% and Platinum have 20%? 
A) =IF(A2="Silver",B2*0.05,IF(A2="Gold",B2*0.1,B2*0.2) )
B) =IF(A2="Silver",B2*0.1,B2*0.2)
C) =IF(A2="Silver" B2*0.05,OR(A2="Gold",B2*0.1,OR(B2*0.2) )
D) ==IF(A2="Silver",B2*0.05,IF(A2="Gold",Platinum=B2*0.1,B2*0.2) ) )
Correct Answer:
Verified
Q1: Which of these functions does not support
Q3: A(n)_is a matrix that provides the results
Q4: What is the first argument of an
Q5: Which is the Array argument in =INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)?
A)MAX(B2:B5)
B)MATCH(MAX(B2:B5),B2:B5,0)
C)1
D)A2:B5
Q6: The YEARFRAC calculates _.
A)the year 2018 from
Q7: Why would you nest MATCH in an
Q8: IF you use the function, =MATCH(66, A1:A4,0),
Q9: If 9/3/2021 is the contents of B3,
Q10: If you need to find out how
Q11: Which function returns a value at the
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