azimgd7638 azimgd7638

02-06-2023
Business

contestada

Please download the file pretest.xlsx. In the worksheet Bakery, each row gives the following data for a sales transaction: Transaction Number, Salesperson, Date of Sale, Product, Units Sold, Revenue Generated, and Location of Sale. We have named the data in column B as Salesperson, the data in column C as Date, and so on. For the data in the worksheet Bakery, which function would compute total revenue generated by Jane? a. =SUM(Salesperson=Jane, Dollars)
b. =SUM(Salesperson,"Jane", Dollars)
c. =SUMIF(Salesperson=Jane,Dollars)
d. =SUMIF(Salesperson, "Jane", Dollars)

Respuesta :

Otras preguntas

Unlike some of its neighbors, the country of Jordan lacks natural resources like water and oil. Instead, Jordan’s main industries refine products like petroleum

Erika has 3 pieces of ribbon. each piece is 25 yards long she needs to cut pieces that are 22 inches long . What is the greatest number of 22-inch pieces that s

I am part of a whole. I am less than one-half but greater than four tenths. I am a decimal with the digit 2 in my hundredths place. What number am I?

A drinking glass is shaped like a cylinder with a height of 5 in. and a diameter of 3 in. Maeva adds 25 spherical pieces of ice to the glass. The pieces of ice

what does v1 and v2 represent

in order to clean her aquarium, Stephanie must remove half of the water. the aquarium measures 30 inches long, 16 inches wide, and 12 inches deep. the aquarium

What did Francis Cabot Lowell and Samuel Slater have in common? Their inventions allowed the U.S. economy to decrease dependence on slaves. Their inventions mad

How did Nelson Mandela expand his anti-government activities in the 1960s? He created a division dedicated to sabotage. He ran for president of South Africa..

how many right angles does a rhombus have?

A triple beam balance is shown below. Select the part of the triple beam balance that is held when carrying the balance from place to place

Q&A Education