Cell e2 insert a timeline for the last remodel field

This preview shows page 3 - 4 out of 4 pages.

cell E2. Insert a timeline for the Last Remodel field. Change the time period to YEARS. Apply Light Orange, Timeline Style Light 2. Change the timeline height to 1.4 inches and with to 3.75 inches. The Databases sheet contains two tables. You will create a relationship between those tables. 5 Display the Databases sheet. Create a relationship between the APARTMENTS table using the Code field and the COMPLEX table using the Code field. 16 You want to create a Pivot Table from the related tables. Create a Pivot Table using the data model on a new sheet. Change the sheet name to
Bedrooms. Name the PivotTable Bedroom Rata. Select the Apartment Name field from the COMPLEX table for Rows, the # Bed field for Columns, and the # Bed field as Values. This will display the number of apartments with the specified number of bedrooms per apartment complex. Display the values as a percentage of row totals. Create a Clustered Column PivotChart. Cut the chart and paste it in cell A13. Select the 3-bedroom data series and apply the Black, Text 1, Lighter 50% solid fill color. Apply Black, Text 1 font color to the vertical axis and category axis. Change the chart height to 3 inches and the width to 5 inches, if necessary. Hide the field buttons in the PivotChart. Create a footer on all worksheets with your name in the left, the sheet name code in the center, and the file name code in the right. 21 Save and close Exp19_Excel_Ch05_Cap_Apartments.xlsx. Exit Excel. Submit the file as directed. Total Points 100

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture