Скачать или смотреть Illustrated Excel 365 | Module 10: SAM Project B | Project Relief

Illustrated Excel 365 | Module 10: SAM Project B | Project Relief #illustratedexcel

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. Petra Santiago is a development officer for Project Relief, a disaster relief organization in Fayetteville, Arkansas, that acquires and distributes funding grants to qualified agencies in two states. Petra and her assistant, Nora West, are using an Excel workbook to track the grants for the current and previous years. She asks for your help in reviewing Nora's comments and making the workbook accessible to all users.

Go to the Arkansas worksheet. Show the comments in the workbook, and then respond to the comment in cell B5 as follows:
a. In cell B5, change the data as Nora recommends, using AR-7144 as the entry.
b. Delete the comment in the cell.
2. Respond to the remaining comments in the worksheet as follows:
a. Go to the next comment in the worksheet, which is from Nora West in cell F5.
b. Reply to the comment in cell F5 by including the text Okay, thank you as the response, and then post your reply.
c. Reply to the comment in cell D10 by including the text Yes, he is. as the response, and then post your reply.
3. Petra notices that an entry in the Received to date column might be incorrect and wants you to ask Nora to verify it.

In cell F7, insert and post a new comment that contains the following text:
I thought the funding was higher. Please verify this amount.
4. Read the note in cell B11, and then convert all notes to comments since the note is asking for a response.
5. Petra asks you to insert a reminder to update the Received to date totals when new funding is received. In cell F4, insert a new note that contains the following text:
Update totals next month.
6. Check the accessibility of the workbook to determine whether the content is accessible to all users.

Respond to the inspection results as follows:
a. Mark Picture 2 (the logo) on the Arkansas worksheet as decorative.
b. Add A column chart comparing funding to previous year as the alt text description for Chart 1 on the Arkansas worksheet.
c. Rename Sheet1 by using Missouri as the new name.
7. Petra often creates worksheets that list the full names of the six types of grants Project Relief acquires. Provide a way for her to quickly list the grant types as follows:
a. Return to the Arkansas worksheet.
b. Create a custom list of grants by importing and adding the data in the range K5:K10 to a new custom list.
[Hint: Score will be added for this step after completing step 9]
8. She also asks you to fine-tune the appearance of the workbook to coordinate with the Project Relief logo. Customize the theme colors and fonts as follows:
a. Customize the theme colors by using Dark Blue, Background 2 (3rd column, 1st row in the Theme Colors palette) as the Accent 3 color.
b. Use Blue, Accent 2, Darker 25% (6th column, 5th row in the Theme Colors palette) as the Accent 6 color.
c. Use Project Relief as the name of the custom theme colors.
d. Customize the theme fonts by using Aptos as the body font.
e. Use Project Relief as the name of the custom theme fonts.
9. Go to the Missouri worksheet. Insert the grants data by entering Corporate in cell K5, and then filling the range K6:K10 based on the data in cell K5.
Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the website to submit your completed project.