1.Within Excel spreadsheets, the ______ function would be a form of querying.

Multiple Choice

• VLOOKUP
• SUM
• COUNT
• IF

2.Sales figures would be considered to be examples of __________ data.

• categorical
• interval
• ratio
• ordinal

3.The name of each patient at a doctor's office would be an example of a __________.

• data item
• record
• row
• field

4.If we run a regression wherey(bankruptcy) =f(factors potentially predicting bankruptcy), what is the dependent variable?

• Bankruptcy
• Factors potentially predicting bankruptcy
• There are no dependent variables
• Cannot be determined

5.Within an Excel pivottable, the ________ settings determine whether the pivottable will report counts, sums or averages.

• descriptive
• summary
• statistics
• value field

6.Since AssetID is a number identifying assets in a fixed asset ledger, it would be considered to be __________.

• categorical data
• numerical data
• ratio data
• ordinal data