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

#DoubleDay Designers Excel | Modules 1-3: SAM Capstone Project B
#DoubleDay Designers Excel | Modules 1-3: SAM Capstone Project B

Contact Us:
WhatsApp Number:+923187569415
Chatting Link :https://tinyurl.com/yzpfk6fm
I am providing help in all online courses like SiMnet Excel, Word, Access, PowerPoint, Accounting , Management Courses, Finance Courses, Computer Science Courses, Information Technology Courses, All Writing Assignments etc. I can do your Quizzes, Exams , Mid-Term, Final Exams. In short I can get you A grade in your courses. If you want me do your courses My WhatsApp number and Email is given you can contact me through that. Thanks

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.

Видео Excel | Modules 1-3: SAM Capstone Project B DoubleDay Designers канала MindTap Assignments