Sharma Cybersecurity Consulting Excel Module 2 SAM Project A (STEP BY STEP ) AssignXpert Official

Complete step-by-step solution for Sharma Cybersecurity Consulting Excel Module 2 SAM Project A | New Perspectives Excel 365 Formatting Workbook Text And Data within 30 minutes.

In this video, I will provide a walkthrough for Sharma Cybersecurity Consulting Excel Module 2 SAM Project A, so follow along to finish step-by-step solution of your assignment fast and correctly.

PROJECT STEPS:
1. Yong Choe is the business manager at Sharma Cybersecurity Consulting. She asks you to format the workbook she uses to analyze monthly sales to make the data easier to read and use.

On the Sales Analysis worksheet, change the theme of the workbook to the Office 2013-2022 Theme to use the standard theme for the company.
2. Start by formatting the headings on the Sales Analysis worksheet to make them more prominent as follows:
a. Merge and Center the range A1:G1.
b. Apply the Heading 1 style to the range A1:G1.
c. Merge and Center the range A2:G2.
d. Change the font color of the merged range A2:G2 to Blue-Gray, Text 2 (4th column, 1st row of the Theme Colors palette) to match the font color of the worksheet title.
e. Change the font of the merged ranges A1:G1 and A2:G2 to Californian FB to apply the font used in other company reports.
3. Next, Yong needs you to format the report date and average sales information to separate it from the other sales data as follows:
a. Change the background color of the range A4:E4 to Gold, Accent 4, Lighter 80% (8th column, 2nd row of the Theme Colors palette).
b. Format cells A4, C4, and A12 as bold to emphasize the text.
c. Format cell B4 to use a date format with a two-digit month, a two-digit day, and a two-digit year to use the standard date format for company reports.
4. Yong also wants you to format the table headings to clarify they are headings as follows.
a. Format the ranges A6:E6 and A13:G13 as italic.
b. Apply horizontal centering to the contents of each cell in the ranges B6:E6 and B13:G13 to improve their appearance.
c. Change the background color of the ranges A6:E6 and A13:G13 to Blue, Accent 1, Lighter 60% (5th column, 3rd row of the Theme Colors palette) to format the ranges as column headings.
d. Change the background color of the ranges A7:A10 and A14:A23 to Blue, Accent 1, Lighter 80% (5th column, 2nd row of the Theme Colors palette) to format the ranges as row headings.
5. Yong wants the total rows in each table to stand out. She asks you to apply the Total cell style to the ranges A10:E10 and B23:G23.
6. The row headings in the Sales to date table need to be formatted so it is clear they each apply to three rows of data. Format the row headings as follows:
a. Merge and Center the range A14:A16 and then center the contents of the merged cell vertically.
b. Use the Format Painter to apply the formats in the range A14:A16 to the ranges A17:A19 and A20:A22
c. For the merged ranges A14:A22, rotate the cell contents to 90 degrees.
TIMESTAMPS
0:03 Introduction and overview - Excel Module 2 SAM Project A Sharma Cyber Security Consulting
1:31 Step 1 - On Sales Analysis worksheet change workbook theme to Office 2013 to 2022 from Page Layout tab
2:51 Step 2 - Merge and center range A1 to G1, apply Heading 1 style, merge and center range A2 to G2, change font color of A2 to G2 to Blue Gray Text 2, change font of A1 to G2 to Californian FB
5:42 Step 3 - Change background color of range A4 to G4 to Gold Accent 4 Lighter 80, bold cells A4, C4 and A12, format B4 with two digit month two digit day and two digit year date format
8:13 Step 4 - Apply italic formatting to range A6 to E6 and A13 to G13, apply horizontal centering to range B6 to E6 and B13 to G13, change background color of A6 to E6 and A13 to G13 to Blue Accent 1 Lighter 60, change background color of A7 to A10 and A14 to A23 to Blue Accent 1 Lighter 80
11:13 Step 5 - Apply Total cell style to range A10 to E10 and B23 to G23
12:08 Step 6 - Merge and center A14 to A16, center content vertically, use Format Painter to apply same formatting to A17 to A19 and A20 to A23, rotate cell contents of range A14 to A22 to 90 degrees
13:53 Closing - Summary, outro, contact info

📩 Need help? I complete SAM Cengage & SIMnet projects for you.
WhatsApp: +923205636783
Email: Abdulwahaj601@gmail.com

By getting the best service ever for the Cengage & SIMnet Project, you will get
100% Score, Timely Delivery, Affordable Price, 24/7 Availability, and Customer Satisfaction

Sharma Cybersecurity Consulting Excel Module 2 SAM Project A
#SharmaCybersecurityConsulting #ExcelModule2 #SAMProjectA #Cengageprojects #SAMProjects #Cengageassignments

Subscribe for more!!

Видео Sharma Cybersecurity Consulting Excel Module 2 SAM Project A (STEP BY STEP ) AssignXpert Official канала AssignXpert Official