Microsoft Office Tutorials and References
In Depth Information
If for any reason you want to convert your Excel table back to a normal range of cells,
click any cell in the Excel table and then, on the Design contextual tab, in the Tools
group, click Convert To Range. When Excel displays a message box asking if you’re sure
you want to convert the table to a range, click OK.
In this exercise, you’ll create an Excel table from existing data, add data to an Excel
table, add a Total row, change the Total row’s summary operation, and rename the
SET UP You need the DriverSortTimes_start workbook located in your Chapter02
practice file folder to complete this exercise. Open the DriverSortTimes_start
workbook, and save it as DriverSortTimes . Then follow the steps.
1. Select cell B2 .
2. On the Home tab, in the Styles group, click Format as Table , and then select a
The Format As Table dialog box opens.
3. Verify that the range =$B$2:$C$17 is displayed in the Where is the data for your
table? field and that the My table has headers check box is selected, and then
click OK .
Excel creates an Excel table from your data and displays the Design contextual tab.
4. In cell B18 , type D116 , press Tab, type 100 in cell C18 , and then press Enter.
Excel includes the data in your Excel table.
5. Select a cell in the table. Then on the Design contextual tab, in the Table Style
Options group, select the Total Row check box.
A Total row appears at the bottom of your Excel table.
6. Select cell C19 , click the arrow that appears at the right edge of the cell, and then
click Average .
Excel changes the summary operation to Average.