Treehouse | Community | Getting Started With Spreadsheets Review

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
atomictds
698 Points
So what IS the difference between comments and notes? Why would you use notes if comments logs the history?

Posted June 2, 2025 4:46pm by atomictds

atomictds
698 Points
1 Answer
atomictds
698 Points
First question on Finding # of employees for guests

Posted May 18, 2025 7:10pm by atomictds

atomictds
698 Points
1 Answer
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
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
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
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
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
Ozaveshe Balogun
Front End Web Development Techdegree Student 20,459 Points
Hi. Please why is this equation wrong ? ROUNDDOWN(15*3030, 0).

Posted December 13, 2021 11:02am by Ozaveshe Balogun

Ozaveshe Balogun
Front End Web Development Techdegree Student 20,459 Points
1 Answer
nicolaspeterson
8,569 Points
I really enjoyed this course. Thanks Michael!

Posted October 20, 2021 10:07am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
nicolaspeterson
8,569 Points
How do you copy the formulas?

Posted October 20, 2021 9:49am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
nicolaspeterson
8,569 Points
After transposing, the datasheet copied itself a dozen times.

Posted October 20, 2021 9:36am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
nicolaspeterson
8,569 Points
I watched this video twice and I still don't get what the usefulness of CHOOSE is...

Posted October 20, 2021 7:48am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
nicolaspeterson
8,569 Points
Can you select multiple criteria for a SUMIF?

Posted October 20, 2021 7:44am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
nicolaspeterson
8,569 Points
Functions are not case-sensitive.

Posted October 20, 2021 7:24am by nicolaspeterson

nicolaspeterson
8,569 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
Maurice Moore
12,487 Points
Tried multiple test and the total I get is 13...

Posted June 3, 2021 3:11pm by Maurice Moore

Maurice Moore
12,487 Points
0 Answers

Prev Page 1 of 5 Next

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

Joshua Richardson

Joshua Richardson

atomictds

atomictds

atomictds

atomictds

Chidubem Adike

Chidubem Adike

Chidubem Adike

Chidubem Adike

JOSEPH DOUCETTE

JOSEPH DOUCETTE

Lulu C

Lulu C

Finn Danson

Finn Danson

Finn Danson

Finn Danson

Christopher Garavente

Christopher Garavente

Sean White

Sean White

Sean White

Sean White

McKay Montz

McKay Montz

Ruth Browning

Ruth Browning

edwin echeverria

edwin echeverria

Maxim Culacov

Maxim Culacov

James Salgado

James Salgado

charles bempah

charles bempah

charles bempah

charles bempah

Ozaveshe Balogun

Ozaveshe Balogun

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

Veronica L

Veronica L

Maurice Moore

Maurice Moore