The function used to calculate the average of cells specified by a given set of conditions is ________

A) AVERAGEIFS
B) AVERAGE
C) CRITERIA
D) AVERAGEIF


Answer: A

Computer Science & Information Technology

You might also like to view...

Give an example of a schedule that is strict but not serializable.

What will be an ideal response?

Computer Science & Information Technology

Case-Based Critical Thinking QuestionsCase 5-1Ethan would like to minimize his efforts in the development of his Web site. Kyra is ready to help him apply a variety of background properties.Ethan would like to use a background-image property to emphasize some headings, but he does not know which software he can use to develop that image. Kyra advises Ethan to use all of the following EXCEPT ____.

A. Adobe Photoshop B. GIMP C. Microsoft Word D. Microsoft Expression Design

Computer Science & Information Technology

Harry, a bank employee, is using Excel to carry out loan payment calculations. He wishes to change the column containing interest rates to an absolute reference. Which of the following keys should Harry use to change the reference to an absolute reference for a selected cell or range??

A. ?Alt+R B. ?F4 C. ?Shift+PgDn D. ?F1

Computer Science & Information Technology

What are the purposes of the AccessController class?

What will be an ideal response?

Computer Science & Information Technology