Microsoft
MicrosoftSergeiBaklan Mourad-Louha ExcelExciting
This is some great discussion about how Excel can explore being more user-friendly for function arguments to aid in audits and clarity for laying out your data. For some context on our choices, Excel will typically NOT change arguments to your formulas when input as strings, so if you put in "1/2/20" as a string into this function in the UK that would be February 1st and in the US it would be January 2nd. But if you put "1/2/20" in a cell from the US and then referenced it in your formula, Excel doesn't 'see' the date formatting, it sees the number 43832 and so you and the person in the UK would see the same data. In the same vein, Excel typically uses numbers to represent defined properties as inputs to formulas (sometimes called ENUMs) to simplify these cross international concerns.
You will notice that the "headers" (or other information that is returned as a result of formulas) will be 'translated' to show in the language your Excel is in. This is often what happens for the outputs of formulas or for things Excel controls. We like to give you control over the input, but we can sometimes be smart about the output. So this isn't to say that we couldn't include textual inputs for properties, we just haven't added the additional translation layer into the system, and would introduce complexity for sure. Thanks for suggestion and the UserVoice, if this gets traction, we could revisit it.
Sorry for the long-winded explanation. Hope some of that helps.