TASK B: SPREADSHEET MANAGEMENT

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:

$$\text{=IF(D5="Loan Repayment", "Loan Repayment", "Savings")}$$