________ is a what-if analysis tool that finds a specific value for a cell by adjusting the value of another cell

The Consolidate feature cannot create ________ to the worksheet that contains the consolidation

Fill in the blank(s) with the appropriate word(s).

Fruit is an enumerated type with values apple, banana, grape, and orange, in that order. Which of the following statements assigns the value orange to the Fruit variable snack?

a) snack = orange; b) Fruit.snack = orange; c) snack = Fruit.orange; d) snack =Fruit.last(); e) snack = Fruit(4);