Illustrated Excel 365/2021 | Module 2: SAM Project 1a

Описание: Illustrated Excel 365/2021 | Module 2: SAM Project 1a #illustratedexcel #module2 #samproject1a

If you directly want to get the project from us then contact us on Whatsapp. Click on link below👇👇
https://wa.me/message/PPXGSJS2TLWUA1

Whatsapp Contact Number:
+91 8114420233

Email ID:
[email protected]

1. "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)."
Change the name of a worksheet.
Change the color of a worksheet tab.
2. Use AutoFit to resize column A to fit its contents.
Change the column width using AutoFit.
3. Change the width of column E to 15.00 so that the text "Professionalism" is completely visible in cell E4.
Change the column width to a specific size.
4. 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.
Apply a cell style to a range.
Change the font size of a range.
In the Spring 2024 Evaluations worksheet, the range A1:E1 should be formatted using a 20 point font size.
5. 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.
Merge and center a range.
Change the font style of a range.
6. 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.
Center a range.
In the Spring 2024 Evaluations worksheet, the contents of the range B4:E4 should be merged and centered.
Change the font color of a range.
7. 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.
Change the fill color of a range.
8. 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.
Change the font style of a range.
Change the font of a range.
9. 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).
Add a border to a range.
Change the fill color of a range.
10. "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 a conditional formatting rule.
Format a conditional formatting highlight cells rule.
11. Apply the Short Date number format to cell C14 to use a more common date format.
Change the date format.
12. 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.


new perspectives excel 2019 | module 2: sam project 1a,new perspectives excel 2019 module 1 sam project 1a,shelly cashman excel 2019 | module 1: sam project 1b,new perspectives word 2019 | module 10: sam project 1a,new perspectives excel 2019 | module 1: end of module project 2,new perspectives excel 2019 | module 10: sam project 1b,module 5 sam project 1a,module 5: sam project 1a,module 1: sam project 1a,excel module 8 sam project