Treehouse | Community | Getting Started With Spreadsheets Review

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

Join our Live Career-Building Workshop: Launch Your Tech-Adjacent Career! ⭐ 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

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
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
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
Veronica L
1,623 Points
Hello. I am having a hard time averaging after filtering. I keep getting the total for all of the cells ($11,061)

Posted July 7, 2021 2:46am by Veronica L

Veronica L
1,623 Points
0 Answers
Louis Espinoza
217 Points
I am stuck on this Spreadsheet Basics Quiz

Posted March 12, 2021 7:17am by Louis Espinoza

Louis Espinoza
217 Points
2 Answers
Brittany Daniels
512 Points
Is the "total dollar value" of two categories in a spreadsheet found by filtering the two categories and sum the column?

Posted March 9, 2021 1:49pm by Brittany Daniels

Brittany Daniels
512 Points
1 Answer
Henry Spock
20,615 Points
Performing formulas on filtered rows/columns:

Posted December 1, 2020 4:45am by Henry Spock

Henry Spock
20,615 Points
0 Answers
Martin Svensen
7,464 Points
Hi. How do I format numbers correctly? For example, should 9431 be written just like that, or 9.431 or something else?

Posted August 10, 2020 9:24am by Martin Svensen

Martin Svensen
7,464 Points
1 Answer
Kevin LG
5,641 Points
Am I entering my formula wrong to answer this question? Used "=SUM" after setting filters to F&B and Entertainment.

Posted July 31, 2020 11:26pm by Kevin LG

Kevin LG
5,641 Points
0 Answers
Christina Graves
310 Points
How do I reference particular cells while using filters?

Posted May 6, 2020 8:47pm by Christina Graves

Christina Graves
310 Points
1 Answer
Vikram Chan
Python Development Techdegree Student 281 Points
The spreadsheet shows ticket sales and revenue for a hypothetical theatre.

Posted April 14, 2020 10:40pm by Vikram Chan

Vikram Chan
Python Development Techdegree Student 281 Points
2 Answers
Lindsey Sheen
2,375 Points
I get $9,431.00 and I don't know if my answer is wrong because of the way its formatted or if the number is wrong.

Posted March 16, 2020 8:58pm by Lindsey Sheen

Lindsey Sheen
2,375 Points
1 Answer
Md Akibe Hashan
2,422 Points
i got stuck in this quize

Posted December 4, 2019 6:28am by Md Akibe Hashan

Md Akibe Hashan
2,422 Points
1 Answer
Sonam Shaikh
3,529 Points
This formula includes relative references to three cells

Posted July 18, 2019 4:19pm by Sonam Shaikh

Sonam Shaikh
3,529 Points
1 Answer
Sahabi Choudhury
1,943 Points
I need help on finding the answer to one of the questions in the quiz.

Posted June 16, 2019 6:34pm by Sahabi Choudhury

Sahabi Choudhury
1,943 Points
1 Answer
James Bachen
5,428 Points
Hi, I think this quiz is incorrect, or the joining spreadsheet is? Is there any help regarding this?? Cheers

Posted March 20, 2019 9:53am by James Bachen

James Bachen
5,428 Points
2 Answers
Mayank Tanwar
6,329 Points
What is the answer?

Posted December 15, 2018 8:07am by Mayank Tanwar

Mayank Tanwar
6,329 Points
1 Answer
George Hurst
1,610 Points
The total dollar value of the Entertainment and F&B Category 9431.00 is incorrect. How is this?

Posted November 5, 2018 3:48pm by George Hurst

George Hurst
1,610 Points
1 Answer
rsa14
1,865 Points
What does this question mean, absolute for all their rows and columns?

Posted September 11, 2018 6:45pm by rsa14

rsa14
1,865 Points
1 Answer
Murilo de Melo
14,456 Points
Filter applied, only the categories F&B and Entertainment selected, =SUM(B5:B176), result: $9,431.00. What's wrong?

Posted September 4, 2018 3:40pm by Murilo de Melo

Murilo de Melo
14,456 Points
2 Answers
Mary Hunter
216 Points
The total value as I find it is $9,431.00, but the quiz is saying that's the wrong answer. What's wrong?

Posted June 2, 2018 10:41pm by Mary Hunter

Mary Hunter
216 Points
3 Answers
Brian Ross
11,209 Points
The most expensive item in the other category is $318.00 Is this a bug or a glitch?

Posted April 19, 2018 8:09am by Brian Ross

Brian Ross
11,209 Points
2 Answers
PLUS

Daniyell Augusta
Courses Plus Student 495 Points
The most expensive item in the "other" category is not Hair Salon?

Posted March 18, 2018 6:00pm by Daniyell Augusta

Daniyell Augusta
Courses Plus Student 495 Points
2 Answers
Kelly Burchfield
579 Points
I've been marked incorrect on a couple simple answers in this quiz. Is this a glitch perhaps?

Posted March 14, 2018 1:04pm by Kelly Burchfield

Kelly Burchfield
579 Points
2 Answers
Hardik Gami
1,622 Points
Here i am getting answer as $318.00 and when i am writing it, it is coming is bummer.. can any one help me with that ?

Posted March 13, 2018 11:30pm by Hardik Gami

Hardik Gami
1,622 Points
1 Answer
PLUS

Matthew Han
Courses Plus Student 701 Points
I arrived at a different answer

Posted February 23, 2018 8:25am by Matthew Han

Matthew Han
Courses Plus Student 701 Points
1 Answer
Misgana Tezera
1,892 Points
In the Expenses spreadsheet you opened in the first question, the least expensive item in the F&B category is

Posted February 20, 2018 8:10pm by Misgana Tezera

Misgana Tezera
1,892 Points
1 Answer
PLUS

Matthew Han
Courses Plus Student 701 Points
How to SUM a filtered spreadsheet column?

Posted February 20, 2018 3:04pm by Matthew Han

Matthew Han
Courses Plus Student 701 Points
1 Answer
CadenceH Cha
409 Points
I sorted column C into F&B and Entertainment. How can I get the sum of **only** the prices that show in column B?

Posted February 17, 2018 5:32pm by CadenceH Cha

CadenceH Cha
409 Points
1 Answer

Prev Page 1 of 2 Next

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