Excel Training Needs Assessment for LSE

READ THIS FIRST!!

This Training Needs Analysis (TNA) is a tool to help you find the gaps in your knowledge of Excel. It is NOT a quiz. If you do not know the answer to a question, please click “I’m not sure” rather than guessing.
You can close the questionnaire at any point, and go back to it later. Your work will be saved, and you will start where you left off. However, you MUST reopen the survey using the same computer you started with; otherwise you will have to begin again.
There are 40 questions divided into 5 sections, corresponding to the 5 sequential Excel courses available. You can choose to finish at the end of any section. Work through as many questions as you are reasonably confident of answering. If you find 3 or more questions at one level that you cannot answer confidently, select "I’m not sure" for the remaining questions in the section. Then choose the "Skip to the end" option in the final question of the section.
Ignore the point scoring system; all that matters is whether you get each question right or wrong.
When you finish, ignore the % score – it is meaningless! Scroll to the bottom of the page to interpret your numeric score.

Please provide your LSE email address. Your results from the questions below will be known only to yourself and the IT Training Team.

Type the dates by hand
Type the first date, then use the black + mouse cursor to continue the sequence in the other cells
Use the DATE function in a formula and copy it to all the cells
Type the first date, then copy and use Paste Special in the subsequent cells
I'm not sure

The number format needs to be changed
The formula needs to be changed
When this happens, it is best to type the answer in the cell instead of using a formula
You must use the DATE function
I'm not sure

Select A1:L1 and use Center icon
Move the content of A1 into another cell further to the right so it appears centered
Move the content of A1 into G1, and set the text alignment to center
Select A1:L1 and use the Merge & Center icon
I'm not sure

Click into C1, position the cursor after the word Balance, and press ENTER
Click into C1 and use the Wrap Text icon
Right click into C1 and choose Format Cells. Open the Alignment tab and change both Horizontal and Vertical text alignment to Distributed
Click into C1 and use the Merge & Center icon
I'm not sure
Skip to the end