Enter the values shown in Table 1 into the corresponding cells in the range A5:E5. Table 1: Data for the Range A5:E5 A B C D E 5 Abbreviation Department MD RN Support
Format the range A5:J5 as described below:
a. Center cell contents.
b. Change the font size to 11 pt.
c. Change the background color to Blue, Accent 5, Lighter 40% (9th column, 4th row of the Theme Colors palette). d. Apply Wrap Text to the text in each cell.
Reading books is a great way to learn. Here are some of the books we recommend.
b. With A5:E5 still selected, go to the Home tab.
In the Font group, use the font size drop-down to select "11".
c. With A5:E5 still selected, go to the Home tab. In the Font group, click on the paint buc ket icon (Fill Color). Choose "More Fill Colors" or hover over the color palette to see the Theme Colors. Navigate to the 9th column, 4th row to select Blue, Accent 5, Lighter 40%.
d. Apply Wrap Text: With A5:E5 still selected, go to the Home tab.
In the Alignment group, click on the "Wrap Text" button.