Question

explain the use of multiple operation? how can you perform it? how is different from creating scenarios. ​

Answer 1

Unlike a scenario, the Multiple Operations tool does not present the alternate versions in the same cells or with a drop-down list. Once the alternative values are created, you use the Multiple Operations tool to specify which formulas you are using, as well as the original values used by the formulas.

ʜᴏᴘᴇs ʜᴇʟᴘs ʏᴏᴜ❣️

Answer 2

See attachment!!!

Hope it helps you