Browse over 20 million
homework answers & study documents

ISM 3011 Answers

Type

Homework

Rating

Showing Page:
1/3
Question ONE
a. The correct formula for property #101 is: =VLOOKUP(M2,$R$24:$T$26,3,TRUE)
Answer: FALSE
b. The correct formula for property #101 is: =VLOOKUP(E2,$R$24:$T$26,3,FALSE)
Ans: TRUE
c. The correct formula for property #101 is: =VLOOKUP(M2,$R$24:$T$26,2,FALSE)
ANSWER: FALSE
d. The closing cost for property #125 is $400. TRUE
e. The correct formula for property #101 is: =VLOOKUP(E2,$R$24:$T$26,2,TRUE)
Ans: FALSE

Sign up to view the full document!

lock_open Sign Up

Sign up to view the full document!

lock_open Sign Up

Sign up to view the full document!

lock_open Sign Up

Unformatted Attachment Preview

Question ONEa. The correct formula for property #101 is: =VLOOKUP(M2,$R$24:$T$26,3,TRUE)Answer: FALSEb. The correct formula for property #101 is: =VLOOKUP(E2,$R$24:$T$26,3,FALSE)Ans: TRUEc. The correct formula for property #101 is: =VLOOKUP(M2,$R$24:$T$26,2,FALSE)ANSWER: FALSEd. The closing cost for property #125 is $400. TRUEe. The correct formula for property #101 is: =VLOOKUP(E2,$R$24:$T$26,2,TRUE)Ans: FALSEQuestion number two:Go to the bottom of the list. The average of all the Sales Price is listed in cell J120. Notice that Propery #218 is listed but not sold yet. How much does Property #218 need to be sold at (to be shown in cell J119) in order for the average sales price to become $100,800? Only enter whole number in the answer box; no dollar sign, no comma, no decimal point. Purchase document to see full attachment

Anonymous
Return customer, been using sp for a good two years now.

Anonymous
Thanks as always for the good work!

Anonymous
Document I purchased was really helpful. Had answers to help me with my hmw.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4