Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b Youngwood Insurance

Описание: #Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b
#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b


Contact Us:
WhatsApp Number:+923187569415
Chatting Link :https://tinyurl.com/yzpfk6fm




I am providing help in all online courses like 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. Yuki Lo is a financial manager for Youngwood Insurance, a national insurance company. In an Excel workbook, he has been tracking income and expenses along with client data for the office in Portland, Oregon. He has asked you to help him complete the workbook and insert new charts.
Go to the Portland Office worksheet. In cell K2, insert a formula using the TODAY function to display today's date.
2. Fill the range D5:F5 with a series based on the value in cell C5 to provide the missing month names.
3. Format the text in cell A5 as follows to make it readable and more meaningful:
a. Merge and center the contents of the range A5:A18.
b. Rotate the text in the merged cell up so it reads from bottom to top.
c. Middle align the merged cell.
d. Resize column A to a width of 5.00.
4. Use AutoFit to resize column B to its best fit to display all the text in the column.
5. Complete the calculations for the Revenue data as follows:
a. In cell C8, enter 64,500 as the Life insurance income for January.
b. In cell C9, use the SUM function to total the January Income values (the range C6:C8).
c. Copy the formula in cell C9 to the range D9:F9 and to cell H9 to complete the totals.
6. Format the nonadjacent ranges C14:F17 and H14:H17 using the Comma Style format and no decimal places to match the formatting of the Income data.
7. Yuki wants to display the highest and lowest income amounts from January to April. Enter and format this information as follows:
a. In cell C25, enter a formula using the MIN function to display the lowest revenue (the range C6:F8).
b. In cell C26, enter a formula using the MAX function to display the highest revenue (the range C6:F8).
c. Apply Outside Borders to the range B25:C26 using Blue, Accent 2 (1st row, 6th column of the Theme Colors palette) as the border color to show the information belongs together.


#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b Youngwood Insurance
#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b
#SAM Capstone Project 1b
#modules 1-4
#Youngwood Insurance
#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b Youngwood Insurance
#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b
#SAM Capstone Project 1b
#modules 1-4
#Youngwood Insurance


#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b Youngwood Insurance
#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b
#SAM Capstone Project 1b
#modules 1-4
#Youngwood Insurance


#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b Youngwood Insurance
#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b
#SAM Capstone Project 1b
#modules 1-4
#Youngwood Insurance


#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b Youngwood Insurance
#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b
#SAM Capstone Project 1b
#modules 1-4
#Youngwood Insurance


#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b Youngwood Insurance
#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b
#SAM Capstone Project 1b
#modules 1-4
#Youngwood Insurance


#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b Youngwood Insurance
#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b
#SAM Capstone Project 1b
#modules 1-4
#Youngwood Insurance


#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b Youngwood Insurance
#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b
#SAM Capstone Project 1b
#modules 1-4
#Youngwood Insurance


#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b Youngwood Insurance
#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b
#SAM Capstone Project 1b
#modules 1-4
#Youngwood Insurance


#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b Youngwood Insurance
#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b
#SAM Capstone Project 1b
#modules 1-4
#Youngwood Insurance


#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b Youngwood Insurance
#Illustrated Excel 365/2021 | Modules 1-4: SAM Capstone Project 1b
#SAM Capstone Project 1b
#modules 1-4
#Youngwood Insurance