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]
3 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]3 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
6x+9+2x<br> What is the answer
slavikrds [6]

Answer:

6x+9+2x

Step-by-step explanation:

8x+9

hope it helps uh

7 0
3 years ago
Read 2 more answers
Plss answer my questions​
KIM [24]

Answer:

a) 450. b) 1:1.25 c) 32 rooms

Step-by-step explanation:

1. 100*4.5 = 450

2. 16:20 divide by 4 -> 4:5  (simplifies to 1:1.25)

3. 64/2 = 32 rooms needed. They have 16.

Sorry if answers are wrong, the picture quality is really poor for me.

8 0
2 years ago
Read 2 more answers
What Is the Answer To number 1 ?
DochEvi [55]

Answer: 4 apples for $3.64


Step-by-step explanation:

The best buy is going to be the one that costs the least. To figure this out, you divide the number of apples by the price. (do not round)

4/3.64=1.09

9/8.01=1.23

14/12.43=1.12

24/21.12=1.13

As you can see, the 4 apples for $3.64 is the better choice since the number is the least.

5 0
3 years ago
Anyone know 14!!!! ASAP
notsponge [240]
Word problem: Today the temperature dropped 13 °F. After this drop, the temperature was 74 °F. What was the original temperature outside before the drop?

Subtraction problem: x °F - 13 °F = 74 °F

Solve: x - 13 = 74
x - 13(+13) = 74 + 13
x = 87 °F
3 0
4 years ago
100 Points to whoever answers
Kisachek [45]

The average rate of the change from x = 2 to x = 5 is about 20 , The domain is constrained at x =0

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

A function is a mathematical statement used to derive a relation between a dependent variable and an independent variable.

A) The vertical axis of the graph shows a company's profit f(x), in dollars, depending on the price of pencils x, in dollars, sold by the company , i.e is the x axis .

So the x-intercepts represent prices of the pencil at which the profit is 0

and The maximum value of the graph represents the maximum profit that can be obtained for any price of the pencil.

The Profit is increasing from (x = 0 to 5) and starts decreasing from x =5 to 10

B) From the graph

(f(5) -f(2))/(5 -2) = (160-100)/3  = 20

The average rate of the change from x = 2 to x = 5 is about 20.

This indicates that the profit will increase at a an average rate of $20 for each $1 increase in price in that interval.

(C)The domain is constrained at x =0 as there it cannot be concluded that if the price is 0 , the profit will be 0 , and we are obligated to sell the pencil at x =6 , as the maximum profits are booked at that point.

To know more about Function

brainly.com/question/12431044

#SPJ1

5 0
2 years ago
Other questions:
  • A punch bowl had 2\dfrac122 2 1 ​ 2, start fraction, 1, divided by, 2, end fraction liters of juice in it. Liam drank \dfrac13 3
    8·1 answer
  • What is the answer to negative 16v+v=3v+2v
    7·1 answer
  • How do I solve P=2L+2W for L
    11·2 answers
  • Hannah is at the supermarket to buy carrots and potatoes. If she buys 2 pounds of carrots and 3 pounds of potatoes, it will cost
    10·2 answers
  • A race car driver won a 300 mile race with a speed of 194 miles per hour. Find the drivers time.
    9·1 answer
  • A rectangle has a width w that is 5 units longer than its length l. Which equation expresses the rectangle's area, A?
    14·2 answers
  • Solve for x: -x^2+5x+6=0
    13·1 answer
  • Dimensions of a building are 345 feet by 295 feet. If 1 inch represents 42 feet, what are the dimensions of the building on the
    15·1 answer
  • Write 336 mi in 11.2 h as a rate in simplest form
    12·1 answer
  • Consider a propeller driven aircraft in forward flight at a speed of 150 mph: The propeller is set up with an advance ratio such
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!