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
Which value of k makes the equation k\2 =10
Yakvenalex [24]
The answer is 20 I believe

8 0
3 years ago
Prove : (sec θ - tan θ )^2 = 1 - sin θ /1+sin θ
labwork [276]
(sec x - tan x)^2 \\  \\ = sec^2x - 2 sec x tan x + tan^2 x \\  \\ =(1+tan^2 x) - 2 sec x tan x +tan^2 x \\  \\ =1 - 2 sec x tan x + 2 tan^2 x \\  \\ = 1 - 2tan x(sec x - tan x) \\  \\ =1 - \frac{2 sin x}{cos x} (\frac{1-sin x}{cos x}) \\  \\ = 1 - \frac{2 sin x (1-sin x)}{cos^2 x} \\  \\ =1 - \frac{2 sin x (1-sin x)}{1-sin^2 x} \\  \\ =1 - \frac{2 sin x (1-sin x)}{(1-sin x)(1+sin x)} \\  \\ =1-\frac{2 sin x}{1+sin x}
3 0
3 years ago
Graphs of more than one function f(4)=<br> If g(x)=2,x=
Mamont248 [21]

Answer:

f(4)= 11

If g(x)=2, x=0

5 0
3 years ago
A net and four figures are shown: A net is shown on top. The net consists of 6 identical squares. There are 2 squares in a row,
Julli [10]
The net diagram could be a cube because a cube has 6 identical sides.
8 0
3 years ago
SOMEONE PLEASE ANSWER ASAP FOR BRAINLIEST!!!!!
Angelina_Jolie [31]
The formula is D=PT/F
3 0
3 years ago
Read 2 more answers
Other questions:
  • Which linear function represents the line given by the point-slope equation y + 1 = –3(x – 5)?
    7·2 answers
  • The scores of the students on a standardized test are normally distributed, with a mean of 500 and a standard deviation of 110.
    6·1 answer
  • Paul has just enough money to buy either 5 erasers and 30 pencils or 10 erasers and 24 pencils. Each eraser costs $0.30. How muc
    14·1 answer
  • I'm stuck. plz help I dont know how​
    9·1 answer
  • Please help, I beg of y'all <br><br>FIND BD -
    12·1 answer
  • Can someone help me pls I need help realllll bad right now someone pls
    10·1 answer
  • Find the mean proportion between 1/2 nd 1/8
    14·1 answer
  • Jenny wants to build a concrete patio that will be 8 meters by 11 meters
    9·2 answers
  • Consider the triangle below.
    5·1 answer
  • A cylinder has a volume of 216π cubic feet and a height of 18 feet. what is the area of the base? cylinder v = bh 1. substitute
    11·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!