OMIS-Excel Notes-Linda's

How will this affect the break even ticket price 56

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: records can be inserted in the • 39 Excel Notes Jessica Gahtan OMIS2000 middle of a table by clicking the row under the insertion point and issuing the Insert Table Rows command from the Cells group of the Home tab. Editing and Deleting Records • Data within a table record can be edited using the same techniques as those for a regular cell • Deleting a record removes it from the table – Click the Home tab – Click the Delete arrow in the Cells group – Select Delete Table Rows Data within records can be edited using the same techniques as those used for a regular Excel cell. A record can be removed from a table by clicking within the row and issuing the Delete Table Rows command from the Cells group of the Home tab. Error Management – Double Entries • Visual checks or manually can be feasible for small databases • Difficult to do for large databases that are just ranges • Defining as TABLE in Excel makes this easy! – Design Tab - >Tools group - >Remove Duplicates - >Select All How else would this feature be useful? (recall: our order form) Applying a Table Style • A table style controls the fill color of the header row, columns, and records Excel offers a variety of table styles as shown in Figure 4.15. A table style controls the fill color of the header row, columns, and records. 40 Excel Notes Jessica Gahtan OMIS2000 Filtering a List with AutoFilter • Filters enable users to view a portion of the list data, rather than viewing a long data list. • The method of listing only the records that match particular criteria is called filtering. • Filtering a list is easier and less time consuming than sorting and scrolling through a long list. 41 Excel Notes Jessica Gahtan OMIS2000 Filterin...
View Full Document

Ask a homework question - tutors are online