OMIS-Excel Notes-Linda's

Filtering a list is easier and less time consuming

Info iconThis preview shows page 1. Sign up to view the full content.

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

Unformatted text preview: off the list • All groups MUST be formed by October 4! – – OMIS2000- Week 4: Quantitative Data Analysis Approaches; Gathering, Collecting and Organizing Data Table/List One thing that we see pretty much every Excel user doing with some frequency is working with tables/lists. Tables/lists can mean different things to different people so let us briefly define what we think of when we use the words table/list. • A list is a collection of data arranged in columns and rows. • Each column of a list is called a field. • Each row is called a record. • The first row in a list is called the label row and helps in identifying each column. Example: Sales spreadsheet Entering Data • Begin by creating a column (with labels for column headings) for each field • Adding a record is as simple as typing in another row • You can always work directly with the data as entered, but sometimes it is advantageous to formally define the range as a TABLE in Excel (we will do this later today…) Error Management - Data Validation 34 Excel Notes Jessica Gahtan OMIS2000 Specify and correct the kind of data that can be entered Specify an input message alerting users when they click a cell that only specific types of data can be entered in that cell • Specify error messages, which appear when others persist and attempt to enter incorrect data Data validation enables you to control the data that can be entered into a cell. It warns and prevents people from entering “wrong” data in a cell. Figure 8.25 displays the Data Validation dialog box and the Settings tab. • • • Specify the type of data that a user can enter, display an input message specifying a message, and display custom error messages when users enter invalid data. • To specify data validation criteria, click Data Validation in the Data Tools group on the Data tab...
View Full Document

This note was uploaded on 03/28/2014 for the course OMIS 2000 taught by Professor Hk during the Fall '13 term at York University.

Ask a homework question - tutors are online