TutorMe homepage
Subjects
PRICING
COURSES
SIGN IN
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.
Answer:

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.
Answer:

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.
Answer:

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
Ready now? Request a lesson.
Start Session
FAQs
What is a lesson?
A lesson is virtual lesson space on our platform where you and a tutor can communicate. You'll have the option to communicate using video/audio as well as text chat. You can also upload documents, edit papers in real time and use our cutting-edge virtual whiteboard.
How do I begin a lesson?
If the tutor is currently online, you can click the "Start Session" button above. If they are offline, you can always send them a message to schedule a lesson.
Who are TutorMe tutors?
Many of our tutors are current college students or recent graduates of top-tier universities like MIT, Harvard and USC. TutorMe has thousands of top-quality tutors available to work with you.