1. Start Excel open the student data file Excel02_Expenditures, and then compare your screen with Figure 1. When columns in a worksheet are not wide enough, the labels in the cells will be truncated and values will display as # characters. 2. Click Save As, and then navigate to the location where you are saving your files. Create a New folder, named Excel Chapter 2Type the name Last_First_Excel02_Expenditures replacing Last First with your first and last names. If you are saving your files to OneDrive, the AutoSave feature will automatically be turned on. Figures in this chapter will show AutoSave turned on. 3. Verify Expenditures is the active worksheet. Click the Insert tab, and then in the Text group, click the Header & Footer button. In the Navigation group, click the Go to Footer button. Click in the left section of the Footer, and then in the Header & Footer Elements group, click the File Name button. Click a cell above the footer. On the status bar, click the Normal button [EE] and then press (Ctrl} + | Home } e MOS Obj 1.3.3A MOS Obj 1.4.2A 4. Click cell B2. Point to the green box in the lower right corner of the cell to display the pointer, and then drag right through cell E2 to AutoFill the labels. Compare your screen with Figure 2. Excels AutoFill feature can generate a series of values into adjacent cells. A Series is a group of numbers, text, dates, or time periods that come one after another in succession. For example, the months January, February, March are a series. Likewise, 1st Quarter, 2nd Quarter, 3rd Quarter, and 4th Quarter form a series. e MOS Obj 2.1.2A 5. Select the range A2:G2. On the Home tab, in the Alignment group, click the Wrap Text button [| the Middle Align button =| and the Center button [=] e MOS Obj 2.2.4A MOS Obj 2.2.2.A 6. In the column heading area, point to the right boundary of column A to display the pointer, as shown in Figure 3.

Attachments:

Exel-Exercise....pdf

Excel02-Expen....xlsx