Access Millions of academic & study documents

ISM 3011 Answers

Content type
User Generated
Type
Homework
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
Showing Page:
2/3
Question number two:<Use LIST worksheet>
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.
<Hint: use goal seek to calculate the Sales Price of Property #218 in J119 based on the conidtion given above>
answer: 140400
question three: <Use TABLE worksheet>
Add a Total Row to the table. Display only the properties with 1 bathroom. What is the Average Sales Price of all
the 1 bathroom properties? Write your answer in whle number; no dollar sign, no comma, no decimal.
answer: 100537
question four : <Use TABLE Worksheet>
Create a PivotTable to calculate summary statistics. Use the following filed as labels: Style, Bedroom, and Date
Sold. And use the Sales Price as the value field. Answer the following questions:
1. What is the number of Condo properties with 2 bedrooms that were sold in May 2013? answer: 10
2. What is the average sales price for all the Ranch properties with 2 bedrooms sold in April 2013?
answer: 86589
Make sure you enter whole number only; no dollar sign, no comma, no decimal. You will need to get both
answers right to receive credit for this question.
<Hint: Group the Date Sold field!>
question five: <Use LIST worksheet>
Conditional format the column Sales Price to highlight the bottom 7% of the price in green. How many properties
have a green highlighted cell?
a. 11
b. 10
c. 9
d. 8
e. 7
question six: <Use LIST worksheet>
Calculate Condo Fee in column O. Only those properties that are condos with 2 or more bedrooms have to pay a
condo fee of $150, listed in cell S7. Enter a formula to calculate condo fees for ALL the properties. What is the
correct formula (use property #101 as an example)?
<Hint: Use IF statement to check two conditions: (1) if the property is a condo, and (2) if the property has 2 or
more bedrooms.>
a. =IF(E2="Condo",150,IF(F2>=2,0,0)
b. =IF(AND(F2>=2,E2="Condo"),S7,0)
c. =IF(OR(E2="Condo",F2>=2),S7,0)
d. =IF(AND(E2="Condo",F2>=2),$S$7,0)

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/3

Sign up to view the full document!

lock_open Sign Up
Unformatted Attachment Preview
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 ? Question 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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4