Illustrated Excel 365/2021 | Module 4: End of Module Project 1 | Dexter Bank and Trust (Full 2025)

Dexter Bank and Trust INSERT AND MODIFY CHARTS GETTING STARTED Save the file IL EX365_2021 EOM4-1 FirstLastName_1.xlsx as IL EX365_2021_EOM4-1 FirstLastName_2.xlsx о Edit the file name by changing "1" to "2". If you do not see the .xlsx file extension, do not type it. The file extension will be added for you automatically. With the file IL EX365_2021_EOM4-1_FirstLastName_2.xlsx open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet. If cell B6 does not display your name, delete the file and download a new copy. PROJECT STEPS 1. As the director of operations for Dexter Bank and Trust in Philadelphia, Pennsylvania, Brianna Macaulay is overseeing the expansion of the bank into new locations. To prepare for a presentation to the bank's board, she has created an Excel workbook tracking the new branches opened in West Virginia. She asks for your help in formatting and creating charts in the workbook. Go to the New Branches worksheet. The New Branches by Quarter stacked column chart shows the new branches opened in five locations in 2024. Change the chart type to a Clustered Column chart to make the data easier to interpret. 2. Move the chart legend to the Right position to remove the clutter from the bottom of the chart. 3. Brianna knows the board members will be interested in new branches opened in the fourth quarter. Highlight the data series representing Quarter 4 in the clustered column chart by changing the fill color of the Quarter 4 data series to Orange, Accent 6 (10th 4. The 2-D pie chart is supposed to compare the number of new branches opened in each city, but Brianna finds it difficult to understand what the wedges in the chart represent. Apply the Style 9 chart style to the 2-D pie chart to display the city names closer to the data.

#MicrosoftExcel
#Excel
#Microsoft
#IllustratedExcel
#SAMProject