![]() ![]() Select the range B5:B10, and then in the Alignment group, click Center. Under Titles and Headings, click Heading 4.Ĭlick cell A11, and then from the Cell Styles gallery, under Themed Cell Styles, click 40% - Accent 1. With the range B4:F4 selected, and then on the Home tab, in the Styles group, click Cell Styles. In the Alignment group, apply Middle Align to the range B4:F4. With the range B4:F4 still selected, in the Alignment group, click Center. Select the range B4:F4, and then on the Home tab, in the Alignment group, click Wrap Text. With the columns selected, in the column heading area, point to the right boundary of any of the selected columns to display the pointer, and then drag to set the width to 95 pixels (12.86). I don't know what the "to the left" part means, just click ENTER 1.00 Point: XL Activity 1.26: Adjusting Column Widths and Wrapping Text To the left of the Formula Bar, click the Enter button to maintain cell F4 as the active cell.Ĭopy the formula from cell F4 down through the range F5:F9. Click cell E10, and then press F4 to set cell E10 as an absolute cell reference in the formula. Click cell E4, and then type / (division sign). From the Cell Styles gallery, apply the Total cell style result placed itself in cell E10 1.00 Point: XL Activity 1.22: Copying Formulas Containing Absolute Cell ReferencesĬlick cell F4, and then type = (equal sign). Select the nonadjacent ranges C4:E4, E10, and then apply the Accounting Number Format.Ĭlick cell E10. ![]() Select the range C5:E9, and then apply Comma Style Excel widens the columns to accommodate the data. In the displayed gallery, click Totals, and then click the first Sum button to sum the range E4:E9 and place the result in cell E10. ![]() In the lower right corner of the selected range, click the Quick Analysis button. 1.00 Point: XL Activity 1.21: Using the Quick Analysis Tool ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |