The purpose of an AVERAGEIF function is to help one find the average of numbers that meet a certain criteria within a dataset.
<h3>What does an AVERAGEIF function do?</h3>
The full question is not provided so the best I can do is to provide a general overview.
An averageif function is available in spreadsheets and is used to find the average of numbers in a range of data that meet a certain criteria.
For instance, if you want to average the budget amounts for Action movie projects, a relevant formula would be:
= AVERAGEIF(Projects, "Action movie", Projects[Budgets])
Find out more on the Averagif function at brainly.com/question/19595618.
Answer:
d. reduction in the volume of sales if the price is forced down and an increase in the volume of sales if the price is forced up.
Explanation:
When government implements price controls it can either be a price ceiling ( reduced price) or a price floor (increased price).
A price ceiling gives a maximum price level above which sellers cannot sell their product. This will cause a reduction in amount supplied because the sale of products at lower price will not be attractive. Demand will be in excess for the scarce products.
If a price floor is imposed there is a minimum price that sellers are not allowed to sell below. Sellers are free to sell above this price, supply will increase but there will be less demand for the product at higher price. This causes excess of supply.
Answer
Sales tax Payable = $780
Entry to record transaction is:
Dr: Cash $16,380
Cr: Sales Tax Payale $ 780
Cr: Sales $ 15,600
Explanation:
Coghlan Auto Supply sales are inclusive of tax so at first step it is necessary to segregate sales tax from the total sales of $16,380.
In order to calculate sales tax in Coghlan total sale divide the total sales figure with 1+the sales tax rate i.e (1+5%=1.05)
So the sales exclusive of tax will be: $ 16,380/1.05 = $15,600
Tax can be calculated now by subtracting Net sales by gross sales i.e $16,380-$15,600 = $780.
Answer:
The payment will be approximately at the end of 5 Years of $27,764.28, so option a is the correct one
Explanation:
In order to calcualte The exchange rate at the end of five years is we have to use the following formula:
= 7.0305 * {(1+ interest rate in Norway)/(Interest rate in US)}^5
= 7.0305 * [(1.031)/(1.026)]^5
= Nkr 7.2035 / $
= $1/7.2035 / Nkr
= $0.1388 / Nkr
Henche, The payment to be recieved at the end of 5 years will be NKr 200,000, therefore the value of the payment in dollars is = $27,764.28
This scenario illustrates that the company is aiming at fulfilling its <u>"discretionary responsibility".</u>
The discretionary responsibilities of companies allude to society's desire that associations be great residents. This may include such things as altruistic help of projects profiting a network or the country. It might likewise include giving worker aptitude and time to admirable motivation.
Discretionary responsibility, it is best depicted by the assets contributed by organizations toward social, instructive, recreational as well as social purposes.