Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Open the spreadsheet and click in cell B 1 . The cell should have the number 1 7 9 9 in it . Hold down

Open the spreadsheet and click in cell B1. The cell should have the number 1799 in it.
Hold down the 'Shift' and 'Ctrl' 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 'Ctrl' and 'c' to copy]
Click on the plus sign on the bottom of the screen to open a new sheet.
Right click in cell A2 and find 'Transpose' under the 'Paste Options:' Choose this. All of the data should now be in a column instead of a row.
Type the word 'Year' in cell A1.
In cell B1 type the word 'Afghanistan'. Go back to the first worksheet, click in cell B2, and select ail the data to the right by using the 'Shift' 'Ctr' 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?
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application Development And Administration

Authors: Michael V. Mannino

4th Edition

0615231047, 978-0615231044

More Books

Students also viewed these Databases questions