Quiz 1 - Advanced Spreadsheets

A drop-down list is a type of ... Using drop-down lists helps to keep the data in a spreadsheet ...

• alphabetical / accurate

• validation / accurate

• accurate / validation

• alphabetical / values

by eliminating ... errors and limiting the ... that can be entered into a ...

• cell/ values/typing

• values / cell / typing

• typing / values / cell

It is best practice for the data values to be in ... order. When setting up a drop-down list you must set the data validation type to ... and then select the ...of cells containing the values.

• range / alphabetical / list

• alphabetical / list / range

• range / list / alphabetical

What is the lookup value in a VLOOKUP function?

• The value that you want to be returned

• The range of cells containing all the values

• The value that you wish to search for

What order does the data the first column of the lookup table need to be in?

• any order

• ascending order

• descending order