TASK B: SPREADSHEET MANAGEMENT
This business/management problem is solved step by step below, with detailed explanations to help you understand the method and arrive at the correct answer.
ScanSolve AI Answer
Here is the answer to question 1a under "TASK B: SPREADSHEET MANAGEMENT".
TASK B: SPREADSHEET MANAGEMENT
1. Data Manipulation:
a) In the DataEntry sheet, column H, enter the heading "Status". Write a function in cell H2 to display "Loan Repayment" if it's a repayment, and "Savings" otherwise. Copy the formula down for all transactions. Write the formula used in cell H5.
Assuming that the "TransactionType" is located in column D of the "DataEntry" sheet, the formula for cell H5 would be:
$$ \boxed{\text{=IF(D5="Loan Repayment", "Loan Repayment", "Savings")}} $$
