 Hi, my name is Vera Cole. In this quick video, I'm going to show you how to use the sort and some features in Excel to answer the analysis questions for lesson nine. Okay. To answer the questions in lesson nine, we're interested in looking at the data from the annual data year by year. So we want the rows that we want to sort are the rows that contain the annual data. So we're going to left click on row nine and we're going to hold the left button down and drag and select row nine through row 71 so that we've selected just the rows that have the annual data. We want to sort these rows. So we're going to click on sort. And what question, how we sort depends on the question that we want to ask. For this first one, you know what? I'm going to help you with the very first question of the assignment. We want to know what year we use the most fossil fuels. Okay. Well, where's our fossil fuel data? It's in this column right here, which is column U. Column U, it's got a fossil fuel data. So we want to sort by column U. And we want to know the year we use the most. So let's say largest to the smallest. Okay. Now Excel just reorganized our rows, put them in a different order so that now the top row is the one where we have the largest amount of fossil fuels used. And that was in the year 2007. So the answer to the first question would be 2007. And that's the amount of fossil fuels used in billion BTUs. Okay. Let me show you now how to use the sum feature. Before I say that, I will say that these sort that we just did, you can repeat that sort and you can sort on different column values to answer different questions in the assignment. Okay. To use the sum feature, we're going to use one of the built-in functions in Excel called sum. So whenever you want to use it, do a calculation, you begin with an equal sign to equal. And I'm just going to pick any empty cell to do this in. I'm going to say equal, sum, open parentheses. And now I'm going to tell Excel the data that I wanted to add up. So let's look at the, in the five years that we use the most fossil fuels, how much did we use? I'm going to, so I'm going to select those cells. One, two, three, four, five cells. I'm going to close parents. I'm going to hit enter. And Excel just gave me the total for all the, all the information in those five cells. Okay. I hope this helps you. Enjoy your assignment.