Multiple Choice
Which of the following items should be subtracted from the book balance during the preparation of a bank reconciliation statement?
20
views
6. Internal Controls and Reporting Cash
Bank Reconciliation
Struggling with Financial Accounting?
Join thousands of students who trust us to help them ace their exams!Watch the first videoMultiple Choice
If the formula in cell D49 is '=C49+B49' and it is copied to cell E49 in a bank reconciliation worksheet, what will the formula in cell E49 become?
A
=E49+D49
B
=D49+C49
C
=C49+B49
D
=B49+A49
Verified step by step guidance1
Understand the concept of relative cell referencing in Excel: When a formula is copied to another cell, the cell references adjust relative to the position of the new cell.
Analyze the original formula in cell D49: '=C49+B49'. Here, C49 and B49 are relative references to the cells in the same row.
Determine the new position of the formula: When the formula is copied to cell E49, the column references in the formula will shift one column to the right.
Adjust the formula for the new position: The reference to C49 will shift to D49, and the reference to B49 will shift to C49, resulting in the formula '=D49+C49'.
Verify the adjustment: Ensure that the new formula maintains the same relative relationship between the cells as the original formula.
4:57mWatch next
Master Bank Reconciliation:Bank Column with a bite sized video explanation from Brian
Start learningRelated Videos
Related Practice
Bank Reconciliation practice set
Problem sets built by lead tutorsExpert video explanations