In the following formula: =if(a1=""yes"", ""done"", ""restart""), what happens if a1= no? _____

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

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) _______.

Which of the following is an absolute cell reference?

Which character denotes a text entry?

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?