IL_EX365_2021_2a_ZacharySutton_Report_1

Zachary Sutton GE ver. 17.0.1-rc0000 1. 1/1 Change the name of a worksheet. Change the color of a worksheet tab. 2. 1/1 Change the column width using AutoFit. 3. 1/1 Change the column width to a specific size. 4. 1/1 Apply a cell style to a range. Change the font size of a range. 5. 1/1 Merge and center a range. Change the font style of a range. 6. 1/1 Center a range. Change the font color of a range. 7. 1/1 Change the fill color of a range. 8. 1/1 Change the font style of a range. Change the font of a range. 9. 1/1 Add a border to a range. Change the fill color of a range. 10. 1/1 Apply a conditional formatting rule. Format a conditional formatting highlight cells rule. 11. 1/1 Change the date format. 12. 1/1 Change the number format. Change the number of decimal places. 13. 1/1 Change the number format. Change the number of decimal places. 14. 2/2 Enter a number in a cell. Delete a row. 15. 2/2 Run Spell Check. 16. 2/2 Use Find and Replace to update cell values. 17. 2/2 Change the number of decimal places. 18. 2/2 Apply a conditional formatting rule that uses data bars. Format a conditional formatting rule that uses data bars. 19. 2/2 Move a worksheet. SUBMISSION #1 | SCORE IS: 25 OUT OF 25 Anita Cruz is a trainer for Missoula University Hospital in Missoula, Montana. She is using an Excel workbook to analyze the courses she teaches and to track her progress toward the Train the Trainer certification. She has asked you to format her workbook to make the information clearer and easier to understand. Go to the Evaluations worksheet. Rename the Evaluations worksheet to Spring 2024 Evaluations , and then change the tab color of the worksheet to Blue-Gray, Text 2 (4th column, 1st row of the Theme Colors palette). Use AutoFit to resize column A to fit its contents. Change the width of column E to 15.00 so that the text "Professionalism" is completely visible in cell E4. Apply the Title cell style to the range A1:E1, and then increase the font size in that range to 20 point to make the worksheet title stand out. Merge and center the range A3:E3, then bold the cell contents to clarify that the text is a title for the range A4:E12. Center the text in the range B4:E4 and change the font color of the range to White, Background 1 (1st column, 1st row of the Theme Colors palette) to make the column headings easier to read. Use the Format Painter to apply the format from the range A7:E7 to the range A9:E9 to create consistent shading and borders in the worksheet. Italicize the contents of the range A11:A12 and change its font to Calibri Light to separate those row headings from the others above them. In the range A11:E12, apply a Bottom Double Border to the cells, and then change the fill color to Blue-Gray, Text 2, Lighter 80% (4th column, 2nd row of the Theme Colors palette). Anita wants to know at a glance in which courses she is receiving excellent evaluations on average. In the range B12:E12, use Conditional Formatting Highlight Cells Rules to format cells whose contents are greater than 17 with Light Red Fill with Dark Red Text . Apply the Short Date number format to cell C14 to use a more common date format. Apply the Percentage number format to cell C15 to clarify the cell contains a percentage value and then decrease the number of decimal places shown to zero. Anita would like to see the dollar amount of bonuses she received in a rounded format. Apply the Accounting number format to cell C16 and then decrease the number of decimal places shown to zero. ( Hint : Depending on how you complete this action, the number format may appear as Custom instead of Accounting.) Enter the score 15 in cell E10, and then delete row 18 because Anita no longer needs the reminder note in cell A18. Check the Spelling in the workbook to identify and correct any spelling errors. Anita also keeps track of her requirements for the Train the Trainer certificate in this workbook. Go to the Certificate Requirements worksheet. Find and replace all occurrences of the text "Cr." with: Credits For the range B3:C8, increase the number of decimal places displayed to one. In the range B6:C6, use Conditional Formatting to create a Data Bars rule, and use the Gradient Fill Blue Data Bar color option so that Anita can clearly see her progress toward certification in all subject areas. Move the Certificate Requirements worksheet after the Spring 2024 Schedule worksheet to use a more logical order. ( Hint : The order of the worksheets in the workbook should be as follows: Documentation , Spring 2024 Evaluations , Spring 2024 Schedule , and Certificate Requirements .) Illustrated Excel 365/2021 | Module 2: SAM Project 1a

Author: Note: Illustrat

Evaluations - Spring 2024 Current evaluation scores Orientation Leadership EHRs Professionalism Presentation 9 20 18 16 Content 16 20 20 15 Activities 11 17 19 10 Exercises 20 18 20 15 Group Activities 18 17 19 18 Visuals 16 20 17 15 Total 90 112 113 89 Average 15 19 19 15 Review Date 4/14/2024 Completion (%) 80% Bonuses Received ($) $ 616

Certificate Requirements Subject Area Required Credits Current Credits Communication 8.0 3.5 Management 8.0 2.5 Instructional Design 10.0 4.5 Facilitation Skills 4.0 0.0 Presentation Skills 6.0 6.0 Web-Based Training 4.0 0.0 Last Updated 14-Apr-24