When your CMOS battery fails the only thing that will happen is your time and date won't stay at the correct times.
When you set the time and date then the date and time can change on it's own to an incorrect time which can affect your ability to load websites that use SSL certificates.
The most common sign of your motherboard battery or CMOS battery being bad is the date and time not being correct on your computer.
If you set your date and time on your computer and it keeps going back to an incorrect time then your CMOS or motherboard battery is likely bad.
The CMOS battery does not prevent your computer from booting but it can affect the date and time on the computer which can cause errors with loading websites that use SSL.
The CMOS battery when dead does not affect the computers booting or operating ability.
However when your CMOS battery goes bad the date and time on your computer can be affected and the date and time will not be correct.
That can affect your visiting of websites or logging into websites if the time and date are not correct.
It can also cause errors with SSL if your time and date is not correct.
CMOS batteries last between 2 and 10 years before they go bad and need replaced.
A CMOS battery will typically last the life of the computer and most people will replace their computer with a new one before they need to replace the CMOS battery.
The CMOS battery is always being charged when the Laptop or desktop is plugged in so it does not really just go dead.
By the time a CMOS battery goes bad in a computer it's usually time to replace the entire computer with a new one.
But you can buy new CMOS batteries and replace them easily.
Just make sure to unplug the computer before replacing the CMOS battery.
You can buy CMOS batteries online such as through Ebay for pretty cheap.