$6.$ Elena already imported data summarizing the performance of the asset management team on the Performance Summary worksheet but wants to display the data in the range G$5$:H$8$ of the Asset Management worksheet. She asks you to switch the rows and columns when you insert the data to fit in the range G$5$:H$8.$

Go to the Performance Summary worksheet. Copy the data in the range A$1$:D$2,$ and then transpose the rows and columns as you paste the data on the Asset Management worksheet starting in cell G$5.$

$7.$ In the Asset Management worksheet, insert and format a picture of the asset management team as follows so that shareholders can identify members of the team:

a$.$ Insert the picture Support$\_$EX$19\_7$a$\_$Group.jpg$.$

b$.$ Move and resize the picture proportionally so that the upper$-$left corner is in cell G$19$ and the lower$-$right corner is in cell J$36.$

c$.$ Add a border to the picture using Teal, Accent $6$ as the border color to coordinate the picture with the rest of the worksheet.

d$.$ Apply the Offset: Center picture effect from the Outer section of the Shadow gallery.

$8.$ Add a caption to identify the picture as follows:

a$.$ In cell H$37,$ insert a Text Box from the Basic Shapes section of the Shapes gallery.

b$.$ Enter Asset management team at work in the text box.

c$.$ Resize the text box to display the entire caption and move the text box so that it is centered below the picture in the range G$37$:J$38.$