What type of variable would you use to track if records should be shown or hidden in a worksheet?

Using a Boolean variable is the appropriate choice for tracking whether records should be shown or hidden in a worksheet. Boolean variables can only hold two values: true or false. In this context, a true value could indicate that the record should be shown, while a false value would signify that the record should be hidden. This binary nature aligns perfectly with the need to toggle visibility on or off for specific records, allowing for efficient and straightforward control over display logic in a worksheet.

Other options, such as text or quantity variables, do not fit this specific requirement effectively. Text variables are used to store string values and wouldn't be suitable for making binary decisions. Discount variables, while they may hold numeric values representing discounts, don't specifically address the need to denote visibility. Overall, the Boolean variable is clearly the most suitable for the task at hand.