Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Responses : A = Correct B = Correct but meaningless C = Incorrect =VLOOKUP(A10,D11:E15) _ =VLOOKUP(A10,D11:E15,2) _ =VLOOKUP(A10,D11:E15,3) _ =FV(1500,10,0.11) _ =IF(A10-B10 > 200, ((A10-B10)
Responses: A = Correct B = Correct but meaningless C = Incorrect |
=VLOOKUP(A10,D11:E15) _ |
=VLOOKUP(A10,D11:E15,2) _ |
=VLOOKUP(A10,D11:E15,3) _ |
=FV(1500,10,0.11) _ |
=IF(A10-B10 > 200, ((A10-B10) - 200)*.35,0) _ |
=IF(A10>50,100,.05*(A11+100) _ |
=IF(WEEKDAY(B10)=1,30,IF(WEEKDAY(B10)=7,20,0)) _ |
=IF(A10>=A10, 50,80) _ |
=IF(C10<>"Bobby",100,0) _ |
=WEEKDAY(A10 + 1000) _ |
=WEEKDAY(A10) + 1000 _ |
=WEEKDAY(G10)+MONTH(G10) _ |
=MAX(A10,60) _ |
=.05*MAX(SUM(B11:B100),SUM(C11:C100),Sum(D11:D100)) _ |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started