Microsoft Office: Video - Excel Basics, Using Functions

Written By Mark Slacin

Updated at October 21st, 2024

 

Transcript

Tools and enter the costs into our workload care. So we are going to highlight B3 through E three. Okay? And then over here to the far right, we get functions, different functions that we can utilize within our workbook. And so the very first one, that e symbol's going equal your sum, but if I hit that dropdown menu you get a list of simple functions and then we can click more functions to get a larger list. But for right now, we're just gonna click that e one time. 

And what's gonna happen is after I click the sum, it's going to give me the total of those numbers into this cell, F three right there. So I'm gonna go ahead and click it and boom, there's our list right there. Okay. So now in that cell, you can see here is the function that is being utilized within that cell, right? It's taking the sum of B3 through that colon represents through, so B3 through E three. Now if I see how there's a little square right there, and when I hover over that square, it turns my white cursor to a black cursor. That is the ability to drag and essentially copy and paste a function. So if I were to click that square and drag it down through these next through cells, instead of me having to highlight these and click some, and then highlight the next one, click some, I can click this square and drag it down, and it's gonna copy that sum function for all of those rows, right? 

So now I can see all of this total is to 4 75. Now, just to make sure I can highlight that row. And then down here at the bottom, it always gives me the sum of the cells that I've, I've highlighted. So you can see there 4 75, 4 75, 3 15, 3 15. So I've got the total here. Okay? Now the next thing we wanna do in this information is located on this part of the page in canvas. I wanna plug in the cost of each one of these. So the cost for my coffee is five, a bad 2, 2, 5 T is two 15. The cost of muffins is 80 nines, cost of donuts, and the cost of bagels is 1 27. 

Okay? Now this is a good decibel number and so I can leave those there. And so now I've got my subtotal, I've got my cost. One thing I want to do here is I, these are all prices, right? This is the, this is a dollar amount. So one thing that I can do is I can highlight this entire box here, even the total category that we haven't filled in yet. And I can come up here to the dollar sign and I can change these different accounting options to meet different accounting needs. But most of the time we're gonna be operating in normal dollars. So I'm gonna click that and it can change there quickly, the type of money. And you can see that there's a dollar sign there, okay? And that was just, that sale was looking funny because it was just wasn't wide enough. Okay? So now this is looking more like an accounting type of document where I've got prices, I've got it down to the cents. Okay? In the next video we'll talk about totals and we'll work about our, we'll talk about how to create a formula. But remember, the last thing I need to do here is save it. I can file save, I can floppy disk or command s and save the document.

 
 

 

Was this article helpful?