BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 28

B.
Create a pivot table based on the named range, SalesData.
Create the pivot table in a new worksheet.
C.
Select Selling Agent as your Row Labels and City as your
Column Labels. Select Percent of Sales as your Values. Change the
Summary type for Percent of Sales to average, the Number Format
to percent, and the Name to Average Percent of Asking Price. Apply
Data Bars Conditional Formatting to the percentages. Hide the Field
Headers.
D.
Rename the sheet PivotTable, and move it so that it is the last
tab in the worksheet.
STEP 7: Draw a Conclusion
On the Documentation Sheet, add a section called Analysis. Based on
your data analysis, do you believe that Luke Liberty Realty should be
allowed to advertise that they "Get your price?" Justify your answer
by referring to the data analysis you have just completed.
Submit your completed workbook to the Dropbox. Make sure you
post a comment about what you learned when submitting the file.
=========================================

BIS 155 iLab 4 Student Education Trust Create Address
Labels (New)
For more course tutorials visit

www.tutorialrank.com