BIS 155 iLab 4 Student Education Trust Create Address Labels ( New )
For more course tutorials visit www . tutorialrank . com
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