Mrs. Bitner's Classes



Excel SpreadsheetsAssignment #4 – Percent ChangeOpen a new Excel document and Save As “Assignment4Roxy” (your name).Key in the information below. Be sure to adjust the width of the columns to make them as narrow as possible. This way, the chart can be printed more easily. To make many cells the same with, select the letters of the columns (while holding shift) and adjust the last one. The other cells will automatically adjust to the same width. Keep titles as short as possible to keep column as narrow as possible.You can type all the numbers without commas, then select all the cells with numbers and then click on the comma button to insert them. Highlight all the cells with numbers and click on to reduce decimal to get rid of digits after the decimal if they appear.Key the formula to calculate the percentage increase or decrease in GDP from 2015 to 2016. To do this you will indicate the new figure and subtract the old figure (2016-2015), then divide by the first figure (2015) and then multiply by 100 (to make the answer into % since % means out of 100). For row 5, the formula is =(C5-B5)/B5*100You learned, in the last lesson, how easy it is to grab the little green box to carry the formula down. Try this.You likely ended up with numbers that show many places after the decimal. Use the to reduce the number of digits after the decimal to two.Notice that one of the numbers has a minus sign in front of it. What does this mean? Write the answer to this question directly onto your Excel sheet in cell A19. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download