Download: Excel - Lemonade Stand Profit or Loss Spreadsheet Finished Example

Download and open this file in Microsoft Excel or a compatible spreadsheet application. Use this example to illustrate to students how to enter their title, merge and center the title, and how to change the font, font size, and font color. Demonstrate how to enter data and format the number values with $ dollar signs. Demonstrate how to calculate total expenses using the SUM formula. Demonstrate how to calculate profits (Sales - Total Expenses = Profit or Loss). Demonstrate how to create a chart showing profits for each day. Demonstrate how to format the chart bar colors, and how to resize and position the chart so that everything fits on a single printable page. Demonstrate how to use "print preview" to check the appearance and layout prior to printing the page.