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
QUESTION:
Elan Coil [88]

Answer:

b.

Step-by-step explanation:

6 0
2 years ago
Fire Fighters are attempting to rescue people from the 3rd floor of a building. The
Daniel [21]

Answer:

If it's where they can get to the building I think it's 15

Step-by-step explanation:

Cause 10 plus 5 and if that can reach where they are able to get in I'd assume it would be 15

I'm not a genius or anything so don't rely on my answer

7 0
2 years ago
Is y = 0.860x + 3.302 a linear function?
gulaghasi [49]

Answer:

yes

Step-by-step explanation:

Yes.  The given function has the form y = mx + b, which is that of a linear function.  Here the slope, m, is 0.860, and the y-intercept is 3.302.

8 0
3 years ago
A triangle has side lengths of 12 inches 14 inches, and 18 inches. What best represents the perimeter of the triangle in centime
kotykmax [81]

Answer:

111.76 cm

Step-by-step explanation:

The formula for the perimeter of a triangle is given as:

Side A + Side B + Side C

Since our final answer is going to be in centimeters we have to convert the sides from inches to centimeters

Hence:

1 inch ~ 2.54 centimeters

For 12 inches

1 inch = 2.54 cm

12 inches = x

Cross Multiply

x = 12× 2.54 cm

x = 30.48 cm

For 14 inches

1 inch = 2.54 cm

14 inches = x

Cross Multiply

x = 14× 2.54 cm

x = 35.56 cm

For 18 inches

1 inch = 2.54 cm

18 inches = x

Cross Multiply

x = 18× 2.54 cm

x = 45.72 cm

Hence, the perimeter of the triangle

= 30.48 cm + 35.56 cm + 45.72 cm

= 111.76 cm

4 0
2 years ago
Evaluate f(x) = -2x square Root -4 for x=3
lesya [120]

Answer:

Step-by-step explanation:

f(x)=-2x(sqrt(-4))

-2(3)sqrt(-4)

-6(2i)

-12i

8 0
3 years ago
Other questions:
  • Solve the equation.<br> 1. -66 = -9n+ 16 + 4<br> n = 4<br> b. n = 10
    14·2 answers
  • Given: T is the midpoint of JK¯¯¯¯¯JK¯, JK = 5x – 3, and JT = 2x + 1. Determine the length of JK¯¯¯¯¯JK¯
    6·2 answers
  • Help me I don't know what is 10=n+19​
    12·2 answers
  • At a clothing store sale, a shirt costs
    8·1 answer
  • Solve the problem below.
    6·1 answer
  • A store sells a package of 25 trading cards for 5.25. What is the cost of one trading card
    6·2 answers
  • Identify whether the following items best fit with a discrete or a continuous model. Then determine whether it is a linear (arit
    11·1 answer
  • Nine dollars each hour
    6·2 answers
  • PLSSS HELPP FOR 150 POINTS NO JOKE CAN EVEN SEND U 50 MORE IF U HELP
    10·1 answer
  • The children's section is rectangular and has three of its corners at (-10,10), (-10,4), and (-3,10). What are the coordinates o
    6·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!