Quiz

  1. 1
    Intermediate

    Assuming you select cell D5 which contains a formula. Which of the following commands will show you the cells that rely on D5 for their calculations?

  2. 2
    Intermediate

    Assume you select cell D5 which contains a formula that is returning a #VALUE! Error. Which command will draw arrows to show all the cells that D5 is relying on?

  3. 3
    Intermediate

    Which of the following commands would allow you to step through a formula to see how it is calculating?