Treehouse | Community | Getting Started With Spreadsheets Review

🤑 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

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
Anish Mathews
844 Points
Your boss asks you to tell her how many employees she needs to have on duty during an event. She needs at least 1 employ

Posted February 3, 2018 12:45am by Anish Mathews

Anish Mathews
844 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
mike john
3,719 Points
I can't find an efficient Inventory management template.! Please help..!

Posted December 10, 2017 7:15am by mike john

mike john
3,719 Points
1 Answer
Jan Lundeen
5,886 Points
On Spreadsheet Basics Final quiz, I used SUM function to answer question 1 of 6. Where did I go wrong?

Posted November 9, 2017 5:37am by Jan Lundeen

Jan Lundeen
5,886 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
A X
12,842 Points
Michael mentions a "specialized software" that does inventory management. What is this?

Posted August 26, 2017 8:18pm by A X

A X
12,842 Points
1 Answer
Kristy Knapp
10,632 Points
Google Sheets "Paste Special > Transpose" greyed out

Posted August 26, 2017 3:49am by Kristy Knapp

Kristy Knapp
10,632 Points
3 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
John Grillo
30,241 Points
The total number of fish which passed through the dam in 2001 was

Posted August 20, 2017 7:28pm by John Grillo

John Grillo
30,241 Points
1 Answer
syalih
16,468 Points
Spreadsheets and Functions and Shortcuts Quiz 2?

Posted July 31, 2017 9:11am by syalih

syalih
16,468 Points
3 Answers
Sunitha Chilukuri
137 Points
USE THE SUMIF FUNCTION TO CALCULATE THE TOTAL EXPENSES OF F&B

Posted July 17, 2017 6:02pm by Sunitha Chilukuri

Sunitha Chilukuri
137 Points
2 Answers
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
agzagi
2,399 Points
Why is it that when I select for the [sum_range] the whole C column, like C:C, it yields a totally different result?

Posted June 16, 2017 3:12pm by agzagi

agzagi
2,399 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
Mary Urban
6,321 Points
Data Analysis - Spreadsheet Basics Final quiz #of Fish question

Posted May 24, 2017 5:22pm by Mary Urban

Mary Urban
6,321 Points
6 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

Prev Page 4 of 5 Next

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