### Video instructions and help with filling out and completing is wotc mandatory?

**Instructions and Help about is wotc mandatory?**

Okay when working in Excel I want to point a few things out to you here's an Excel spreadsheet a few things to remember number one do not have any blank columns and as you can see here column B even though it looks like there's something in it there's really nothing in it when you it's all in column a when you click here and make column a wider you can see everything is in column a there is nothing in V or C so to delete those columns I'm going to select them like that then I'm going to right-click and delete the next thing okay you need to determine a unit cost so I'm reading the directions for this assignment this is assessment one and looks like return airfare to and from LAX is five 8815 okay the unit that's for one person the unit cost for one hotel stay according to the directions of 76 20 and daily expense allowance is 27 now quantity that's the number that we're going to purchase for each one unit cost obviously that's a dollar amount so I'm going to select those and I am going to come up here to my home tab and I'm going to click the dollar sign that'll make them all have two decimal places and a dollar sign if you want to adjust decimals you just use these two buttons up here decrease and increase okay number of days obviously that should be a whole number that's number of days and now we need to make a calculation we need to calculate the cost okay whenever you do a calculation in an Excel spreadsheet always start off the formula with an equal sign and then always include cell addresses as much as possible try to avoid typing in actual numbers for instance if I were to in order to figure out the total cost for the airfare I'm purchasing 48 tickets at 588 15 a ticket so I need to multiply those two so I could technically enter the formula like this by putting the numbers in and the a strict is multiplication and then 48 and hit enter and it's going to give you my answer okay however what if later on on this side oh no I don't need 48 I need 50 that would change that to 50 my answer does not change okay I'm going to undo and make that 48 again so here's how instead of using numbers use cell addresses so equal sign I'm going to point and click on the first number I want to use in the calculation then asterisk for multiply then I'm going to point and click on the second number I'm using in the calculation and now my formula is complete so I'm just going to hit enter on the keyboard and now there's my dialer amounts the same as I had before but now watch if I want to change the