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?

Which of the following is an absolute cell reference?

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.

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

Functions can be selected by using the ________.

A ____ total sums all of the data in a row or column.