Excel Review(formulas, lookups, formattings)

Which response best completes the following statement: A formula is used to?

• perform calculations or other actions.

• find averages.

• locate a cell

One of these is a type of validation

• Hardware

• Emotional

• List

• Spreadsheet

Validation makes sure that data is

• Correct

• Suitable

• Nonsense

• Numerical

Verification is checking the data is

• Secure

• Correct

• Suitable

• From a list

A text length validation of up to 10 characters will not accept:

• Timothy

• Timothy James

• Jamie

• Paula

Why is Validation useful

• It makes sure all the data is correct

• It keeps data secure

• It prevents errors typing data in

• It keeps the data up to date

In VLOOKUP, the column # refers to the column in the:

• table array

• worksheet

• workbook

• list

What is the correct formula for this?

• =HLOOKUP(A4, A1:F1,2, FALSE)

• =VLOOKUP(B4, A1:F1,2, TRUE)

• =HLOOKUP(A4, A1:F1,2, TRUE)

• =VLOOKUP(A4, A1:F2,2, FALSE)

What formula is used to find East_01?

• =HLOOKUP(A11, B1:B9,2, TRUE)

• =VLOOKUP(A11, A1:B9,2, TRUE)

• =HLOOKUP(A11, A1:B9,2, FALSE)

• =VLOOKUP(A11, A1:B9,2, FALSE)

The four arguments used in the VLookUp function are: Name of Item, _________, column index number, look for approximate match.

• range containing data
• Price of the item being looked for