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
Liula [17]
2 years ago
9

The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identificat

ion number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year.2 Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions.
Mathematics
1 answer:
zhannawk [14.2K]2 years ago
8 0

Answer:

Total sales revenue use  excel function : ( SUMIF. =sumif(range, criteria, [sum_range] )

For each of the stores: Use excel function: For Store 1: =sumif(B4:B99,1,I4:I99) then repeat same for Store 2 to store 8

Step-by-step explanation:

To modify the spreadsheet to calculate the total sales revenue we will add a column " sales revenue "

multiply values of column : ( unit sold * unit price )  to get Total sales revenue. then use  excel function : ( SUMIF. =sumif(range, criteria, [sum_range] ) to find Total sales revenue

calculate the total revenue for each of the 8 stores using a pivot table using  "store identification number" in row  and " sales revenue " in values field

To get the sales revenue ; replace " store identification value" with sales region " column

You might be interested in
<img src="https://tex.z-dn.net/?f=%5Csqrt%7B29-12%5Csqrt%7B5%7D" id="TexFormula1" title="\sqrt{29-12\sqrt{5}" alt="\sqrt{29-12\s
SSSSS [86.1K]

\sqrt{29 \:  -  \: 12 \sqrt{5} }

  • Factor the indicated expression:

\sqrt{(3 \:  -  \: 2 \sqrt{5}) ^{2}  }

  • Simplified the index the root and also the exponent using the number 2.

\boxed{ \bold{2 \sqrt{5}  \:  -  \: 3}}

<h3><em><u>MissSpanish</u></em> </h3>
6 0
1 year ago
Read 2 more answers
Which statement about these two sandboxes is true?
adell [148]
A would be the answer
5 0
3 years ago
If sin theta = 4/5 then sec theta is?
Softa [21]
Answer: 53.13
Explanation of answer: since theta is the unknown, then you must use the inverse of sin. (Which is sin with -1 subscript) I used a calculator and used inverse of sin and put 4/5 in parenthesis

6 0
3 years ago
The graph shows f(x)=(1/2)and its translation, g(x).
san4es73 [151]

The translation of four units up describes the transform function g(x) option first is correct.

<h3>What is a function?</h3>

It is defined as a special type of relationship, and they have a predefined domain and range according to the function every value in the domain is related to exactly one value in the range.

The question is incomplete.

The question is:

The graph shows f(x)=(1/2)ˣ and its translation, g(x).

Which describes the translation of f(x) to g(x)?

  • Translation of four units up
  • Translation of five units up
  • Translation of four units to the right
  • Translation of five units to the right

The graph is attached please refer to the picture.

We have the equation of the function f(x):

\rm f(x) = (\dfrac{1}{2})^x

From the graph, we can see the graph of the function f(x) is shifted up 4 units because the y-intercept of the graph g(x) is (0, 5)

g(x) = f(x) + 4

\rm g(x) = (\dfrac{1}{2})^x + 4

Thus, the translation of four units up describes the transform function g(x) option first is correct.

Learn more about the function here:

brainly.com/question/5245372

#SPJ1

6 0
2 years ago
1.667 + 1.483 + 1.483 + 1.451 + 1.381
koban [17]
7.465

You could have saved some points and used a calculator! XD
6 0
3 years ago
Read 2 more answers
Other questions:
  • Please help me asap!!
    10·1 answer
  • max lost 23 pounds while on a diet. he now weighs 184 pounds. write and solve an equation to find his initial weigh w
    6·1 answer
  • The smaller of two numbers is one-half the larger, and their sum is 27. Find the numbers. I need an answer in 10 minutes
    14·1 answer
  • Ocean waves move in parallel lines toward the shore.
    12·1 answer
  • the weight of an elephant is10.3 times the weight of a cat. if the elephant weighs 14,000 pounds, how many pounds does the cat w
    15·2 answers
  • What is the measure of
    14·2 answers
  • Acceleration of a runner who goes from 1.4 m/s to 2.2 m/s in 4 s
    13·1 answer
  • Anyone know the sqrt(-25) <br> It would be 5i right?
    5·1 answer
  • Ms. Marcus purchased 5 pounds of grapefruit for $4.90. At this price how much will 7 pounds of grapefruit cost?
    5·1 answer
  • What is the density of the oak board, it's 5.5 inches wide, 1.5 inches thick , 3 feet long and weighs 8.05 lbs? Please show work
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!