Ch5ClassNotes exam 3

Ch5ClassNotes exam 3 - Chapter 5: List Management Chapter...

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

View Full Document Right Arrow Icon
Chapter 5: List Management Chapter Skills Understand and apply the critical guidelines for list development that enable the automatic Excel list features to work correctly. Freeze panes to view column or row headers for all rows of list data. Apply data validation to new data entries of a list. Sort data rows by one column. Sort data rows by multiple columns. Create custom lists to support Data Validation, Sorting, and AutoFill features. Filter a list using the AutoFilter feature. Add subtotals to a list using the Subtotals command or the Subtotals function. Write formulas that involve multiple worksheets and/or multiple workbooks. Import delimited data into Excel. Use formulas and functions to "clean" or "scrub" imported data. Use an Excel "Table" to manage list data. Move or copy worksheets from one workbook to another. Chapter Vocabulary Excel "list" (of data) a record an attribute field (2 meanings) Excel "Table" feature data validation sort "custom" list Excel "Freeze Panes" feature delimited file formats and common delimiters "3-D" formulas "cleaning" or "scrubbing" imported data Web Query Web table Introduction to List Management 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
Critical List Guidelines: 1. 2. 3. 4. Chapter Demonstration 1: Importing Delimited Formats into Excel A. Import a comma delimited file into Excel. 1. Open the file “ Animal.csv” file in Notepad (Right-click on the file Open With Notepad). Note that commas are separating the fields of each row of data. A carriage return indicates the end of a row of data. Close the Notepad file. 2. Open the “Animal.csv” file in Excel in one of the following ways: a. Open Excel, then open the file from inside Excel. b. Right click on the file, choose Open with Microsoft Office Excel c. Double click on the file. (When Excel is available, it is the default application for opening a .csv file.) 3. Improve the Animal list in Excel by doing the following: a. Make sure the values in the DateBorn column are recognized by Excel as dates (they may already be). If needed, select the column and apply a date format. Format that column header to General or Text format. b. Format the entire column header row to distinguish it from the data rows. c. Auto-size all the columns at once to fit the data. 4. If the worksheet name does not appear as "Animal", rename the worksheet to that name. 5. Save the workbook with an Excel file name of your choice. Use the default Excel file extension since this file does not need to support macros. B. Import special number fields as text data type. 1.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/15/2011 for the course ACIS 2504 at Virginia Tech.

Page1 / 9

Ch5ClassNotes exam 3 - Chapter 5: List Management Chapter...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online