Treehouse | Community | Getting Started With Spreadsheets Review

⚡ CYBER NOVEMBER SALE ⚡ 50% off any plan for 6 months, exclusive to new subscribers.

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Joshua Richardson
3,613 Points
I'm unclear how I'm getting this wrong (I get 9431.00). I don't know what to say, I'm an experienced spreadsheet user.

Posted July 13, 2025 4:12am by Joshua Richardson

Joshua Richardson
3,613 Points
2 Answers
Chidubem Adike
641 Points
i think there is a problem with the sum of the value of F&B and Entertainment. i'm getting 9431, it says it's wrong

Posted May 4, 2025 7:31am by Chidubem Adike

Chidubem Adike
641 Points
1 Answer
Chidubem Adike
641 Points
There is a problem with question 3 i have solved the question in many ways and i still get 9431 but i'm getting a bummer

Posted May 4, 2025 7:08am by Chidubem Adike

Chidubem Adike
641 Points
1 Answer
JOSEPH DOUCETTE
663 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
663 Points
1 Answer
Lulu C
1,290 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,290 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
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
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
nicolaspeterson
8,569 Points
I didn't quite get the mixed reference part...

Posted October 20, 2021 7:08am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
nicolaspeterson
8,569 Points
In my spreadsheet copy, the sum function auto-filled.

Posted October 20, 2021 6:26am by nicolaspeterson

nicolaspeterson
8,569 Points
2 Answers
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
Shakran Mushtaq
81 Points
Difference between formula and function?

Posted May 16, 2021 7:44pm by Shakran Mushtaq

Shakran Mushtaq
81 Points
1 Answer
teodoro gonzalez
195 Points
The video does not run

Posted April 12, 2021 10:15pm by teodoro gonzalez

teodoro gonzalez
195 Points
1 Answer
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
3 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
ss80
3,529 Points
This formula includes relative references to three cells

Posted July 18, 2019 4:19pm by ss80

ss80
3,529 Points
1 Answer
Tiffany Nichols
119 Points
When I download the examples spreadsheet its not the same as the videos. Am I missing something?

Posted July 12, 2019 11:11pm by Tiffany Nichols

Tiffany Nichols
119 Points
2 Answers
EMEKA PEACEWILL
Front End Web Development Techdegree Student 5,914 Points
how did you select all those data...just before going to the Data menu?

Posted July 8, 2019 10:08am by EMEKA PEACEWILL

EMEKA PEACEWILL
Front End Web Development Techdegree Student 5,914 Points
2 Answers
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
codyl
4,704 Points
If Excel is the most commonly used spreadsheet app -- why are lessons in google docs?

Posted January 2, 2019 10:15pm by codyl

codyl
4,704 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

Prev Page 1 of 3 Next

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