1. Which Excel feature is most commonly used to summarize financial data for reporting?
(A) Conditional Formatting
(B) PivotTables
(C) Data Validation
(D) Goal Seek
2. To show monthly revenue trends in a financial report, which Excel tool is best?
(A) Data Bars
(B) Scenario Manager
(C) Filter
(D) Line Chart
3. Which function is best suited to calculate the average monthly expense in a financial report?
(A) =SUM()
(B) =IF()
(C) =AVERAGE()
(D) =PMT()
4. To highlight negative cash flow in red automatically, which Excel feature should be used?
(A) Conditional Formatting
(B) Goal Seek
(C) Data Consolidation
(D) Macros
5. If you want to calculate the future value of an investment for a financial report, which function should you use?
(A) =FV()
(B) =VLOOKUP()
(C) =ROUND()
(D) =INDEX()
6. Which Excel feature allows you to restrict input in financial data entry (e.g., only numbers allowed)?
(A) Freeze Panes
(B) Scenario Manager
(C) Conditional Formatting
(D) Data Validation
7. To prepare a financial report with different budget scenarios, which Excel tool is most appropriate?
(A) Solver
(B) Scenario Manager
(C) All of the above
(D) What-If Analysis → Data Table
8. When preparing a balance sheet in Excel, which formatting option ensures clarity between sections like Assets, Liabilities, and Equity?
(A) Cell Borders and Shading
(B) Merge & Center
(C) Flash Fill
(D) Sorting
9. Which chart type is most suitable for showing the breakdown of expenses in a financial report?
(A) Column Chart
(B) Pie Chart
(C) Line Chart
(D) Histogram
10. To protect a finalized financial report from unwanted changes, which Excel feature should be used?
(A) Hide Columns
(B) Freeze Panes
(C) Protect Sheet/Workbook
(D) Grouping