1.5 Chapter Practice: PR1 Medical Office Budget
To assess your understanding of the material covered in the chapter, complete the following assignment.
Basic Monthly Budget for Medical Office
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.
preparing the worksheet
- Open the file named PR1 Data, then Save As PR1 Medical Office Budget.
- Change the font of the entire worksheet (Sheet 1) to Calibri, size 12. (Hint: Select all cells in the worksheet by clicking the Select All button in the upper left corner of the worksheet.
- Increase the width of Column A so all the entries in the range A3:A8 are visible. (Hint: 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 OR double-click)
- Enter the label Quarter 1 in cell B2.
- Complete the headings in the range C2:E2 to contain the labels Quarter 2, Quarter 3, and Quarter 4. (Hint: Use AutoFill by placing the mouse pointer over the Fill Handle in cell B2 and then dragging through cell E2)
- Change the width of columns B through E to 12 characters. (Hint: Select the four columns. On the Home ribbon, in the Cells group, click Format – Column Width)
- Insert a blank column between Columns A and B. (Hint: Select any cell 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 Budget Cost in cell B2.
- Adjust the width of Column B to approximately 12.
- Enter the text Medical Office Budget in cell A1. (This will be the title for the worksheet)
- Merge and center the range A1:F1. (Hint: Select the range A1:F1 and click the Merge & Center button in the Home tab of the Ribbon to merge the cells in that range)
- Make the following formatting changes to the newly merged cell
- Bold and italics
- Font size:14
- Cell fill color: any dark color
- Font color: white
- Vertical alignment: middle
- Increase the height of Row 1 to approximately 25. (Hint: Select any cell in the row. On the Home ribbon, in the Cells group, click Format – Row Height)
- Make the following formatting changes to the cells containing the column headings (A2:F2)
- Bold
- Fill color: Tan
- Horizontal alignment: Center
- Wrap Text
- Copy the contents of cell C3 (Quarter 1 – Salaries) into the range D3:F3. (Hint: use Copy and Paste or AutoFill)
- Copy the contents of the range C6:C8 (Quarter 1 – Rent, Office Supplies, and Phone & Utilities) into the range D6:F8. (Hint: use Copy and Paste or AutoFill)
- Apply borders to all of the cells in the range A1:F8. (Hint: Select A1:F8 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