What is an example of a disjointed range designation in Excel?

A disjointed range in Excel consists of two or more separate ranges that are not contiguous. For example, if you want to select cells A1 to A5 and C1 to C5, you can specify this disjointed range as A1:A5, C1:C5 in a formula or function. This allows you to perform operations on non-adjacent cells simultaneously.