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
olya-2409 [2.1K]
3 years ago
14

Once you have a listing of every unique combination of salesperson, product and location, what Excel function would you use to c

ompute the total sales for each combination of salesperson, product and location
Computers and Technology
1 answer:
andre [41]3 years ago
7 0

Answer:

SUMIFS

Explanation:

As we know that the excel is used to present the data in a very attractive way by applying the formulas, pie charts, functions as a pivot table, goal seeking, macros, etc

In order to determine the total sales for each and every sales person, production and location combination we use the SUMIFS function so that the total of each column could come in an easiest and better way

You might be interested in
Which of the following is a variable expense for many adults?
IRINA_888 [86]
<span>C. Their monthly rent payment.</span>
7 0
3 years ago
Read 2 more answers
Data entered in a cell will appear in the bar, found about the worksheet
Setler79 [48]

Answer:

formula bar

Explanation:

The formula bar in Excel is located next to the name box

and above the worksheet area. It displays the data stored in

the active cell. The formula bar is used to view, enter, and

edit values and formulas in cells.

3 0
3 years ago
The law that says you must submit to a test for the presence of alcohol or drugs is known as the
ELEN [110]
This is called<span> the "implied consent" </span><span>law</span>
7 0
3 years ago
Read 2 more answers
Which of the following events happened first?
horrorfan [7]

Answer:

D. ARPANET was developed

Explanation:

ARPANET is an acronym for Advanced Research Projects Agency Network and it was established in 1969 by the Advanced Research Projects Agency (ARPA) of the United States Department of Defense.

ARPANET was the first wide area packet switching network for transmitting electronic data and communications between computers on a single network with a distribution functionality. The TCP/IP protocol was first implemented on the Advanced Research Projects Agency Network (ARPANET), as well as some other standard protocols such as the NCP and the 1822 protocol.

The development of ARPANET happened first in the evolution of the internet.

E-mail is an acronym for electronic mail and it was invented by Ray Tomlinson in 1971; World Wide Web was created by Tim Berners-Lee in 1990; Web 2.0 evolved in 1999.

6 0
3 years ago
HELP PLZZ Which statement is true? Select 3 options.
Naily [24]

Answer:

B. C. E.

hope this helps :D

7 0
3 years ago
Read 2 more answers
Other questions:
  • An expression that has correctly paired delimiters is called a(n)
    6·1 answer
  • In 5-10 sentences, describe the purposes, design considerations, and common elements of most brochures.
    6·1 answer
  • If your problem is caused by a bad hardware or software installation and you get an error message the first time you restart the
    6·1 answer
  • What is the statement describing? Agile team continuously adapt to new circumstances and enhance the methods of value delivery
    6·1 answer
  • Hymter. Wants to workin The Energy career field with electrical energy
    15·1 answer
  • Name three output devices
    6·1 answer
  • What is essential to delivering a successful presentation?
    5·2 answers
  • Which statement describes what this command accomplishes when inside and outside interfaces are correctly identified for NAT? ip
    13·1 answer
  • Assume the user responds with a 3 for the first number and a 5 for the second number.
    13·1 answer
  • Pleaseee help me with the typical situations of the icons(i already know for words but I have no idea for giving the situations
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!