The majority of people using Excel in a business environment at least sometimes use those functions, even if most don't actually understand them.
There is just about always someone in the office/department who "knows excel" well enough to use the Macro Recorder and occasionally tweak something in the code, and that's enough. So they get the task of automating the thing in the spreadsheet and then everyone else uses it.
Yes they do. Maybe not the majority of users but enough to be important. There are a lot of very smart and math savvy people who don’t know how to program but do very complex stuff in excel.