PIT Spring Final Exam

What is used to name each cell? (Ch 10)

• worksheet name and row

• column and row

• numbers

• letters

What determines the meaning of data entered in a cell? (Ch 10)

• value

• format

• filter

• data type

Which of the following is not a common formatting for numbers in a spreadsheet? (Ch 10)

• currency

• dates

• absolute

• fractions

When more than one cell is selected, the selection is called a(n) _____ of cells (Ch 10)

• Dan Bricklin

• right

• range

• ####### (or several pound signs)

• sheet. search (or find)

What are the values the function needs for the calculation called? (Ch 11)

• pieces

• arguments

• addresses

• logicals

Which of the following is not a logical function? (Ch 11)

• NOT

• IF

• MIN

• AND

How is the Insert Function dialog box displayed? (Ch 11)

• Formulas>Function Library>Insert Function

• Insert>Formulas>Functions

• Formulas>Functions>Insert

• Insert>Functions

What determines the meaning of data entered in a cell? (Ch 10)

• value

• format

• filter

• data type

Which of the following is not a common formatting for numbers in a spreadsheet? (Ch 10)

• currency

• dates

• absolute

• fractions

Which of the following is not included in a letterhead?

• Company name

• Date

• Address

• Logo