Which Excel function averages cells in a range based on a specified condition?

A. AVERAGEIF
B. AVERAGE
C. COUNTIF
D. SUMIF

Answer: A

Computer Science & Information Technology

You might also like to view...

Column headings begin with 1 and end with 1048576.

Answer the following statement true (T) or false (F)

View
Computer Science & Information Technology

In the ________ method, the mouse is used to move a selected cell or a range of cells to a new location

Fill in the blank(s) with the appropriate word(s).

View
Computer Science & Information Technology

COGNITIVE ASSESSMENT IBM, Microsoft, Novell, RedHat, Sun, and others offer certifications that test knowledge of what?

A. operating systems B. application design C. networks D. web development

View
Computer Science & Information Technology

The Windows utility program that removes unnecessary files from the hard drive is called ________.

Fill in the blank(s) with the appropriate word(s).

View
Computer Science & Information Technology