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?

How to open VBA coding pane?

What does the Mod function do in an equation?

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.

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

The range of cells receiving the content of copied cells is called the ____.