Back to lesson
1. What of the following is not one of the four input methodologies?
Percentage and Growth Rates
2. How do you create an in-cell dropdown box?
Create List (CTRL + L)
Click ‘Data Validation’ in the ‘Data Tools’ group of the ‘Data’ tab of the Ribbon (ALT + D + L)
Select ‘Combo Box’ from the activated dropdown ‘Insert’ menu in the ‘Controls’ group on the ‘Developer’ tab of the Ribbon (ALT + L + I + B)
3. What is the point of the styling adopted in cell J58 of the example?
This highlights that this cell is deliberately blank and should be left this way (i.e. do not insert data or formulae in this cell as it may affect calculations elsewhere)
Excel displays this when there are two or more incompatible styles in one cell
This highlights that the percentage is to be ignored in this cell
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement