Creating a Budget Planner in MS Excel MCQs

1. Which Excel feature is most commonly used to create a budget planner for tracking income and expenses?
(A) PivotTable
(B) Tables and Formulas
(C) SmartArt
(D) Conditional Formatting

2. To automatically calculate total income or total expenses in a budget planner, which Excel function is typically used?
(A) VLOOKUP
(B) CONCATENATE
(C) SUM
(D) IF

3. Which Excel feature can help visually display income versus expenses in a budget planner?
(A) Charts (Bar, Pie, Column)
(B) Data Validation
(C) Macros
(D) Freeze Panes

4. In a budget planner, you want to highlight overspending in red automatically. Which feature should you use?
(A) Track Changes
(B) Find & Replace
(C) Data Validation
(D) Conditional Formatting

5. If you want to prevent users from entering negative numbers in the “Expense” column, which Excel feature will help?
(A) Solver
(B) Goal Seek
(C) Data Validation
(D) Macro Recording

6. Which Excel function can be used to calculate the remaining balance after expenses are deducted from income?
(A) SUMIF
(B) Simple subtraction formula (Income – Expenses)
(C) AVERAGE
(D) CONCATENATE

7. To make a budget planner reusable for multiple months, which Excel feature is helpful?
(A) Save As Template (.xltx)
(B) Save As PDF
(C) Track Changes
(D) Freeze Panes

8. Which tool in Excel can be used to predict future expenses based on past spending in a budget planner?
(A) Goal Seek
(B) Forecast Sheet
(C) Solver
(D) Data Validation

9. To compare actual spending against the planned budget in a single view, which Excel feature is useful?
(A) PivotCharts
(B) Conditional Formatting
(C) SmartArt
(D) Sparklines

10. Which step ensures that the budget planner does not get accidentally modified by others?
(A) Protect Sheet with Password
(B) Apply Conditional Formatting
(C) Insert PivotTable
(D) Use Freeze Panes