OMIS-Excel Notes-Linda's

The aircraft has a maximum capacity of 200 passengers

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: or an entity—for example, an employee record using name, street, town, state, and zip code fields. 38 Excel Notes Jessica Gahtan OMIS2000 Each record should use one row of the table with no blank rows. If multiple tables are used in a single worksheet, they should be separated from each other by blank rows and columns. Creating a Table • A table can easily be created from existing data Use the following steps to create a table from an existing range of data: 1. Click anywhere within the range of data. 2. Click the Insert tab. 3. Click Table from the Tables group. Figure 4.12 illustrates the Create Table Dialog Box. Determine that the proposed table range is correct and the check box concerning the table header row is checked. • The Design tab on the Table Tools contextual tab opens when the table is selected The Design tab on the Table Tools contextual tab appears whenever a cell within the table is selected. Many table- related formatting and design commands are offered, including table name and table styles. Table 4.13 shows an Excel table in Default Format. Adding Records • Add a new record at the bottom of the table by clicking in the row under the table • Add a new record within the table by clicking in the record below the insertion point – Click the Home tab – Click the Insert arrow in the Cells group – Select Insert Table Rows Above • When a new record is entered into the blank row under a table, the table is automatically extended to include it. New...
View Full Document

Ask a homework question - tutors are online