Скачать или смотреть IL Excel 365 2021 Module 4 End of Module project 1 Dexter Bank and Trust

IL Excel 365 2021 Module 4 End of Module project 1 Dexter Bank and Trust


For any kind of help contact us via links given below, we are available 24/7

Whatsapp
wa.me/message/Q7NLXG5MHPX6J1

Instagram
instagram.com/master_tutor94



"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."

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 column, 1st row in the Theme Colors palette), and applying the Glow: 5 point; Orange, Accent color 1 Glow shape effect.


Brianna wants to compare the cities with the highest and lowest number of new branches. Create a 2-D Area chart based on the range A7:E8, and enter Most and Fewest New Branches as the chart title. Resize and reposition the chart so its upper-left corner is within cell K15 and its lower-right corner is within cell R29.

Format the new area chart to make it easier to understand and to improve its appearance: Change the chart layout to Layout 7 to clearly display markers for each quarter. Change the chart colors to Monochromatic Palette 1 to use softer colors.


Clarify the purpose of the horizontal axis in the new area chart by adding a primary horizontal axis title to the chart. Enter the text Quarters as the title of the primary horizontal axis.

Excel Module 4 Project 1 Dexter Bank and trust
Dexter Bank and Trust Excel Project 1
IL EX 365 Module 4 End of Module Project 1


#cengagesolution #excel #solutionexpert