Question

You receive a spreadsheet model from charlene in which cell a10 contains an assumption that sales will grow 10% per year. what button on the ribbon (two-word answer) can you use to determine which cells in the model depend on her assumption?

Answer 1

To determine which cells in the spreadsheet depend on the proposed assumption, we can press cell a10 and display the formula bar to find out which cells are involved in the sales projection formula. This bar often shows the cells that make up the formula being recalled in different colors.

Traducción al español:

Para determinar qué celdas de la hoja de cálculo dependen de la suposición propuesta, podemos presionar la celda a10 y visualizar la barra de fórmulas para conocer cuáles celdas están implicadas en la fórmula de proyección de ventas. A menudo esta barra muestra remarcadas en diferente color las celdas que componen la fórmula que se está calculando.