Treehouse | Community | LOOKUP Functions Quiz

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

New No-Code Track! 🚀start learning today!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

brigitte kock
2,054 Points
I don't understand where the left VS right and bottom VS top is coming from? And what it means?

Posted November 14, 2020 10:27am by brigitte kock

brigitte kock
2,054 Points
0 Answers
Jaron Trotter
11,472 Points
Can't read CSV files after I navigate to where my downloaded files are and I import pandas.

Posted November 4, 2020 12:30am by Jaron Trotter

Jaron Trotter
11,472 Points
1 Answer
Sumiya Malik
3,976 Points
Why did the format for the MODE value change from duration to floating point value while Average and Median did not?

Posted October 28, 2020 3:17pm by Sumiya Malik

Sumiya Malik
3,976 Points
- Data Analysis
1 Answer
Hayder Morsel
3,055 Points
There doesn't seem to be an 'aggregate column' option in the chart setup menu?

Posted October 13, 2020 6:08pm by Hayder Morsel

Hayder Morsel
3,055 Points
2 Answers
Hend Elshaarawi
434 Points
I get another answer (video: 99002, min: 01:55)

Posted October 10, 2020 4:22pm by Hend Elshaarawi

Hend Elshaarawi
434 Points
- Data Analysis
0 Answers
Adya Mishra
1,043 Points
Max difference - how is it 200?

Posted October 2, 2020 9:36pm by Adya Mishra

Adya Mishra
1,043 Points
1 Answer
Qui Le
10,998 Points
Why did we receive a floating value when we use MODE function in Google Spreadsheet instead of getting a duration?

Posted September 23, 2020 4:09am by Qui Le

Qui Le
10,998 Points
0 Answers
Jakub Mozdzierz
8,181 Points
How to filter for dates in dataframe?

Posted September 22, 2020 12:50am by Jakub Mozdzierz

Jakub Mozdzierz
8,181 Points
- Data Analysis
0 Answers
Kevin LG
5,641 Points
What should we do when "F and R" replaces a cell's number(in copied formulas) to give us a redundant total?

Posted August 14, 2020 4:27pm by Kevin LG

Kevin LG
5,641 Points
1 Answer
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
Joshua Fredrickson
428 Points
Noticed an error

Posted August 5, 2020 7:56pm by Joshua Fredrickson

Joshua Fredrickson
428 Points
1 Answer
Padmavathi Srinivas Pappala
6,852 Points
Pyspark and other Big Data Technologies soon?

Posted August 3, 2020 11:22pm by Padmavathi Srinivas Pappala

Padmavathi Srinivas Pappala
6,852 Points
- Data Analysis
0 Answers
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
Gretchen Hutterli
412 Points
Charting our data: part 1

Posted July 30, 2020 3:35am by Gretchen Hutterli

Gretchen Hutterli
412 Points
- Data Analysis
0 Answers
Asa Arnold
1,266 Points
S1 vs S2 in "=MIN('2017'!S2:S26411)"

Posted July 24, 2020 9:28am by Asa Arnold

Asa Arnold
1,266 Points
1 Answer
Gaurav Sharma
5,496 Points
Find all of the columns in the demographics file that contain string data.

Posted July 23, 2020 11:02am by Gaurav Sharma

Gaurav Sharma
5,496 Points
1 Answer
Nick Evershed
6,429 Points
Standard deviation getting confusing

Posted July 21, 2020 9:26am by Nick Evershed

Nick Evershed
6,429 Points
1 Answer
PLUS

Traci Leung
Courses Plus Student 2,534 Points
Where is the data for Store 34?

Posted July 9, 2020 6:05pm by Traci Leung

Traci Leung
Courses Plus Student 2,534 Points
0 Answers
Dario Persechino
9,746 Points
Hi, the setup for charts on Google Docs seems to have changed since the video was made.

Posted June 19, 2020 7:28pm by Dario Persechino

Dario Persechino
9,746 Points
- Data Analysis
1 Answer
Joe Li
3,234 Points
Can't read in CSV files after importing the pandas library

Posted June 8, 2020 9:52pm by Joe Li

Joe Li
3,234 Points
1 Answer
Ronald Greer
Front End Web Development Techdegree Graduate 56,430 Points
What was Amazons total free cash flow for fiscsal year 2018.

Posted June 6, 2020 4:45pm by Ronald Greer

Ronald Greer
Front End Web Development Techdegree Graduate 56,430 Points
1 Answer
Daniel Shears
1,266 Points
Isn't statistical significance a measure of internal validity rather than external validity?

Posted June 4, 2020 2:06pm by Daniel Shears

Daniel Shears
1,266 Points
- Data Analysis
0 Answers
Daniel Shears
1,266 Points
Why does the difference between frequency of ages give us insight into which ages have an easier time qualifying?

Posted June 4, 2020 2:00pm by Daniel Shears

Daniel Shears
1,266 Points
- Data Analysis
1 Answer
hamsternation
26,617 Points
Protip: Drag the lower right corner of Aristotle Duderino 1 to autofill 2,3,4 ...

Posted May 31, 2020 2:33am by hamsternation

hamsternation
26,617 Points
1 Answer
Stephanie Albright
5,690 Points
The spreadsheet for this quiz is messed up and doesn't have store 34 on it.

Posted May 29, 2020 9:41pm by Stephanie Albright

Stephanie Albright
5,690 Points
2 Answers
Simran Bansari
5,249 Points
How do you convert a int number (rating) to a float ?

Posted May 19, 2020 6:43pm by Simran Bansari

Simran Bansari
5,249 Points
- Data Analysis
1 Answer
Kawaljeet Singh
3,820 Points
Average

Posted May 7, 2020 2:00pm by Kawaljeet Singh

Kawaljeet Singh
3,820 Points
1 Answer
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
ian mays
5,214 Points
SWAPI.CO is now https://swapi.dev/

Posted May 4, 2020 5:29pm by ian mays

ian mays
5,214 Points
0 Answers
rikael
1,856 Points
What function allows you to tell the minimum amount using two numbers not placed on a spreadsheet?

Posted May 2, 2020 6:16pm by rikael

rikael
1,856 Points
1 Answer

Prev Page 4 of 33 Next

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