First of all; Windows Failover Clustering is not a load balancing feature, it's a way to implement high availability for network resources.
So, to answer your question:
Yes and no!
Any clustered service or application is always Active/Passive (online on one cluster node, offline but available to be brought online on one or more other nodes).
Let's assume a simple cluster configuration consisting of 2 nodes (ServerA and ServerB), with 2 SQL Instances (SQLClu01 and SQLClu02).
SQLClu01 has ServerA as preferred owner, SQLClu02 uses ServerB, but they're both configured for automatic failover. When both cluster nodes are up and running, you have an "Active/Active" cluster, in the sense that you have 2 cluster nodes, each with an SQL Instance online.
However, from a service perspective, you still have an Active/Passive configuration, since any SQL Instance is always online on one node, offline on another.