1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
sp2606 [1]
3 years ago
7

A worksheet contains sales dollars for agents with your company. The values are $1,250, $1,090, $985, $985, $880, $756, $675, $6

50, and $600. What function could be used to return the third largest value
Business
1 answer:
ivolga24 [154]3 years ago
7 0

Answer:We use the Large Function. the general formula is  =LARGE(first cell:last cell,3) .Please refer to the explanation section for details

Explanation:

Let us assume

A 1 = $1,250,  A 2 = $1,090, A 3 = $985, A 4 = $985, A 5 = $880, A 6 = $756, A 7 = $675, A 78= $650, and A 9 =$600

Using the Large function on excel to return the third largest value, on the formula bar we have the following formula;

=LARGE(A1:A2,3)

You might be interested in
Which organization or agency assists the fire department by alerting the public of traffic incidents or evacuations?
MariettaO [177]

Media is the organization or entity that would help the fire department with incident scene security, crowd control, and explosives disposal.

Law enforcement is the organization or entity that would support the fire department with incident scene security, crowd control, and explosives disposal. Law enforcement forces respond to emergencies around the clock and operate under a paramilitary command structure. In most traffic situations, officers act alone and are taught to make unilateral command judgments. Fire and rescue services respond to emergencies around the clock and follow a well-defined command structure on the scene. The core constituency of traffic incident management consists of eight key disciplines: law enforcement, fire and rescue, emergency medical, transportation, towing and recovery, hazardous materials cleanup, public safety communications and dispatch, and traffic reporting.

Learn more about Law enforcement here:

brainly.com/question/28344001

#SPJ4

3 0
1 year ago
First National Bank charges 11.1 percent compounded monthly on its business loans. First United Bank charges 11.3 percent compou
Ronch [10]

Answer:

First National Bank's EAR is 11.68%

First United Bank's EAR is 11.62%

Explanation:

Effective annual rate=(1+APR/m)^m-1

APR is the  annual rates given in the question as 11.1% and 11.3%

m is the number of times in the year that compounding is done, for instance, it is 12 for monthly compounding and 2 for semiannual compounding

First National Bank's EAR=(1+11.1%/12)^12-1=11.68%

First United Bank's EAR=(1+11.3%/2)^2-1=11.62%

The EAR for First National Bank is higher

6 0
3 years ago
A growing perpetuity is currently valued $6,225.81. The next annuity payment will be $386 and the discount rate is 9 percent. Wh
viva [34]

Answer:

2.8%

Explanation:

The formula to calculate value of a perpetuity is as follow:

V = Annuity payment in year 1 / (r-g)

V: Value of the perpetuity

r: Discount rate

g: Growth rate (missing value)

By inputting numbers into the formula, we have:

6225.81 = 386 / (0.09 - g)

--> g = 2.8%

3 0
3 years ago
When planning a procurement, it is useful to ______________.
Gre4nikov [31]

Answer & Explanation: When planning a procurement, it is useful to at least conduct a make or buy analysis which aids in determining the most cost effective approach, to consult and liaise with in-house experts in the departments of procurement, human resource, and legal, and also to insure the sponsor of the project signs off on the procurement plan. The goal of procurement planning is to increase the transparency and predictability of the procurement process while also deciding on what to buy, when and from what source.

5 0
3 years ago
The term __________ refers specifically to geologic mountain building.
White raven [17]
'Mountain formation' or 'orogeny'
4 0
3 years ago
Other questions:
  • Which of the following statements is CORRECT?
    9·1 answer
  • Juan works at Texas Burgers in El Paso and earns $8.00 per hour. His twin brother Felipe works in Mexico Burgers in Ciudad Juare
    14·1 answer
  • At Spyglass Inc., a private eye firm, new hires are chosen with utmost care. The reputation of the company is to provide clients
    13·1 answer
  • Which of the following is an example of an import quota​? The United States​ _____ . A. puts a 10 percent tax on auto part impor
    10·1 answer
  • Maurice has the following utility function: U (X Y) =20X+80Y-X^2-2Y^2, where X is his consumption of CDs with a price of ​$11 an
    9·1 answer
  • Under a system of floating exchange rates, changes in the value of the U.S. dollar relative to other currencies are the result o
    13·1 answer
  • Studies show that OSHA employees fail to properly inspect and regulate many workplaces, primarily because they do not have _____
    13·1 answer
  • Line Corporation's balance sheet showed the following amounts for their liability and stockholders' equity accounts: Current Lia
    7·1 answer
  • If the reserve requirement is 20% and commercial bankers decide to hold additional excess reserves equal to 5% of any newly acqu
    7·1 answer
  • Creating your own flyer assignment
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!