google app store

apple app store

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

A company purchased machinery for ₹10,00,000 on 1 April 2021. The machine has a useful life of 5 years, and depreciation is charged using the straight...
In a public sector undertaking (PSU), a 'Reasonableness of Price' certificate is often required for purchases to:
Which of the following is NOT a motive for acquisitions?
As per Schedule III of Companies Act, which of the following is not shown under ‘Other Current Liabilities’?
Which Act in India regulates the negotiation and transfer of negotiable instruments such as promissory notes, bills of exchange, and cheques?
As per the Companies Act, 2013, the audit committee shall have powers:

(i) to investigate any activity within its terms of reference

(ii) ...
In relation to the Accounts of Insurance Companies, which of the following statements are correct?

(i) Re-insurance means the transfer of a part ...
A 'Rights Issue' of shares is an offer made to:
A company expected material cost to be ₹50 per unit for 1,000 units. Actual cost was ₹55 per unit for 950 units. What is the material cost variance?
Which conditions must be met for a third party’s customer due diligence to be accepted by an RE?

Relevant for Exams:

ask-question