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 Habeeb Mohamed
Habeeb Mohamed
157 Points

Rewrite the formula in cell E3 so it is an absolute reference to the number of tickets sold on Wednesday?

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 $

Whats the answer for this question?

3 Answers

Steven Ang
Steven Ang
41,751 Points
Steven Ang
Steven Ang
41,751 Points

The question is asking you to make the B3 (the seats sold on Monday) in E3 to B5 (the seats sold on Wednesday) to an absolute reference. Once you've done that, autofill it from E3 to E9. The total revenue will appear on E10 and that's the answer to the question.

Shaun Sang
Shaun Sang
2,680 Points
Shaun Sang
Shaun Sang
2,680 Points

Answer is:

103,600.00

Robbie Thomas
Robbie Thomas
31,093 Points
Robbie Thomas
Robbie Thomas
31,093 Points

I don't even know what the hell they were talking about with that question, that stumped me. I went here to get the answer.

Justin Rose
Justin Rose
12,842 Points
Justin Rose
Justin Rose
12,842 Points

Literally been staring at this problem for hours! Im not trying to cheat. My life as a data analyst is looking bleak