Protected: Excel training dates and prices for 2017

1. What is the shortcut to get todays date in an Excel cell?

2. Which tool do you use to change a cell colour based on the value in the cell?

3. If you need to remove quotes (') from inside an Excel cell using a formula like SUBSTITUTE e.g. the cells shows

'data'

and you need it to show

data

What must be included in the formula you use