If an Alternate MAC Address was never entered, clearing it does nothing except restart the console because the field is already blank. ... In the early days of the Xbox One, pressing the power button on most consoles puts it into a sleep mode (Instant On mode) as opposed to fully shutting the console down.
Is it bad to change your MAC address?
Changing the assigned MAC address may allow the user to bypass access control lists on servers or routers, either hiding a computer on a network or allowing it to impersonate another network device. MAC spoofing is done for legitimate and illicit purposes alike.
I have recently switched to using a new email account, and as such I want to switch all of my accounts on various websites over to this new email. I have elected to delete old accounts, and restart new ones using my new email, I will not simply want to amend account details.
How to change your Microsoft account name or address
It has been easy so far with things such as YouTube and Facebook, but Apple seems like it could pose some more issues - due to the fact that I have some programmes associated with my account, and I have used it to sign-in on my Mac.
For example, will I easily be able to switch the mac system to sign in with my new account? And will programmes such as Microsoft office, final cut pro x, etc be rendered inactive and unable to be used? Or will they continue to run? I do hope you can help me out. I have recently switched to using a new email account, and as such I want to switch all of my accounts on various websites over to this new email.

I will not simply want to amend account details. I do not know if you purchased Microsoft Office or Final Cut Pro from the Mac App Store.

So, yes it will affect using your Mac, but that is your choice to make.