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

Info icon This 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.
Image of page 1

Info icon This 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 ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern