{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Test 2 notes.docx - Data a simple raw fact about a person...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Data - a simple raw fact about a person, place, or a thing. Stored in its smallest usable unit. Information - data that has been manipulated, processed, and rearranged to be useful or meaningful 3 methods of taking data and turning into information: 1. Sorting - putting it in some kind of order 2. Filtering - selecting out data that meets certain criteria 3. Calculation - calculate with data through formulas and functions Tables store data on a single entity Tables are made up of records (rows of the table). Record (rows) stores data on a specific occurrence of the entity. Records are made up of fields Fields (columns) are a characteristic or attribute of the entity Header rows have to be formatted differently than records Unique fields require that each record have a different entry in that field. Duplicates are not permitted from record to record. Non-unique field - duplicates are permitted from record to record Sort fields - can be unique or non-unique Record layout – the tables you have, and the fields they’re in Excel’s rules for creating tables – only one table per worksheet, blank row above/below table unless starting at row 1, no blank rows or columns within table, header row must have different formatting and be unique. Excel’s rules for creating fields – enter data in its smallest useful unit, store data that requires least amount of maintenance, if numbers are not gonna be used in calculation, should be formatted as text Subtotals can be a: sum, max, min, average, count. Must sequence grouping field before. Subtotals cannot be inserted in an Excel table. Advanced filter - connect criteria using an “or” instead of an “and”. Able to create “copy to” ranges and copyout the matching record, with the ability to copyout important fields and make them easier to understand. 1. Copy the header row from the table 2. Put in the values under the new header row that you want filtered in the initial table 3. “Or”s - different row, “and”s - same row 4. Repeat the field name if you need an upper and lower boundary 5.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

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

{[ snackBarMessage ]}