✨ 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
    • Spreadsheet Functions & Shortcuts
    • Close
  • atomictds
    atomictds
    414 Points

    First question on Finding # of employees for guests

    Posted on May 18 by atomictds
    atomictds
    414 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • Christopher Garavente
    Christopher Garavente
    407 Points

    Is there a way to sum ranges of cells - instead of entire rows or individual cells?

    Posted on Aug 2, 2023 by Christopher Garavente
    Christopher Garavente
    407 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Introducing Functions

    0 Answers

  • James Salgado
    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 on Jun 2, 2022 by James Salgado
    James Salgado
    739 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review Formulas and Basic Functions

    1 Answer

  • Ozaveshe Balogun
    seal-mask
    .a{fill-rule:evenodd;}techdegree
    Ozaveshe Balogun
    Front End Web Development Techdegree Student 20,459 Points

    Hi. Please why is this equation wrong ? ROUNDDOWN(15*3030, 0).

    Posted on Dec 13, 2021 by Ozaveshe Balogun
    .a{fill-rule:evenodd;}techdegree
    Ozaveshe Balogun
    Front End Web Development Techdegree Student 20,459 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • nicolaspeterson
    nicolaspeterson
    8,569 Points

    I watched this video twice and I still don't get what the usefulness of CHOOSE is...

    Posted on Oct 20, 2021 by nicolaspeterson
    nicolaspeterson
    8,569 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • The CHOOSE Function

    1 Answer

  • nicolaspeterson
    nicolaspeterson
    8,569 Points

    Can you select multiple criteria for a SUMIF?

    Posted on Oct 20, 2021 by nicolaspeterson
    nicolaspeterson
    8,569 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • The SUMIF Function

    1 Answer

  • nicolaspeterson
    nicolaspeterson
    8,569 Points

    Functions are not case-sensitive.

    Posted on Oct 20, 2021 by nicolaspeterson
    nicolaspeterson
    8,569 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Introducing Functions

    1 Answer

  • Kim B
    Kim B
    4,991 Points

    Count Function - Google Sheet's... Help?

    Posted on Apr 30, 2021 by Kim B
    Kim B
    4,991 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • The COUNT Function

    1 Answer

  • angiem
    angiem
    1,548 Points

    Keyboard shortcut documentation is not in the teacher's notes as mentioned at the end of the video.

    Posted on Apr 2, 2021 by angiem
    angiem
    1,548 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Keyboard Shortcuts

    1 Answer

  • Christopher Cameron
    Christopher Cameron
    741 Points

    Unsure the type of answer format the question is seeking

    Posted on Dec 27, 2020 by Christopher Cameron
    Christopher Cameron
    741 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    0 Answers

  • rikael
    rikael
    1,856 Points

    What function allows you to tell the minimum amount using two numbers not placed on a spreadsheet?

    Posted on May 2, 2020 by rikael
    rikael
    1,856 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • Gilbert Rifkin
    Gilbert Rifkin
    3,116 Points

    Expenses

    Posted on Apr 27, 2020 by Gilbert Rifkin
    Gilbert Rifkin
    3,116 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • Sahabi Choudhury
    Sahabi Choudhury
    1,943 Points

    Need urgent help with this question please!

    Posted on Jun 16, 2019 by Sahabi Choudhury
    Sahabi Choudhury
    1,943 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • Savious Munyaradzi Ngundu
    Savious Munyaradzi Ngundu
    16,920 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 on Feb 26, 2019 by Savious Munyaradzi Ngundu
    Savious Munyaradzi Ngundu
    16,920 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • Patrick Choulas
    Patrick Choulas
    2,828 Points

    sheets link not opening up

    Posted on Sep 11, 2018 by Patrick Choulas
    Patrick Choulas
    2,828 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • The EDATE Function

    1 Answer

  • Jun Hyun Yoon
    Jun Hyun Yoon
    297 Points

    My goal ratio = 1 employees per 15 guests. 3,030 guests expected to come. =rounddown(3030/15,0) is it not correct?

    Posted on Jul 19, 2018 by Jun Hyun Yoon
    Jun Hyun Yoon
    297 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • Nicolas Montoya
    Nicolas Montoya
    10,592 Points

    What is the answer is it not just =ROUNDDOWN(3030/15)?

    Posted on Jun 21, 2018 by Nicolas Montoya
    Nicolas Montoya
    10,592 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • Miguel Enriquez
    Miguel Enriquez
    2,057 Points

    How to exclude Saturdays and Sundays while using EDATE?

    Posted on Apr 2, 2018 by Miguel Enriquez
    Miguel Enriquez
    2,057 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • The EDATE Function

    1 Answer

  • Anish Mathews
    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 on Feb 3, 2018 by Anish Mathews
    Anish Mathews
    844 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • syalih
    syalih
    16,468 Points

    Spreadsheets and Functions and Shortcuts Quiz 2?

    Posted on Jul 31, 2017 by syalih
    syalih
    16,468 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    3 Answers

  • Sunitha Chilukuri
    Sunitha Chilukuri
    137 Points

    USE THE SUMIF FUNCTION TO CALCULATE THE TOTAL EXPENSES OF F&B

    Posted on Jul 17, 2017 by Sunitha Chilukuri
    Sunitha Chilukuri
    137 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    2 Answers

  • agzagi
    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 on Jun 16, 2017 by agzagi
    agzagi
    2,399 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • The SUMIF Function

    2 Answers

  • Renee Rhodes
    Renee Rhodes
    10,653 Points

    Quiz question, Formula keeps disappearing from Spreadsheet

    Posted on Apr 22, 2017 by Renee Rhodes
    Renee Rhodes
    10,653 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    2 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.