Advanced Functions

Formulas can be copied to adjacent cells with the ____________.

• Fill handle

• PgDn Key

• Function key F4

• None of the above

__________________is an alphanumeric value used to identify a specific cell in a spreadsheet.

• Formula

• Calculation

• Cell address

• None of the above

Multiple arguments must be separated by a ______________.

• Space

• Comma

• = Sign

• !

Which formula would you use to calculate how many sales are over $20 from a series.

• sum

• sumif

• count

• countif

Use a count function to count the number of grades greater than 70 in cells B4:M4. What function should you use?

• COUNTIF

• COUNTA

• COUNTBLANK

• COUNTIFS

Calculates a sum from a group of values, but just of values

that are included because a condition is met.

• COUNTIF

• SUMIF

• AVERAGEIF

Counts the number of cells in a range that match a

criteria

• COUNTIF

• SUMIF

• AVERAGEIF

Which symbol must all formula begin with?

• =
• +
• (
• @

What does the Counta formula return?

• Counts the number of cells within a range that meets the given condition.

• Counts the number of cells in a range that are not empty.

• Counts the number of columns within a range that meets the given condition.

• Counts the number of columns in a range that are not empty.

If you have a table of ticket sales and you want to know the total amount sold to customers that were 18 or older, which formula would you use?

• IF

• COUNTIF

• SUMIF

• AVERAGEIF