# Shared Flashcard Set

## Details

Excel Chap 2
Chap 2
28
02/10/2012

Term
 Ctrl ↑   Type A1 in Name Box
Definition
 Home
Term
 Ctrl ↓
Definition
 End of Sheet
Term
 Includes all of the entities of interest
Definition
 Population
Term
 A subset of a population
Definition
 Sample
Term
 Usually a rectangular array of data, with variables in columns and observations in rows
Definition
 Data Set
Term
 A characteristic of members of a population Ex. Height Gender Salary
Definition
 Variable (or field or attribute)
Term
 A list of all variable values for a single member of a population
Definition
 Observation (or case or record)
Term
 Types of Data
Definition
 Numerical and Catagorical
Term
 A variable in which meaningful arithmitic can be performed
Definition
 Numerical
Term
 A variable in which meaningful arithmitic can NOT be performed
Definition
 Categorical
Term
 If a categorical variables value has natural ordering
Definition
 Ordinal
Term
 If categorical variables values do not have natural ordering
Definition
 Nominal
Term
 0-1 Coding for a catagorical variable
Definition
 Dummy Variable
Term
 When a numerical variable has been catagorized into discrete catagories
Definition
 Binned
Term
 A numerical variable that results from a count   Ex. Number of Children
Definition
 Discrete Variable
Term
 Result of a continuous measurment   Ex. Weight and Height
Definition
 Continuous Variable
Term
 Data on a cross section of a population at a distinct point in time
Definition
 Cross-sectional Data
Term
 Data collected over time
Definition
 Time Series
Term
 What is the difference between Relative and Absolute formulas?
Definition
 The \$   If the \$ sign is next to the cell referenced it will become Fixed or Absolute      NO \$ added to the cell reference it will be Relative
Term
 To Drop Down Text to the next line in a cell
Definition
 Alt Enter
Term
 To define, delete or change a name of a cell or a range highlight and go to the __________ tab, then ____________ and __________
Definition
 Formulas Name Manager Edit, delete or new
Term
 False gives ________   True gives ________
Definition
 Exact   Approximate
Term
 In the formulas argument a (      ) means that something is _______
Definition
 Required
Term
 In the formulas argument a [        ] means that something is _______
Definition
 Optional
Term
 _____ look up is Vertical   _____ look up is Horizontal
Definition
 V Look up   H Look up
Term
 Provide one input and get multiple outputs
Definition
 One way Data table
Term
 Provide two inputs and get one output
Definition
 Two Way Data table
Term
 =Now() gives you?   &   F2 gives you?
Definition
 Current Date & Time   Updated Date & Time
Supporting users have an ad free experience!