What are the benefits of user-specified templates?
if you need to have the same layout multiple times
Describe the difference between the functions CLEAN() and TRIM()?
'-CLEAN() deletes unprintable signes from a specific cell
'-TRIM() deletes unnecessary spaces between words or numbers
Why can you not use numeric formatting for exercise 1) above?
Because the "number" 115-, can't be read as a number from excel. A minus sign has to be in front of the number to be recognised as a amount.
"-True=Approx match -->Used for Ranges
'-False=Exacte matches -->If we need to lookup a specific value (e.g. product number)"