TutorMe homepage
Subjects
PRICING
COURSES
Start Free Trial
Rosemary S.
Student Tutor
Tutor Satisfaction Guarantee
Microsoft Excel
TutorMe
Question:

How would you calculate the average quantity sold for the a specific style of sunglasses in a dataset that contained columns for Brand, Style, Sale Price, Qty Sold, and Total Revenue?

Rosemary S.

By using the conditional formula, =AVERAGEIF((All of the values in the Style column), "Specific Style Name", (All values in Qty Sold column). This would look like =AVERAGEIF(C46:C94, "Original Pilot",E46:E94).

Writing
TutorMe
Question:

When writing an essay, what are some of the most effective ways to add emphasis?

Rosemary S.

Utilizing the initial and terminal positions of sentences are inherently more emphatic than the middle segment. When words such as especially, particularly, crucially and most importantly are used, they highlight the point directly for the reader.

ACT
TutorMe
Question:

A typical high school student consumes 67.5 pounds of sugar per year. As part of a new nutrition plan, each member of a track team plans to lower the sugar he or she consumes by at least 20% for the coming year. Assuming each track member had consumed sugar at the level of a typical high school student and will adhere to this plan for the coming year, what is the maximum number of pounds of sugar to be consumed by each track team member in the coming year? A. 14 B. 44 C. 48 D. 54 E. 66

Rosemary S.

D. 54. If you lower consumption by 20%, you would subtract the 20% from the current assumed 100%. Therefore, 80% of 67.5 = 0.80(67.5) = 54.

Send a message explaining your
needs and Rosemary will reply soon.
Contact Rosemary