Shelly Cashman Excel 365/2021 | Modules1-3: SAM Capstone Project 1b #shelly #modules1-3 #samcapstone
If you directly want to get the project from us then contact us on Whatsapp. Click on link below👇👇
wa.me/message/PPXGSJS2TLWUA1
Whatsapp Contact Number:
+91 8114420233
Email ID:
excelprojectshelp@gmail.com
1. Liang Bandy is a senior project manager at Forward Construction, a firm that works on construction projects for business and commercial buildings. Liang has created a workbook summarizing the Office Plaza Construction project for the Meadowood Office Center. She asks for your help in completing the workbook.
Go to the Budget worksheet. Unfreeze the panes since Liang does not need to display those rows as she scrolls the worksheet.
2. In cell K2, enter a formula using the NOW function to display today's date. Apply the Short Date number format to display only the date in the cell.
3. Format the worksheet title as follows to use a consistent design throughout the workbook:
a. Fill cell C2 with the Teal, Accent 6, Lighter 40% shading color.
b. Change the font color to White, Background 1.
c. Merge and center the contents of cell C2 across the range C2:I2.
d. Use AutoFit to resize row 2 to its best fit.
4. Format the hourly rate data as follows to suit the design of the worksheet and make the data easier to understand:
a. Italicize the contents of cell L2 to match the formatting in cell J2.
b. Apply the Currency number format to cell M2 to clarify that it contains a dollar amount.
5. Format the data in cell B4 as follows to display all of the text:
a. Merge the cells in the range B4:B14.
b. Rotate the text up in the merged cell so that the text reads from bottom to top.
c. Middle-align and center the text.
d. Remove the border from the merged cell.
e. Resize column B to a width of 6.00.
6. Format the data in row 4 as follows to show that it contains column headings:
a. Change "Description" to use Code Description as the complete column heading.
b. Apply the Accent 6 cell style to the range C4:I4.
c. Use AutoFit to resize column E to its best fit.
7. In column F, Liang wants to include the actual dollar amount of the work completed. Enter this information as follows:
a. In cell F5, enter a formula without using a function that multiplies the completed hours (cell E5) by the hourly rate (cell M2) to determine the dollar amount charged for blueprint drafting. Include an absolute reference to cell M2 in the formula.
b. Use the Fill Handle to fill the range F6:F14 with the formula in cell F5 to include the charges for the other work.
c. Format the range F6:F14 using the Comma Style format and no decimal places to match the formatting in column G.
8. Liang needs to show how much of the estimate remains after the completed work. Provide this information as follows:
a. In cell H5, enter a formula without using a function that subtracts the completed amount billed (cell F5) from the estimated amount (cell G5) to determine the remaining amount of the estimate for blueprint drafting.
b. Use the Fill Handle to fill the range H6:H14 with the formula in cell H5 to include the remaining amount for the other work.
c. Format the range H6:H14 using the Comma Style format and no decimal places to match the formatting in column G.
9. Liang also wants to show the remaining amount as a percentage of the completed amount. Enter this information as follows:
a. In cell I5, enter a formula that divides the remaining dollar amount (cell H5) by the estimated dollar amount (cell G5).
b. Copy the formula in cell I5 to the range I6:I15, pasting only the formula and number formatting to display the remaining amount as a percentage of the actual amount for the other work and the total.
10. Calculate the totals as follows:
a. In cell E15, enter a formula using the SUM function to total the actual hours (range E5:E14).
b. Use the Fill Handle to fill the range F15:H15 with the formula in cell E15.