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
mestny [16]
2 years ago
7

you want to find the second-largest invoice in a column containing all the invoices in a given month. what function would you us

e?
Social Studies
1 answer:
algol132 years ago
7 0

To find the second smallest or largest number, we can use the functions LARGE or SMALL functions in Microsoft Excel.

<h3 /><h3>What is Excel in brief answer?</h3>

MS Excel is a generally used Microsoft Office application. It is a spreadsheet application that is used to store and examine numerical data.

First of all select the invoice column, use the functions LARGE or SMALL functions. Then these functions take quite a number of values, then the k value. If you use k value of 1, the LARGE characteristic is precisely like a MAX: = LARGE(B2:B100,1).

Thus,The actual value in LARGE is the capacity to ask for the second biggest value using = LARGE(B2:B100,2).

Learn more about Excel here:

brainly.com/question/25879801

#SPJ1

You might be interested in
The Supreme Court handles cases on appeal in all of the following ways EXCEPT:
Readme [11.4K]
Sending the case to a US court of appeals for a decision 
6 0
3 years ago
Read 2 more answers
?which scenario best illustrates the concept of a night terror?
Ad libitum [116K]
Example: Hector wakes up suddenly in great distress, his roommates asks him what is wrong but Hector cannot explain what happened.
7 0
4 years ago
African slaves were brought to the english colonies to meet demand for
andrew-mc [135]
African slaves were brought to English colonies to meet the demand for labor
5 0
3 years ago
What was a cause of urban migrations for the past 50 years?
Hatshy [7]
ABSTRACT. In developing countries like Ethiopia rural-urban migration affects socio –economic realities in both urban and rural areas. This study aims at identifying the major causes and consequences of the movement of people from rural to urban areas. ... However, most of them migrated decide to migrate not in planned way ...
7 0
3 years ago
Porque se hizo el trueque?
xz_007 [3.2K]

Answer:

Debido a la falta de dinero, el trueque se hizo popular en la década de 1930 durante la Gran Depresión. Fue utilizado para obtener alimentos y otros servicios. Se hizo a través de grupos o entre personas que actuaron de manera similar a los bancos. Si se vendiera algún artículo, el propietario recibiría crédito y se debitaría la cuenta del comprador.

Explanation:

English:

Due to lack of money, bartering became popular in the 1930s during the Great Depression. It was used to obtain food and various other services. It was done through groups or between people who acted similar to banks. If any items were sold, the owner would receive credit and the buyer's account would be debited.

8 0
3 years ago
Other questions:
  • Why did thousands of african american slaves sign on with the british army?
    8·1 answer
  • In triangular trade, what was carried from colonies in the Americas to Europe?
    10·1 answer
  • How does planned socialization differ from natural socialization?
    8·1 answer
  • Which nation was more at fault (Spain, France, and England)
    15·1 answer
  • The English Bill of Rights is most important because
    10·1 answer
  • Tony is a charming and manipulative man with an ambition to become rich and powerful. He uses his charm and manipulates rich wom
    14·1 answer
  • Help me ASAP
    14·1 answer
  • What religion was practiced in the massachusetts bay colony?
    14·1 answer
  • In problem solving, the term rule of thumb refers to __________.
    13·2 answers
  • What is the difference between the seven wonders of the world and the natural wonders of the world?
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!