Treehouse | Community | Review Spreadsheet Calculations

🤑 Join the Treehouse affiliate program and earn 25% commission!

Join our Live Career-Building Workshop: Fast-Track Your Tech Career Without a Degree! ⭐ Register here!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

JOSEPH DOUCETTE
661 Points
how is my answer wrong? the total dollar value should be $11,061.00 if you sum all of column B values?

Posted August 14, 2024 7:16pm by JOSEPH DOUCETTE

JOSEPH DOUCETTE
661 Points
1 Answer
Breona Woodard
1,116 Points
When i click data validation, something else comes up. I think this version is old so i'm not sure where to go in

Posted March 1, 2024 8:40pm by Breona Woodard

Breona Woodard
1,116 Points
- Data Analysis
- Data Validation
1 Answer
Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
Why can't i reference to cell B1 in the formula "=COUNTIFS(B1,">"&B6-B10,B1,"<"&B6+B10)/B1".

Posted February 6, 2024 5:37pm by Shreemangal Sethi

Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
- Data Analysis
1 Answer
Patrick Koch
40,496 Points
I dont get I tryed answer B and C but its not correct.

Posted January 26, 2024 8:29pm by Patrick Koch

Patrick Koch
40,496 Points
2 Answers
Aaron Loften
12,864 Points
The video does not mention what to do in this scenario - Median where result is represents another object.

Posted January 15, 2024 12:40am by Aaron Loften

Aaron Loften
12,864 Points
1 Answer
Lulu C
1,265 Points
Most expensive item: I’ve used the filter and sort options and I keep seeing 318 as the most expensive other item

Posted October 12, 2023 6:36pm by Lulu C

Lulu C
1,265 Points
1 Answer
Finn Danson
122 Points
What is the value in cell E15?

Posted September 27, 2023 2:30pm by Finn Danson

Finn Danson
122 Points
1 Answer
Finn Danson
122 Points
Which row is the data header row?

Posted September 27, 2023 2:11pm by Finn Danson

Finn Danson
122 Points
1 Answer
Christopher Garavente
407 Points
Is there a way to sum ranges of cells - instead of entire rows or individual cells?

Posted August 2, 2023 11:44am by Christopher Garavente

Christopher Garavente
407 Points
0 Answers
Sean White
5,537 Points
We are taught how to sort, and how to filter, but not how to filter and then perform a function?

Posted July 27, 2023 6:28pm by Sean White

Sean White
5,537 Points
1 Answer
Sean White
5,537 Points
Based on this question, how do I know which field they are asking for? For example:

Posted July 27, 2023 6:09pm by Sean White

Sean White
5,537 Points
1 Answer
Jim Andrews
5,967 Points
Why is the spreadsheet not showing up in the teacher's notes for download?

Posted June 15, 2023 3:06am by Jim Andrews

Jim Andrews
5,967 Points
- Data Analysis
- Lookup Functions
1 Answer
Sarah Schaeffer
Data Analysis Techdegree Graduate 11,564 Points
which track to take first

Posted May 30, 2023 9:58pm by Sarah Schaeffer

Sarah Schaeffer
Data Analysis Techdegree Graduate 11,564 Points
- Data Analysis
2 Answers
Sarah Schaeffer
Data Analysis Techdegree Graduate 11,564 Points
Importing Boston Marathon results. After importing I am not able to view in the spreadsheet.

Posted May 24, 2023 4:08pm by Sarah Schaeffer

Sarah Schaeffer
Data Analysis Techdegree Graduate 11,564 Points
4 Answers
McKay Montz
4,073 Points
Where is store 34?

Posted April 4, 2023 6:34pm by McKay Montz

McKay Montz
4,073 Points
1 Answer
Ruth Browning
86 Points
The total $ amount of the F&B and Entertainment categories

Posted March 2, 2023 9:27am by Ruth Browning

Ruth Browning
86 Points
1 Answer
Kristi Henry
1,875 Points
Binder File - Error

Posted February 11, 2023 3:03pm by Kristi Henry

Kristi Henry
1,875 Points
- Data Analysis
0 Answers
Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
Data Validation displayed differently

Posted January 11, 2023 1:42pm by Gabriel Guerra

Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
- Data Analysis
- Data Validation
1 Answer
Marek Ostrowski
16,268 Points
There is better way I think: data["Type"] = data["Type"].apply(lambda x: x.replace("Posion", "Poison"))

Posted January 7, 2023 4:22pm by Marek Ostrowski

Marek Ostrowski
16,268 Points
- Data Analysis
0 Answers
Josh Milbrandt
6,209 Points
Why nothing related to R in the entire data analytics section? R has become a pre-requisite to advanced data analysis.

Posted December 6, 2022 11:30pm by Josh Milbrandt

Josh Milbrandt
6,209 Points
- Data Analysis
1 Answer
Orian Sentner
256 Points
Where to find data set?

Posted October 27, 2022 3:37am by Orian Sentner

Orian Sentner
256 Points
2 Answers
Sifan Wang
687 Points
Investing cash flow vs Capital expenditure

Posted October 26, 2022 8:45am by Sifan Wang

Sifan Wang
687 Points
0 Answers
Sifan Wang
687 Points
SG&A expansion here refers to absolute or relativ? (sg&a)2/Revenue2 - (sg&a)1/Rev1 is absolute, how to calculate relativ

Posted October 19, 2022 8:36am by Sifan Wang

Sifan Wang
687 Points
1 Answer
Dmitrij Maksimov
Data Analysis Techdegree Student 530 Points
Installed slack used by account and no other channels other than general

Posted September 27, 2022 12:06pm by Dmitrij Maksimov

Dmitrij Maksimov
Data Analysis Techdegree Student 530 Points
- Data Analysis
- Slack for Techdegree Students
0 Answers
edwin echeverria
2,987 Points
In the Expenses spreadsheet you opened in the first question, the total dollar value of all items in the F&B and Enterta

Posted September 9, 2022 3:17am by edwin echeverria

edwin echeverria
2,987 Points
1 Answer
Temi Folorunsho
2,849 Points
Max, Min, Range

Posted July 19, 2022 10:04am by Temi Folorunsho

Temi Folorunsho
2,849 Points
1 Answer
Maxim Culacov
7,374 Points
Since BEA website looks different now, I would like to request a link to be posted on a data set to be used

Posted July 1, 2022 11:05am by Maxim Culacov

Maxim Culacov
7,374 Points
1 Answer
James Salgado
739 Points
I can't seem to open/copy any of the links of the spreadsheet. So I can't answer questions. Unable to open any file

Posted June 2, 2022 10:58am by James Salgado

James Salgado
739 Points
1 Answer
charles bempah
1,295 Points
A I using the right function and am I using it properly?

Posted May 27, 2022 11:52am by charles bempah

charles bempah
1,295 Points
1 Answer
charles bempah
1,295 Points
5th question confusion.

Posted May 27, 2022 11:44am by charles bempah

charles bempah
1,295 Points
1 Answer

Prev Page 1 of 33 Next

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.