Question: Open the start file EX 2 0 2 1 - ChallengeYourself - 2 - 4 . The file will be renamed automatically to include your
Open the start file EXChallengeYourself The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it
If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify it
Center and merge the title across cells A:E
Apply the Heading cell style to the merged cells.
Merge and center the four section titles across the appropriate cells Monthly Income, Available Income, Monthly Expenses, and Semester Expenses
Apply cell styles to the section titles as follows:
Monthly IncomeGreen Accent
Available IncomeOrange Accent
Monthly ExpensesGray Accent
Semester ExpensesIce Blue, Accent
Add the Gray, Accent Lighter fill color to cells A:B It is the last color in the second row under Theme Colors.
Bold cells A:B
Copy only the formatting of cells A:B to the headers in the other sections cells A:B D:E and D:E
The line item for lab fees cells A:B is in the wrong category. Cut the cells and insert them into cells D:E shifting the other cells down. Do not overwrite the existing data.
Delete the empty cells A:B shifting the other cells up
IMPORTANT: You must complete step correctly in order to receive points for completing the next steps. Check your work carefully.
Cell E has the wrong number format applied. Copy the formatting from cell E and apply it to cell E
Apply conditional formatting to cells B:B to display a red gradient data bar in each cell.
The text in cell A appears cutoff. Apply text wrapping to the cell.
Apply the default All Borders border style to the following cell ranges: A:B D:E A:B and D:E
Save and close the workbook.
Upload and save your project file.
Submit project for grading.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
