Saylor URL: http://www.saylor.org/books
Insert a blank column between Columns A and B. Activate any cell location in Column B. Then, click
the drop-down arrow of the Insert button in the Home tab of the Ribbon. Click the Insert Sheet
Enter the words Budget Cost in cell B2.
Adjust the width of Column B to 13.29 characters.
Formatting and Basic Charts
Merge the cells in the range A1:F1. Highlight the range and click the Merge & Center button in the
Home tab of the Ribbon.
Make the following format adjustments to the range A1:F1: bold; italics; change the font size to 14
points; change the cell fill color to Aqua, Accent 5, Darker 50%; and change the font color to white.
Increase the height of Row 1 to 24.75 points.
Center the title of the worksheet in the range A1:F1 vertically. Activate the range and then click the
Middle Align button in the Home tab of the Ribbon.
Make the following format adjustment to the range A2:F2: bold; and change the cell fill color to Tan,
Background 2, Darker 10%.
Set the alignment in cell B2 to Wrap Text. Activate the cell location and click the Wrap Text button in
the Home tab of the Ribbon.
Copy cell C3 and paste the contents into the range D3:F3.
Copy the contents in the range C6:C8 by highlighting the range and clicking the Copy button in the
Home tab of the Ribbon. Then, highlight the range D6:F8 and click the Paste button in the Home tab
of the Ribbon.
Calculate the total budget for all four quarters for the salaries. Activate cell B3 and click the down
arrow on the AutoSum button in the Formulas tab of the Ribbon. Click the Sum option from the drop-
down list. Then, highlight the range C3:F3 and press the ENTER key on your keyboard.
Copy the contents of cell B3 and paste them into the range B4:B8.
Format the range B3:F8 with a US dollar sign and zero decimal places.
Sort the data in the range A2:F8 based on the values in the Quarter 4 column in ascending order.
Highlight the range A2:F8 and click the Sort button in the Data tab of the Ribbon. Select Quarter 4 in