Three/25/2021 Built-in Report
https://openvellum.ecollege.com/course.html?courseId=16591558&OpenVellumHMAC=38918ba78d478e28c887942a6ad19b68#10203 1/Three
Rating Card Element
Whole Rating: eight%
Earned Factors: 8pts
Attainable Factors: 100pts
Step Instruction Earned Attainable
1 zero zero
2 1.5 Three
Three 2.5 5
four zero 2
5 2 7
6 2 6
7 zero Three
Begin Excel. Obtain and open the file named
Exp19_Excel_Ch05_Cap_Apartments.xlsx. Grader has routinely
added your final title to the start of the filename.
Earlier than subtotalling the information, it’s essential to type the information.
Choose the Abstract sheet. Type the information by Residence Complicated in
alphabetical order and additional type it by # Mattress (the variety of bedrooms)
from smallest to largest.
You wish to use the Subtotal characteristic to show the common complete deposit
by variety of bedrooms for every condo advanced.
Use the Subtotal characteristic to insert subtotal rows by Residence Complicated to
calculate the common Whole Deposit. Add a second subtotal (with out
eradicating the primary subtotal) by # Mattress to calculate the common Whole
Deposit by the variety of bedrooms.
Use the define symbols to show solely the subtotal rows. Create an
computerized define and collapse the define above Whole Deposit.
You wish to create a PivotTable to find out the whole month-to-month rental
income for occupied residences.
Show the Leases sheet and create a clean PivotTable on a brand new
worksheet to the left of the Leases sheet. Change the title of the
worksheet to Rental Income. Title the PivotTable Rental Income.
Show the Residence Complicated and # Mattress fields in Rows and the Rental
Value area as Values.
Format the Sum of Rental Value for Accounting Quantity Format with zero
decimal locations and enter the customized title Whole Hire Collected.
Three/25/2021 Built-in Report
https://openvellum.ecollege.com/course.html?courseId=16591558&OpenVellumHMAC=38918ba78d478e28c887942a6ad19b68#10203 2/Three
eight zero Three
9 zero 15
10 zero 5
11 zero 5
12 zero 5
13 zero 6
14 zero 5
15 zero 5
16 zero 5
17 zero 5
Choose the Occupied area for the filter and set the filter to Sure to show
knowledge for occupied residences.
You wish to calculate the whole month-to-month rental income if the charges enhance
by 5% for the occupied residences.
Insert a calculated area to multiply the Rental Value by 1.05. Change the
title to New Rental Income. Apply Accounting Quantity Format with
zero decimal locations.
Choose the vary B3:C3 and apply these codecs: wrap textual content, Align Proper
horizontal alignment, and 30 row top. Choose column B and set 9.29
column width. Choose column C and set 14.43 column width.
Apply Gentle Orange, Pivot Fashion Medium 10 to the PivotTable and show
banded rows.
Insert a slicer for # Mattress with the intention to filter the dataset by variety of
bedrooms. Change the slicer caption to # of Bedrooms.
Change the slicer top to 1.four inches and width to 1.75 inches. Apply
Gentle Orange, Slicer Fashion Gentle 2. Reduce the slicer and paste it in cell E2.
Insert a timeline for the Final Rework area. Change the time interval to
YEARS. Apply Gentle Orange, Timeline Fashion Gentle 2. Change the timeline
top to 1.four inches and with to three.75 inches.
The Databases sheet comprises two tables. You’ll create a relationship
between these tables.
Show the Databases sheet. Create a relationship between the
APARTMENTS desk utilizing the Code area and the COMPLEX desk utilizing
the Code area.
You wish to create a PivotTable from the associated tables.
Create a PivotTable utilizing the information mannequin on a brand new sheet. Change the
sheet title to Bedrooms. Title the PivotTable BedroomData.
Choose the Residence Title area from the COMPLEX desk for Rows, the
# Mattress area for Columns, and the # Mattress area as Values. It will show
the variety of residences with the required variety of bedrooms per
condo advanced. Show the values as a share of row totals.
Three/25/2021 Built-in Report
https://openvellum.ecollege.com/course.html?courseId=16591558&OpenVellumHMAC=38918ba78d478e28c887942a6ad19b68#10203 Three/Three
18 zero 5
19 zero 5
20 zero 5
21 zero zero
Create a Clustered Column PivotChart. Reduce the chart and paste it in cell
A13 utilizing the Vacation spot Theme.
Choose the Three-bedroom knowledge sequence and apply the Black, Textual content 1, Lighter
50% stable fill coloration. Apply Black, Textual content 1 font coloration to the vertical axis and
class axis. Change the chart top to three inches and the width to five
inches, if vital. Conceal the sphere buttons within the PivotChart.
Create a footer on all worksheets along with your title within the left, the sheet
title code within the middle, and the file title code in the correct.
Save and shut Exp19_Excel_Ch05_Cap_Apartments.xlsx. Exit Excel.
Submit the file as directed.
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
