Exam 19: Using Powerful Excel Functions

Figure EX 13-1 In Figure EX 13-1 above, item 2 points to Amount, which is the ____.

Case EX 13-2 Gregory works for the local public television station. The station has recently held a TV pledge drive and they have received a large number of pledges from viewers and businesses. The data about the pledge drive is stored in a worksheet. The worksheet has six columns: First Name, Last Name, Address, Phone, Pledge, Received. The Received column contains "Yes" or "No" values depending on whether the amount pledged has been received by the station. If Gregory wants to find out the total amount of money that has actually been received by the station, he needs to use the ____ function.

The function number ____ calculates AVERAGE.

If you want to use a name range with two words, you will need to use a(n) ____ to separate the words.

The ____ function is used to total only cells that meet a certain condition.

You select a named range by clicking the ____ down arrow and then selecting the named range.

Case EX 13-1 Kim is a photographer. To supplement her income, she also teaches a basic photography class in her studio. She uses an Excel workbook to keep track of information related to her class. The columns in her worksheet are: Student Name, Address, Phone number, Fees, Fees Paid. To find out the number of students in her class based on the Student Name column, she can use the ____ function.

After data is filtered, only the cells for the item you filtered will be displayed; the other cells will be hidden.

You can count numerical data in a range using the ____ function.

To count the number of cells without content, you will use the ____ function.

Case EX 13-1 Kim is a photographer. To supplement her income, she also teaches a basic photography class in her studio. She uses an Excel workbook to keep track of information related to her class. The columns in her worksheet are: Student Name, Address, Phone number, Fees, Fees Paid. When Kim was reviewing her worksheet, she realized that some of the addresses are missing. To find out the number of students for whom she doesn't have an address, she needs to use the ____ function.

Using the COUNT function lets you count only cells that are displayed.

The function number 5 calculates SUM.

After you name a range, Excel remembers that name.

To count cells with text, you use the ____ function.

You use the HLOOKUP function when the lookup table is listed vertically in columns.

To use the HLOOKUP function, you will need the row number from the table that has the data you want returned to the cell with the HLOOKUP function.

____ functions allow you to find data that already exists rather than looking for the data yourself.

Case EX 13-2 Gregory works for the local public television station. The station has recently held a TV pledge drive and they have received a large number of pledges from viewers and businesses. The data about the pledge drive is stored in a worksheet. The worksheet has six columns: First Name, Last Name, Address, Phone, Pledge, Received. The Received column contains "Yes" or "No" values depending on whether the amount pledged has been received by the station. From only the pledges which have been received, Gregory wants to find out the average amount pledged. He can first filter the data and then use the ____ function.