Excel Experts Quiz

Question 1 of 13

Which of the following are true?

If I double click on the bottom right of the black box surrounding a cell, it will copy my formula down to the same position as the last non-empty cell downwards one to the left of the cell I have selected

It's possible to change the values on a sheet using a VBA user defined function

It's possible to create a named range that changes in size dependent on values in a cell

It's possible to format text within a cell in a different format to text within the same cell

Pressing CTRL + END will select that last populated cell on a worksheet