Quiz-1
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.
Entering, Editing, and Managing Data
1. Activate all the cell locations in the Sheet1 worksheet by left clicking the Select All
button in the upper left corner of the worksheet.
2. In the Home tab of the Ribbon, set the font style to Arial and the font size to 12 points.
3. Increase the width of Column A so all the entries in the range A3:A8 are 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.
4. Enter Quarter 1 in cell B2.
5. 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.
6. Increase the width of Columns B, C, D, and E to 10.14 characters. Highlight the range
B2:E2 and click the Format button in the Home tab of the Ribbon. Click the Column
