Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Data Analysis Spreadsheet Basics Getting Started With Spreadsheets Getting Started With Spreadsheets Review

Posted by Vikram Chan
.a{fill-rule:evenodd;}techdegree
Vikram Chan
Python Development Techdegree Student 281 Points

The spreadsheet shows ticket sales and revenue for a hypothetical theatre.

The spreadsheet shows ticket sales and revenue for a hypothetical theatre. Rewrite the formula in cell E3 so it is an absolute reference to the number of tickets sold on Wednesday. Then copy it to calculate for all days of the week. What is the total amount of revenue if the number of tickets sold always equaled Wednesday’s amount sold: $

Steven Parker
Steven Parker
231,269 Points
Steven Parker
Steven Parker
231,269 Points

It looks like you've just copied from the quiz. Did you have a question about it?
And what formula did you enter in E3, and what value did you get?

2 Answers

Preston Lovette
Preston Lovette
123 Points
Preston Lovette
Preston Lovette
123 Points

I ran into an issue with this questions as well. I calculated the total to be $44,400 based on taking the ticket volume from Wednesday (300 in cell $B$3) and multiplying it by the respective ticket price for each day and then summing the total of those values...not sure what I'm missing. It's kind of frustrating treehouse doesn't display the correct answer after getting it wrong

Bonnie McInturf
Bonnie McInturf
2,177 Points
Bonnie McInturf
Bonnie McInturf
2,177 Points

The question is asking what the total revenue would be if every day had the same number of sales as Wednesday, but price still varies by day.

  1. Rewrite the formula in cell E3 so it is an absolute reference to the number of tickets sold on Wednesday: Since we are referencing Wednesday, switch "3" to a "5." Put a "$" in front of the "B" and the "5" to make them absolute.

  2. Then copy it to calculate for all days of the week: Multiply price, which varies for each day. Since the column "C" is absolute, we can put a "$" in front of it, but the day does vary, so don't add a "$" in front; just start with the "3." So E3 will read: =$B$5*$C3

  3. What is the total amount of revenue if the number of tickets sold always equaled Wednesday’s amount sold: Look at the total for that column.