B ITM 215 Information Lecture Notes - Lecture 10: Tab Key, Bottom 10

• School: SUNY Albany
• Department: Information Technology Management
• Course: B ITM 215 Information
• Professor: Ethan Sprissler

Document Summary

Itm 215 - lecture 10 - tables and conditional formatting: a table is a structured range of related data formatted to enable data management and analysis, excel tables offer many features not available to regular ranges. Table names in excel cannot contain spaces (blanks) Table name: add a new record within the table by clicking in the record below the. Adding records insertion point: click the home tab, click the insert arrow in the cells group, select insert table rows above. In the editing group on the home tab, click the find & select button, and then click find: type your search criteria in the find what box, and then click the find & select button. A structured reference is a tag or table field name used in a formula or function. Rather than using cell addresses, structured references can aid in formula creation and clarity. For example, the formula in cell j6 can be written as =[amount]-[down.