A veterinary clinic is creating a worksheet for vaccination appointments. The receptionist enters animal type, owner postcode, appointment date, fee, and wh...
Question 1 Report
A veterinary clinic is creating a worksheet for vaccination appointments. The receptionist enters animal type, owner postcode, appointment date, fee, and whether payment has been made. The clinic manager needs a formula that applies a 10% discount to the fee for rescue animals only. The result must be copied down without changing the cell holding the discount rate, which is stored in H1. The manager also wants to filter the information to display unpaid appointments for one chosen date.
(a) Create an IF formula for F2 that applies the discount when E2 contains "Rescue" and otherwise keeps the original fee in D2. [3]
(b) Use an absolute cell reference for the discount rate in H1 in your formula. [1]
(c) Create a filter that displays unpaid appointments on 12 October 2026. [2]
(d) Give one reason why filtering is preferable to deleting the other records. [2]
Answer Details
(a) Use =IF(E2="Rescue",D2*(1-$H$1),D2) [3]. A rescue animal receives the fee reduced by the discount rate; any other animal retains the original fee.
(b) The absolute reference is $H$1 [1]. Dollar signs lock both the column and row, so copying the formula down does not change the discount-rate cell.
(c) Filter Payment status to Unpaid and Appointment date to 12 October 2026 [2]. Both conditions must be applied to show only the required appointments.
(d) Filtering retains all records and can be removed or changed to show all information again [2]. Deleting the other records would permanently remove useful appointment data.
Download The App On Google Playstore
Everything you need to excel in your exams
