Login / Signup

Question

What does the AVERAGEIF function do in Excel?

A Calculates the average of a range of cells that meet specified criteria

B Returns the average of the smallest values in a range of cells

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

D Returns the average of the largest values in a range of cells

E None of these

Practice Next

More MS Office Questions

Which function key displays the Print Preview window in Microsoft Office applications?
Which of the following shortcut key is used for print preview?
Which of the following is a valid data type in MS Excel?
In Microsoft PowerPoint, which view is most suitable for reordering slides and seeing an overview of the slide sequence?
How can you apply a pre-designed set of formatting options to a Word document?
Which of the following file extension denotes Microsoft Power Point Presentation
Which of the following software is generally preferred most, to create a tabular sheet to store marks scored by 100 students of a boarding house in the las...
In modern versions of Microsoft Word (2007 and later), what is the default file extension for saved documents?
How can you add a page border to a document in Microsoft Word?
The document can be zoom maximum upto

Relevant for Exams:

Hey! Ask a query

ask-question