K5 Computer Lab Lesson Plans

Excel Lesson Plan - Lemonade Stand Expenses

Students Create an Lemonade Stand Expense Budget

 

Students create an expense budget for a lemonade stand with 6 days of expenses.

Students use the random number generator to get their item expenses for each day.

 

Students enter their data in the spreadsheet for each day. Students use a formula (sum) to calculate the total expenses for each day.

Grades 4 +

 

 

 

 

Lemonade Stand Expenses Finished Example

Download: excel-lemonade-stand-expenses-finished-example.xlsx

 

 

Lemonade Stand

 

 

Random Number Generator for the Lemonade Stand Sales and Expenses

Students can use this online random number generator to help them create the numeric values for their spreadsheet. Simply click the "Get Numbers Now!" button to generate random sales and expense numbers for the lemonade stand.

Lemonade Stand Random Number Generator

 

 

Excel - Lemonade Stand Instructions:

Basic guide to creating the lemonade stand expenses spreadsheet. The basic excel skills used here are entering data in cells, using "merge and center" for the title, "autofill" for the days of the week, and "autosum" to calculate the total expenses.

Download: excel-lemonade-stand-instructions.pdf

 

 

Excel Lemonade Stand Instructions

 

Popular:
For PC's and Microsoft Office

  • Excel
    Bar Chart

    Excel Bar Chart
  • Thanksgiving
    Copy and Paste

    Thanksgiving Copy and Paste
  • Green Screen
    Photo Editing

    Green Screen Photo Editing
  • Computer Lab
    Rules

    Computer Lab Rules Essentials
  • California Regions
    Brochure

    California Regions Brochure
  • Amazing Animals
    PowerPoint

    Amazing Animals
  • I Am
    Poem Generator

    I Am Poem Generator
  • "Floater"
    Animation

    I Can Float Animation
  • Copy and Paste
    Practice

    Copy and Paste Practice
  • Learn PowerPoint
    in One Minute

    Learn PowerPoint in One Minute
  • M & M
    Excel Chart

    Excel Pie Chart
  • Newspaper
    Template

    Newspaper Template