all of the following statements regarding the use of a spreadsheet to prepare a statement of cash flows are correct except: multiple choice analyzing noncash accounts can be challenging when a company has a large number of accounts and many operating, investing, and financing transactions. the use of a spreadsheet is an optional step in the preparation of a statement of cash flows. the use of a spreadsheet to prepare the statement of cash flows is a required step in the accounting cycle. the beginning and ending balance sheet amounts are entered on the spreadsheet before any of the other procedures for completing the spreadsheet are performed.