Question $1$

$0/1$ pts

Open the spreadsheet and click in cell B$1.$ The cell should have the number $1799$ in it$.$

Hold down the 'Shift" and $\text{'}$Ctrl$\text{'}$ keys and press the right arrow button while holding these keys down.

The entire row of data should be selected for you. Copy this data $($press $\text{'}$Ctrl$\text{'}$ and $\text{'}$c$\text{'}$ to copy.$)$

Click on the plus sign on the bottom of the screen to open a new sheet.

Right click in cell A$2$ and find 'Transpose' under the 'Paste Options.$\text{'}$ Choose this. All of the data should now be in a column instead of a row.

Type the word 'Year' in cell A$1.$

In cell B$1$ type the word 'Afghanistan'. Go back to the first worksheet, click in cell B$2,$ and select all the data to the right by using the 'Shift' $\text{'}$Ctrl$\text{'}$ and right arrow buttons. Go back to the sheet you created and paste it under the word 'Afghanistan' using the 'Transpose' paste option.

Select all the data and create a line chart. If you hover the mouse over specific points you can see the values for those points.

What year was the life expectancy in Afghanistan at its lowest?