Study Guide Test 3 Data Management 260

# Study Guide Test 3 Data Management 260 - I T 260 Test #3 M...

This preview shows pages 1–4. Sign up to view the full content.

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

View Full Document

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

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

Unformatted text preview: I T 260 Test #3 M ateri a l Covered: Excel 2007 Perspectives: Tutori a ls 5-8 Format: 100 points Multiple Choices (2pts Each) F i l l in the Blanks (2pts Each) I tems that you need to know: Bold Terms from the tutorials Review Quick Check Questions Excel Tables, Pivot Tables, and Pivot Charts Field = Column Row = Record Data Definition Table = Field Properties List Freezing Rows Structured Range of Data = Table Total Rows Table Names Sorting Data Ascending Order AtoZ. StoL, OtoN Decesending Order ZtoA, L toS, N toO Multiple Sort Fields Primary, Secondary.... 64 Fil tering Data Pivot Tables- Summarizes Table data based on functions such as Count Sum Average, Max Pivot Chart Worksheet Groups 2 or more worksheets acts together as if one worksheet. 3-D Referencing same cell or range of cells in multiple worksheets in the same workbook. Linked Workbooks Source File Destination File External Reference Hyperlinks Templates Saving a Workbook as a Web Page HT M L (Hypertext Markup Language) Creating Fields in a Table Page 339 IF Function IFAND Function IFOR Function Structured References Nested IF Functions VLOOKUP Function H LOOKUP Function Lookup Table Lookup Values Exact Match vs. Approximate Match IFE r ror Function Er ror Values Page 365 Count IF SUMIF AVERAGEIF Criteria Ranges Excel Application: Reports Way to enter data in a controlled way. In terface with Excel Customizations Defined Names InSight Page 397 - Why use a Defined Name Data Validation Workbook and Worksheet Protection Comment Boxes Macros T rust Center VBA ...
View Full Document

## Study Guide Test 3 Data Management 260 - I T 260 Test #3 M...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online