I feel like a big problem is that a lot of people never learned how to learn.

Adding onto your examples, I’ve also heard about a study once where they were given similar basic Excel tasks. However, you didn’t even have to solve the tasks. Instead, just trying to get help from the help function or searching online got you into the highest skill bracket. That bracket ended up being the smallest group.