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

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

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

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?

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

Which character denotes a text entry?

A table name cannot include ____.

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

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

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

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