Functions can be selected by using the ________.

A ________can retrieve data from multiple fields in different tables in the data model

You can ____ a table field if the information stored in a field becomes unnecessary.

One way to structure text files is to use a(n) _______.

The general format of a 3-d cell reference is ____.

A _______ is the cell containing the formula or value the selected cell refers to.

To show a '-' instead of a zero in cells with zero value, you must adjust the settings in what way?

Let's say that for 100 cells down column B, you have a dozen varieties of olives listed, some of them appearing multiple times. How can you use the COUNTIF function to find the number of times the Greek variety is listed?

Imported data appears entirely in column A. How do you separate the data into individual columns?

Which of the following formulas shows the correct syntax of a VLOOKUP() formula in the 3rd column?

A _______ is a predefined formula that helps perform common mathematical functions.