There is a lot of misinformation about quantum superpositions online, so you need to be careful which sources you use.
The first point to note is that quantum states behave like vectors. In fact, they are vectors in an abstract sense. And vectors, fundamentally, allow the concept of superposition.
In QM, any system is described by its state (or state vector if you prefer). This is often denoted by ##\psi## or ##|\psi \rangle##.
However, we also have the concept of
energy eigenstates for a system and these are often written as ##\psi_n## or ##|\psi_n \rangle##. These energy eigenstates play the role of
basis vectors.
A system may be in an energy eigenstate, in which case we simply have: ##\psi = \psi_5## or ##\psi = \psi_{16}##.
But, the system may instead be in a
superposition of energy eigenstates. E.g., we could have: $$\psi = \psi_1 + \psi_2$$$$\psi = 2\psi_1 - \psi_4 + 3\psi_8$$
Note that the coefficients in front of each energy eigenstate give the relative weighing of that eigenstate in the superposition. This looks very like the more familiar vectors: $$\vec v = v_x \hat x + v_y \hat y + v_z \hat z$$ In other words, a quantum superposition of states is precsiely the same idea as a linear combination of vectors. In that sense, superpositions are really quite simple and certainly nothing new to QM.
But, the quantum mechanical nature of superpositions is seen when we measure the energy of a system in a superposition of energy eigenstates. The result of such a measurement is not a mixture of energies, but one definite energy. We always get one of ##E_1, E_2, E_3 \dots##. The square of the coefficients tells us the probability that a measurement returns that energy value. In our example above, the relative probability of getting ##E_1, E_4## or ##E_8## from a measurement of the state ##\psi = 2\psi_1 - \psi_4 + 3\psi_8## would be ##4, 1## and ##9##. In other words, on average out of ##14## measurements of energy in a system in that state, we would get ##E_1## four times, ##E_4## once and ##E_8## nine times.
This might be a useful video to get you started on QM: