If I delete a file on my Mac, is it deleted in my iCloud folder?

If your Mac is using the desktop and documents sharing setting within iCloud, or if you delete a file stored in iCloud Files from your Mac, then the file will be deleted everywhere, yes.

You could try it with a test file created and deleted, of course.