Question: which one of the following options cannot be used in an excel spreadsheet formula?
Answer: The ampersand is unable to be used in Excel because it is a command code. This command is used to join two or more text strings or words together. However, there is a word around. To use & in Excel, put two ampersands together with no space.