Budget Management Spreadsheet Quiz

What is the purpose of the Budget Management Spreadsheet?

• To play games

• To track income, expenses, and savings

• To write stories

• To draw pictures

Which categories are included in the data structure of the spreadsheet?

• Animals, Plants, Minerals

• Income, Fixed Expenses, Variable Expenses, Savings

• Books, Movies, Music

• Cars, Bikes, Buses

What columns are part of the spreadsheet?

• Date, Category, Description, Amount, Calculations

• Name, Age, Address, Phone

• Color, Size, Shape, Texture

• Morning, Afternoon, Evening, Night

What does the Total Income formula calculate?

• The number of days in a week

• The summation of income entries

• The total number of books

• The amount of water in a glass

What does the line chart in the spreadsheet visualize?

• The growth of a plant

• Savings trends over time

• The speed of a car

• The height of a mountain

What file format is the Budget Management Spreadsheet in?

• PDF

• MS Excel

• Word Document

• PowerPoint

What is validated in the unit tests?

• The taste of food

• The accuracy of summation formulas for Total Income, Total Expenses, Net Savings

• The color of the sky

• The sound of music

What does the pie chart in the Budget Management Spreadsheet show?

• The types of flowers in a garden

• The pie chart visualizes expense distribution

• The number of cars in a parking lot

• The colors of a sunset

What should integration tests ensure about income and expense data?

• They are entered manually.

• They are correctly reflected in cumulative totals.

• They are ignored.

• They are only for expenses.

What is the first step in simulating a complete workflow in system tests?

• Validate graph accuracy

• Add income data

• Calculate net savings

• Add fixed and variable expenses