Circuit Realty. Alice Cho works at Circuit Realty in Tempe, Arizona. She wants to use Excel to summarize the home listings in the Tempe area. Alice has already inserted some of the new listings into an Excel workbook including descriptive statistics about the homes and their prices. She wants your help in summarizing this data using informative charts. Complete the following:
1.Open the circuit workbook located in the Excel4 > Case2 folder included with your Data Files, and then save the workbook as circuit Realty in the location specified by your instructor.
2.In the Documentation worksheet, enter your name in cell B3 and the date in cell B4.
3.n the Housing Tables worksheet, using the data in the range A4:B8, create a 2-D pie chart of the number of listings by region. Move the pie chart to the Summary worksheet in the range A4:E15. Change the chart title to Listings by Region Add data labels showing the percentage of listings in each region, displaying the data labels outside the pie slices.
4.In the Housing Tables worksheet, using the range A10:B14, create a pie chart of the listings by the number of bedrooms. Move the pie chart to the Summary worksheet in the range A17:E28.
Circuit Realty. Alice Cho works at Circuit Realty in Tempe, Arizona. She wants to use Excel to summarize the home listings in the Tempe area. Alice has already inserted some of the new listings into an Excel workbook including descriptive statistics about the homes and their prices. She wants your help in summarizing this data using informative charts. Complete the following:
1.Open the circuit workbook located in the Excel4 > Case2 folder included with your Data Files, and then save the workbook as circuit Realty in the location specified by your instructor.
2.In the Documentation worksheet, enter your name in cell B3 and the date in cell B4.
3.n the Housing Tables worksheet, using the data in the range A4:B8, create a 2-D pie chart of the number of listings by region. Move the pie chart to the Summary worksheet in the range A4:E15. Change the chart title to Listings by Region Add data labels showing the percentage of listings in each region, displaying the data labels outside the pie slices.
4.In the Housing Tables worksheet, using the range A10:B14, create a pie chart of the listings by the number of bedrooms. Move the pie chart to the Summary worksheet in the range A17:E28.
Circuit Realty. Alice Cho works at Circuit Realty in Tempe, Arizona. She wants to use Excel to summarize the home listings in the Tempe area. Alice has already inserted some of the new listings into an Excel workbook including descriptive statistics about the homes and their prices. She wants your help in summarizing this data using informative charts. Complete the following:
1.Open the circuit workbook located in the Excel4 > Case2 folder included with your Data Files, and then save the workbook as circuit Realty in the location specified by your instructor.
2.In the Documentation worksheet, enter your name in cell B3 and the date in cell B4.
3.n the Housing Tables worksheet, using the data in the range A4:B8, create a 2-D pie chart of the number of listings by region. Move the pie chart to the Summary worksheet in the range A4:E15. Change the chart title to Listings by Region Add data labels showing the percentage of listings in each region, displaying the data labels outside the pie slices.
4.In the Housing Tables worksheet, using the range A10:B14, create a pie chart of the listings by the number of bedrooms. Move the pie chart to the Summary worksheet in the range A17:E28.
Circuit Realty. Alice Cho works at Circuit Realty in Tempe, Arizona. She wants to use Excel to summarize the home listings in the Tempe area. Alice has already inserted some of the new listings into an Excel workbook including descriptive statistics about the homes and their prices. She wants your help in summarizing this data using informative charts. Complete the following:
1.Open the circuit workbook located in the Excel4 > Case2 folder included with your Data Files, and then save the workbook as circuit Realty in the location specified by your instructor.
2.In the Documentation worksheet, enter your name in cell B3 and the date in cell B4.
3.n the Housing Tables worksheet, using the data in the range A4:B8, create a 2-D pie chart of the number of listings by region. Move the pie chart to the Summary worksheet in the range A4:E15. Change the chart title to Listings by Region Add data labels showing the percentage of listings in each region, displaying the data labels outside the pie slices.
4.In the Housing Tables worksheet, using the range A10:B14, create a pie chart of the listings by the number of bedrooms. Move the pie chart to the Summary worksheet in the range A17:E28.
