This practice set uses a fresh equipment rental list. The fees, dates, rates, and payment flags are already entered, but the sheet still needs its calculations and display formats. Decide whether each task changes the stored value, a formula, or the way a value appears.
Use the fill shortcuts when several rows follow one rule. A zero in Days is intentional: that rental was canceled, so its amount should be zero. A zero deposit rate is also valid and should display as a percentage rather than disappear.
The Paid column contains Boolean values, the same values that checkboxes store. COUNTIF can count TRUE or FALSE without converting them to text. Each exercise starts with a fresh copy, so complete only the task in its prompt.