Does setting the Computer Sleep setting to 'Never' prevent sleep?
Yes. This setting reliably prevents a Mac from sleeping. I've had my iMac set to "Never" sleep for over a year, and it's still running (though its display turns off after 10 minutes or so per the other setting on that screen).