24 / 7 Live Support
support@helpinhomework.org
+44-7309655268
+91-9828671065
Question: Shelly Cashman Excel 365/2021 | Modules 1-3: SAM Capstone Project 1b Forward Construction CREATE FORMULAS WITH FUNCTIONS PROJECT STEPS 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
Shelly Cashman Excel 365/2021 | Modules 1-3: SAM Capstone Project 1b
Forward Construction
CREATE FORMULAS WITH FUNCTIONS
PROJECT STEPS
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.
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.
Format the worksheet title as follows to use a consistent design throughout the workbook:
Fill cell C2 with the Teal, Accent 6, Lighter 40% shading color.
Change the font color to White, Background 1.
Merge and center the contents of cell C2 across the range C2:I2.
Use AutoFit to resize row 2 to its best fit.
Format the hourly rate data as follows to suit the design of the worksheet and make the data easier to understand:
Italicize the contents of cell L2 to match the formatting in cell J2.
Apply the Currency number format to cell M2 to clarify that it contains a dollar amount.
Format the data in cell B4 as follows to display all of the text:
Merge the cells in the range B4:B14.
Rotate the text up in the merged cell so that the text reads from bottom to top.
Middle-align and center the text.
Remove the border from the merged cell.
Resize column B to a width of 6.00.
Format the data in row 4 as follows to show that it contains column headings:
Ещё видео!