Operating Statement - Expendable Gifts Budect raassctions How to demonstrate their skills through observation, problem solving, and knowledge of Excel Explanation of spreadsheet: This is an example of an operating statement. At the top of the statement are two summaries of Income, Expenses, and Cash balances. The remaining spreadsheet contains transactionsfor Budget Allocations, Expense Transactions, and Income Transactions. Tasks and Questions: 1) Please calculate the Available Balance for each Account. 1) Please calculate the Available Balance for each Account. 2) Using the Summary data at the top of the spreadsheet, 2) Using the Summary data at the top of the spreadsheet, please show how the Cash Balance and the available Balance are calculated. 3) Did you notice anything unusual about the accounts? 4) What functions of Excel helped you accomplish the task Operating Statement - Expendable Gifts Budect raassctions How to demonstrate their skills through observation, problem solving, and knowledge of Excel Explanation of spreadsheet: This is an example of an operating statement. At the top of the statement are two summaries of Income, Expenses, and Cash balances. The remaining spreadsheet contains transactionsfor Budget Allocations, Expense Transactions, and Income Transactions. Tasks and Questions: 1) Please calculate the Available Balance for each Account. 1) Please calculate the Available Balance for each Account. 2) Using the Summary data at the top of the spreadsheet, 2) Using the Summary data at the top of the spreadsheet, please show how the Cash Balance and the available Balance are calculated. 3) Did you notice anything unusual about the accounts? 4) What functions of Excel helped you accomplish the task