Question

5 type a formula in the highlighted cell (c13) to pull from the 2/1 entry on the journal sheet.
6 highlight all debit normal balance account titles in green
7 put a border around the ledger title at the top of this sheet.
8 total assets is calculated below. type a formula for debt to assets ratio.
580 =total assets
=debt to assets ratio
9 insert a text box below this. type your name in the text box.

Explanation:

Step1: Answer for question 5

Assuming the Journal sheet is named "Journal" and the 2/1 entry is in cell A1 of that sheet, the formula in cell C13 would be =Journal!A1.

Step2: Answer for question 6

In accounting software (e.g., Excel), you can use conditional - formatting. Select all account titles, go to Conditional Formatting > New Rule > Use a formula to determine which cells to format. The formula to identify debit - normal balance accounts depends on your account list structure. For a simple list where account type is in a column (say column B) and account title in column A, and assuming debit - normal balance accounts have a specific label in column B like "Debit", the formula could be =$B1="Debit" and then set the format to green.

Step3: Answer for question 7

In Excel, select the cell containing the Ledger title at the top of the sheet. Then go to the Home tab > Font group > Borders dropdown and select the appropriate border style (e.g., All Borders).

Step4: Answer for question 8

The Debt to Assets Ratio formula is $\text{Debt to Assets Ratio}=\frac{\text{Total Debt}}{\text{Total Assets}}$. If total debt is in cell D1 and total assets is 580 as given, the formula in the cell for debt - to - assets ratio would be =D1/580.

Step5: Answer for question 9

In Excel, go to the Insert tab > Text Box. Draw the text box below the relevant area and type your name inside it.

Answer:

1. =Journal!A1 (assuming Journal sheet and cell location as described)
2. Use conditional - formatting with a formula like =$B1="Debit" (adjust as per your data structure)
3. Select title cell, go to Home > Font > Borders and choose a border style.
4. =D1/580 (assuming total debt in cell D1)
5. Insert a text box from Insert tab and type your name.