Treehouse | Community | Getting Started With Spreadsheets Review

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

🌟 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

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
bessiebarnes
88,917 Points
How do I find the median? In the Expenses spreadsheet you opened in the first question, the median value of all expenses

Posted April 30, 2018 11:35pm by bessiebarnes

bessiebarnes
88,917 Points
1 Answer
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
Zach Puckett
3,493 Points
Spreadsheets Basics - Expenses

Posted April 7, 2018 1:24am by Zach Puckett

Zach Puckett
3,493 Points
1 Answer
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
PLUS

Matthew Han
Courses Plus Student 701 Points
If we are dealing with thousands of data, we can't possibly select with our mouse when doing the SUM function right?

Posted February 20, 2018 10:45am by Matthew Han

Matthew Han
Courses Plus Student 701 Points
3 Answers
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
David Griffith
8,311 Points
For this question in the test "In the Expenses spreadsheet you opened in the first question, the total dollar value of a

Posted February 9, 2018 7:31pm by David Griffith

David Griffith
8,311 Points
6 Answers
Sean Sarnelli
355 Points
Google Sheet Access

Posted February 7, 2018 8:55pm by Sean Sarnelli

Sean Sarnelli
355 Points
1 Answer
ajibola adigun
5,384 Points
The total dollar value of the expenses is $

Posted January 24, 2018 7:28pm by ajibola adigun

ajibola adigun
5,384 Points
1 Answer
Alex Life
16,114 Points
Why is this quiz giving me "incorrect" when im right?

Posted December 16, 2017 5:15pm by Alex Life

Alex Life
16,114 Points
1 Answer
Eni Begotaraj
13,723 Points
How to do Average on filtered items on google sheets?

Posted October 12, 2017 3:27pm by Eni Begotaraj

Eni Begotaraj
13,723 Points
1 Answer
A X
12,842 Points
He lost me at absolute referencing...

Posted September 2, 2017 2:29am by A X

A X
12,842 Points
2 Answers
Lee Ravenberg
10,018 Points
I can't figure out how to reference a how to reference all cells in column C that yields the value of 'other'.

Posted August 21, 2017 2:57pm by Lee Ravenberg

Lee Ravenberg
10,018 Points
1 Answer
Robert Howard
4,926 Points
How can I pass the Spreadsheet quiz if the answers are wrong, or require a format that I cannot figure out?

Posted July 14, 2017 1:59am by Robert Howard

Robert Howard
4,926 Points
2 Answers
djdinosauripod
356 Points
Go to row option/hotkey?

Posted July 3, 2017 4:45pm by djdinosauripod

djdinosauripod
356 Points
1 Answer
John Tilton
2,243 Points
Right Answer is NOT Correct

Posted July 3, 2017 1:44am by John Tilton

John Tilton
2,243 Points
2 Answers
nfs
35,526 Points
Why is there an error in making a percentage value in column E??

Posted June 13, 2017 2:35pm by nfs

nfs
35,526 Points
2 Answers
Sahar Nasiri
7,454 Points
When I filter a column how can I calculate the total price of that filtering

Posted June 10, 2017 7:32am by Sahar Nasiri

Sahar Nasiri
7,454 Points
1 Answer
Fatai Emiabata
2,656 Points
It asking for the sum of F&B and Entertainment but it keeps telling its incorrect. After I filter, I type =SUM(B10:B176)

Posted June 5, 2017 2:32pm by Fatai Emiabata

Fatai Emiabata
2,656 Points
1 Answer
Yasmine Van Pee
529 Points
Where can I find the correct answer to a question that I answered wrong?

Posted May 30, 2017 3:13pm by Yasmine Van Pee

Yasmine Van Pee
529 Points
2 Answers
Michael Lawinger
33,581 Points
Find the Average

Posted May 23, 2017 9:52pm by Michael Lawinger

Michael Lawinger
33,581 Points
1 Answer
Habeeb Mohamed
157 Points
This formula includes relative references to three cells: =A1*B4+B2

Posted April 19, 2017 6:47am by Habeeb Mohamed

Habeeb Mohamed
157 Points
2 Answers
Habeeb Mohamed
157 Points
Rewrite the formula in cell E3 so it is an absolute reference to the number of tickets sold on Wednesday?

Posted April 19, 2017 6:00am by Habeeb Mohamed

Habeeb Mohamed
157 Points
3 Answers

Prev Page 2 of 3 Next

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