Template gallery usage in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are an office assistant at a small company.

📋 Request: Your manager wants you to create a professional monthly budget report quickly using Google Sheets templates.

📊 Data: You have basic monthly income and expense data but no formatted report yet.

🎯 Deliverable: Use the Google Sheets Template Gallery to find a monthly budget template, input the data, and prepare a clean report showing income, expenses, and balance.

Sample Data

Category	Amount
Salary	4000
Freelance	800
Rent	-1200
Utilities	-300
Groceries	-450
Transport	-150
Entertainment	-200

1

Step 1: Open Google Sheets and click on 'Template Gallery' at the top right.

No formula needed.

Expected Result

You see a list of ready-made templates including 'Monthly Budget'.

2

Step 2: Select the 'Monthly Budget' template from the gallery.

No formula needed.

Expected Result

A new spreadsheet opens with a formatted monthly budget layout.

3

Step 3: Replace the sample income and expense data in the template with your own data from the sample_data table.

Manually enter or copy-paste the Category and Amount values into the template's income and expense sections.

Expected Result

The template now shows your actual income and expenses.

4

Step 4: Check that the template automatically calculates totals and balance.

The template uses formulas like =SUM(range) to total income and expenses, and =IncomeTotal - ExpenseTotal for balance.

Expected Result

Total income is 4800, total expenses are 2300, and balance is 2500.

5

Step 5: Customize the report title and date to match the current month.

Edit text cells to update title and date.

Expected Result

Report title reads 'Monthly Budget Report - June 2024'.

6

Step 6: Save the completed report and share it with your manager.

No formula needed.

Expected Result

The manager receives a clear, professional monthly budget report.

Final Result

Monthly Budget Report - June 2024

Income:
  Salary: $4000
  Freelance: $800
  Total Income: $4800

Expenses:
  Rent: $1200
  Utilities: $300
  Groceries: $450
  Transport: $150
  Entertainment: $200
  Total Expenses: $2300

Balance: $2500

✓Total income for June is $4800.

✓Total expenses for June are $2300.

✓The net balance is $2500, showing a positive budget.

Bonus Challenge

Modify the template to add a new category for 'Savings' and calculate how much money can be saved each month.

Show Hint

Insert a new row in the expenses section labeled 'Savings' with a positive amount, then update the balance formula to subtract savings.