Back to lesson
1. Which is the key reason it is suggested in this session that a row be added before adding different types of conditional formatting?
Spacing rows out leads to clearer calculations and reinforces the notion of transparency
With a row in between, it is more difficult to select the wrong cells for conditional formatting
Excel’s intelligent engine ‘guesses’ that the same conditional formatting may be required in both rows and deleting one format can prove problematic on occasion
2. What formula should be entered into cell J148 (highlighted in the image) so that the cell highlights growth rates should be used in this period?
3. Which of the following is not true about the formula highlighted: =(1-J148)*J150+(J148*I153*(1+J151))?
It is the most efficient way of taking account of the two possible alternative calculations
The formula uses flag logic
This formula could have been written with an IF statement
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement