Creating and maintaining budgets are common practices in many careers. Budgets play a critical role in helping a business or household control expenditures. In this exercise you will create a budget for a hypothetical medical office while reviewing the skills covered in this chapter. Begin the exercise by opening the file named Chapter 1 CiP Exercise 1 Download Chapter 1 CiP Exercise 1.InstructionsNote: Depending on your installation and configuration, color choices available to you may be different than what is specified in the instructions. Simply choose something similar.Entering, Editing, and Managing DataActivate all of the cell locations in the Sheet1 worksheet.Left click the Select All button in the upper left corner of the worksheet.Click on the Home tab of the Ribbon. Set the font style to Arial and the font size to 12 points.Click on any cell to deselect the cells.Increase the width of Column A so that all text for the entries in the range A3:A8 is visible.Place the mouse pointer between the letter A and letter B of Column A and Column B. When the mouse pointer changes to a double arrow, left click and drag it to the right until the character width is 18.00.Enter Quarter 1 in cell B2.Use AutoFill to complete the headings in the range C2:E2.Activate cell B2 and place the mouse pointer over the Fill Handle. When the mouse pointer changes to a black plus sign, left click and drag it to cell E2.Increase the width of Columns B, C, D, and E to 10.14 pixels.Highlight the range B2:E2 and click the Format button in the Home tab of the Ribbon. Click the Column Width option, type 10.14 in the Column Width dialog box, and then click the OK button in the Column Width dialog box.Enter the words Medical Office Budget in cell A1.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 Columns option.Enter the words Total Budget in cell B2.Adjust the width of Column B to 13.29 pixels.Formatting and Basic ChartsMerge 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 the “Sort by” drop-down box and select Smallest to Largest in the Order drop-down box. Click the OK button.Add vertical and horizontal lines to the range A1:F8. Highlight the range and click the down arrow next to the Borders button in the Home tab of the Ribbon. Select the All Borders option from the drop-down list.Change the name of the Sheet1 worksheet tab to “Budget.” Double click the worksheet tab, type the word Budget, and press the ENTER key.Insert a pie chart using the data in the range A2:B8. Highlight the range and click the Pie button in the Insert tab of the Ribbon. Click the first option on the list (the Pie option).Click and drag the chart so the upper left corner is in the center of cell H2.Add labels to the chart by clicking the Layout 1 option from the Chart Layouts list in the Design tab of the Ribbon. Make sure the chart is activated by clicking it once before you look for the Layout 1 Chart Layout option.PrintingChange the orientation of the Budget worksheet so it prints landscape instead of portrait. Click the down arrow on the Orientation button in the Page Layout ribbon and select Landscape.Adjust the appropriate settings so the Budget worksheet prints on one piece of paper. Click on the down arrow of the Width drop down box on the Page Layout ribbon and select 1 page. Click on the down arrow of the Height drop down box on the page Layout Ribbon and select 1 page.Add a header to the Budget worksheet that shows the date in the upper left corner and your name in the center. Click on the Header and Footer button on the Insert ribbon. Click on the left header area and click on the Current Date button on the Header and Footer ribbon. Click on the center header area and type your name.Add a footer to the Budget worksheet that shows the page number in the lower right corner. Scroll to the bottom of the page and click on Add Footer Click on the center footer area and click on the Page Number button on the Header and Footer ribbon.
