Microsoft Office Tutorials and References
In Depth Information
Defining Excel tables
item opens the Insert Function dialog box, from which you can select any of the functions
available in Excel.
Much as it does when you create a new worksheet, Excel gives your Excel tables generic
names such as Table1 and Table2. You can change an Excel table’s name to something
easier to recognize by clicking any cell in the table, clicking the Design tool tab, and then,
in the Properties group, editing the value in the Table Name box. Changing an Excel table
name might not seem important, but it helps make formulas that summarize Excel table
data much easier to understand. You should make a habit of renaming your Excel tables
so you can recognize the data they contain.
SEE ALSO For more information about using the Insert Function dialog box and about
referring to tables in formulas, see “Creating formulas to calculate values” in Chapter 3,
“Performing calculations on data.”
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 tool 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 that row’s summary operation, and rename the Excel table.
SET UP You need the DriverSortTimes workbook located in the Chapter02 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
Select cell B2 .
On the Home tab, in the Styles group, click Format as Table , and then select a table
style to open the Format As Table dialog box.