Monthly Budget Tracker Quiz

Which sheet displays a snapshot of the month's income, expenses, and savings?

• Sheet 1: Summary

• Sheet 2: Income

• Sheet 3: Expenses

• Sheet 4: Graphs

What is the purpose of Sheet 4: Graphs?

• To visualize the data with charts

• To list all expenses

• To calculate savings

• To log income sources

Which column in the Summary sheet shows "Total Income"?

• A2

• A3

• A4

• B2

Which formula is used to calculate total savings in the Summary sheet?

• =B2-B3

• =SUM(Income!B2:B100)

• =SUM(Expenses!B2:B100)

• =A1+A2

In the Income sheet, what is listed in column A1?

• "Date"

• "Source"

• "Amount"

• "Total"

In the Income sheet, what is listed in column B1?

• "Source"

• "Date"

• "Amount"

• "Total"

What is the total savings in the example data?

• $5000

• $3200

• $1800

• $1000

On what date is the salary recorded in the income sheet?

• 2024-12-01

• 2024-12-02

• 2024-11-30

• 2024-12-03

What column is used for the amount in the income sheet?

• C

• A

• B

• D

What is the amount spent on rent?

• $1200

• $300

• $150

• $100