Shelly Cashman Excel 365 | Modules 1-3: SAM Capstone Project B | DoubleDay Designers

Описание: Shelly Cashman Excel 365 | Modules 1-3: SAM Capstone Project B | DoubleDay Designers #shellycashman

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,

Whatsapp Contact Link:
https://api.whatsapp.com/message/4B6NMKKBK...

Whatsapp Number:
+919116641093
+918005564456

Gmail Id:
[email protected]

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English.



PROJECT STEPS
1. Alissa Moya is a senior account manager at DoubleDay Designers, an interior design firm that works with retail stores and restaurants. Alissa has created a workbook summarizing the status of the design project for The Social restaurant. She asks for your help in completing the workbook.

Go to the Project Status worksheet. Unfreeze the first column since it does not display information that applies to the rest of the worksheet.
2. In cell K3, 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 B1 with the Green, Accent 6, Lighter 60% shading color.
b. Change the font color to White, Background 1.
c. Merge and center the contents of cell B1 across the range B1:H1.
d. Use AutoFit to resize row 3 to its best fit.
4. Format the billing rate data as follows to suit the design of the worksheet and make the data easier to understand:
a. Bold the contents of cell J4 to match the formatting in cell J3.
b. Apply the Currency number format to cell K4 to clarify that it contains a dollar amount.
5. Format the data in cell A4 as follows to display all of the text:
a. Merge the cells in the range A3:A11.
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, if necessary.
e. Resize column A to a width of 4.00.
6. Format the data in row 4 as follows to show that it contains column headings:
a. Change "Description" to use Service Description as the complete column heading.
b. Apply the Green, Accent 6 cell style to the range B4:H4.
c. Use AutoFit to resize columns B and D to their best fit.
7. Alissa wants you to include the actual dollar amount of the services performed in column E. Enter this information as follows:
a. In cell E5, enter a formula without using a function that multiplies the actual hours (cell D5) by the billing rate (cell K4) to determine the actual dollar amount charged for general administrative services. Include an absolute reference to cell K4 in the formula.
b. Use the Fill Handle to fill the range E6:E10 with the formula in cell E5 to include the charges for the other services.
c. Format the range E5:E10 using the Comma number format and no decimal places to match the formatting in column F.
8. Alissa needs you to show how much of the estimate remains after the services are performed. Provide this information as follows:
a. In cell G5, enter a formula without using a function that subtracts the actual dollars billed (cell E5) from the estimated amount (cell F5) to determine the remaining amount of the estimate for general administrative services.
b. Use the Fill Handle to fill the range G6:G10 with the formula in cell G5 to include the remaining amount for the other services.
c. Format the range G5:G10 using the Comma number format and no decimal places to match the formatting in column F.
9. Alissa also wants you to show the remaining amount as a percentage of the actual amount. Enter this information as follows:
a. In cell H5, enter a formula that divides the remaining dollar amount (cell G5) by the estimated dollar amount (cell F5).
b. Copy the formula in cell H5 to the range H6:H11, pasting only the formula and number formatting to display the remaining amount as a percentage of the actual amount for the other services and the total.
10. Calculate the project status totals as follows:
a. In cell D11, enter a formula using the SUM function to total the actual hours (range D5:D10).
b. Use the Fill Handle to fill the range E11:G11 with the formula in cell D11.
c. Apply the Accounting number format with no decimal places to the range E11:G11.
11. Alissa also wants you to identify the services for which DoubleDay Designers has billed more than the full estimate amount.

In the range H5:H10, use Conditional Formatting Highlight Cells Rules to format values less than 1% (0.01) in Light Red Fill with Dark Red Text.
12. Alissa imported data about the consultants working on The Social project and stored the data on a separate worksheet, but wants you to include the data in the Project Status worksheet.