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

🤑 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

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

  • Treehouse Logo
  • Plans
    Chevron
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
  • Library
    Chevron
    • All Courses
    • Tracks
    • College Credit
  • Techdegree
    Chevron
    • Overview
    • Front End Development
    • Full Stack JavaScript
    • Data Analysis
    • UX Design
    • Python
  • Community
    Chevron
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
  • Resources
    Chevron
    • Career Toolbox
    • CodeForward
    • Free Treehouse Near Me
    • Jobs
    • Blog
    • Support
    • About
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks College Credit
  • Overview Front End Web Development Full Stack JavaScript Python Development Data Analysis UX Design
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Career Toolbox CodeForward Free Treehouse Near Me Jobs Blog Support About
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • Android
      • • APIs
      • • Coding for Kids
      • • College Credit
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Game Development
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • No-Code
      • • PHP
      • • Professional Growth
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
    • Showing results for:
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics
    • Close
  • McKay Montz
    McKay Montz
    4,073 Points

    Where is store 34?

    Posted on Apr 4, 2023 by McKay Montz
    McKay Montz
    4,073 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    1 Answer

  • charles bempah
    charles bempah
    1,295 Points

    A I using the right function and am I using it properly?

    Posted on May 27, 2022 by charles bempah
    charles bempah
    1,295 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    1 Answer

  • charles bempah
    charles bempah
    1,295 Points

    5th question confusion.

    Posted on May 27, 2022 by charles bempah
    charles bempah
    1,295 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    1 Answer

  • Maurice Moore
    Maurice Moore
    12,487 Points

    Tried multiple test and the total I get is 13...

    Posted on Jun 3, 2021 by Maurice Moore
    Maurice Moore
    12,487 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    0 Answers

  • Amber Prince
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Amber Prince
    Front End Web Development Techdegree Graduate 16,139 Points

    Not sure what I'm doing wrong. The question is asking to give the year of the most steelhead. I put 2009.

    Posted on Apr 2, 2021 by Amber Prince
    .a{fill-rule:evenodd;}techdegree seal-36
    Amber Prince
    Front End Web Development Techdegree Graduate 16,139 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    1 Answer

  • Travis Carter
    Travis Carter
    675 Points

    I do not have the spreadsheet this question is asking for. How do I go about getting it.

    Posted on Dec 23, 2020 by Travis Carter
    Travis Carter
    675 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    0 Answers

  • Traci Leung
    PLUS
    Traci Leung
    Courses Plus Student 2,534 Points

    Where is the data for Store 34?

    Posted on Jul 9, 2020 by Traci Leung
    Traci Leung
    Courses Plus Student 2,534 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    0 Answers

  • Stephanie Albright
    Stephanie Albright
    5,690 Points

    The spreadsheet for this quiz is messed up and doesn't have store 34 on it.

    Posted on May 29, 2020 by Stephanie Albright
    Stephanie Albright
    5,690 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    2 Answers

  • Kawaljeet Singh
    Kawaljeet Singh
    3,820 Points

    Average

    Posted on May 7, 2020 by Kawaljeet Singh
    Kawaljeet Singh
    3,820 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    1 Answer

  • Joshua Hoy
    Joshua Hoy
    4,887 Points

    Bonneville Dam Spreadsheet

    Posted on Apr 29, 2020 by Joshua Hoy
    Joshua Hoy
    4,887 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    0 Answers

  • Gilbert Rifkin
    Gilbert Rifkin
    3,116 Points

    Total number of fish

    Posted on Apr 28, 2020 by Gilbert Rifkin
    Gilbert Rifkin
    3,116 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    1 Answer

  • taherkhan
    taherkhan
    4,327 Points

    I used the code =COUNTIF(L3824:L4005, TRUE), the result was 13, however the quiz does not accept it. Am I wrong here?

    Posted on Mar 20, 2019 by taherkhan
    taherkhan
    4,327 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    1 Answer

  • Dilwar Rahman
    Dilwar Rahman
    3,750 Points

    In the Retail Network spreadsheet you opened in the fourth quiz question, the average unemployment rate over the entire

    Posted on Nov 1, 2018 by Dilwar Rahman
    Dilwar Rahman
    3,750 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    0 Answers

  • Ray1 B
    Ray1 B
    9,783 Points

    Spreadsheet Basics: Final Quiz, 2nd Google Sheets Issue AND Wrong Missed

    Posted on Oct 22, 2018 by Ray1 B
    Ray1 B
    9,783 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    2 Answers

  • Ayomide Gidado
    Ayomide Gidado
    1,307 Points

    In the Retail Network spreadsheet you opened in the fourth quiz question, the average unemployment. I get 9.78 but no?

    Posted on Sep 29, 2018 by Ayomide Gidado
    Ayomide Gidado
    1,307 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    2 Answers

  • Philip Schultz
    Philip Schultz
    11,437 Points

    Return a cell related to another cell.

    Posted on Sep 21, 2018 by Philip Schultz
    Philip Schultz
    11,437 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    1 Answer

  • danielchristie
    danielchristie
    21,505 Points

    Is this test working?

    Posted on Aug 14, 2018 by danielchristie
    danielchristie
    21,505 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    1 Answer

  • Deborah Watson
    Deborah Watson
    2,614 Points

    Isn't the answer 07/19/2013?

    Posted on Jul 30, 2018 by Deborah Watson
    Deborah Watson
    2,614 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    1 Answer

  • Ricky Sparks
    Ricky Sparks
    22,249 Points

    In the Retail Network spreadsheet you opened in the fourth quiz question, the number of cells with a value of “TRUE” in?

    Posted on Jul 11, 2018 by Ricky Sparks
    Ricky Sparks
    22,249 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    2 Answers

  • Ricky Sparks
    Ricky Sparks
    22,249 Points

    The date of the highest recorded temperature?

    Posted on Jul 9, 2018 by Ricky Sparks
    Ricky Sparks
    22,249 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    1 Answer

  • Esdras Dieguez
    Esdras Dieguez
    4,692 Points

    don't understand why i'm getting this question wrong? the date of the highest temperature recorded is 07/19/2013 yes?

    Posted on May 16, 2018 by Esdras Dieguez
    Esdras Dieguez
    4,692 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    1 Answer

  • Jan Lundeen
    Jan Lundeen
    6,121 Points

    On Spreadsheet Basics Final quiz, I used SUM function to answer question 1 of 6. Where did I go wrong?

    Posted on Nov 9, 2017 by Jan Lundeen
    Jan Lundeen
    6,121 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    1 Answer

  • John Grillo
    John Grillo
    30,241 Points

    The total number of fish which passed through the dam in 2001 was

    Posted on Aug 20, 2017 by John Grillo
    John Grillo
    30,241 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    1 Answer

  • Amanda Sideris
    Amanda Sideris
    402 Points

    can you please provide the formula for this question? thanks

    Posted on May 21, 2017 by Amanda Sideris
    Amanda Sideris
    402 Points
    • Data Analysis
    • Spreadsheet Basics
    • Build a Spreadsheet
    • Review Spreadsheet Basics

    3 Answers

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

    Treehouse

  • About
  • Blog
  • Careers
  • Community
  • Stories
  • Shop
  • Contact
  • Gift Card

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Affiliates
  • Perks
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2025 Treehouse Island, Inc.