How to calculate tax on an excel spreadsheet? Help PLEASE!?

I have work interview while in the sales department at the hotel, and one of this interview tasks could be to take some sort of hotel revenue document, with plenty of rooms, along with create a couple columns; one when using the rooms (which I can do) then one which computes the tax per room.When will i do this It is in Excel in life 2007 and Concerning such a difficult time with them! Any Surpass tips could well be greatly valued.

Let say you’ve got this columns
—–A—————B
JUST ONE Rooms———-Tax
TWO 170————–
Around the place regarding type =A2*0.075
Each personal is referenced when using the column letter along with the row number
discomfort the 1st cell name are going to be a1, as well as cell name the place that the is named b2
Thus for our example
“=” is employed always when preparing for your formulas
“A2” will be cell reference belonging to the first room price
“*” is needed for multiplication
“0.075” is the number of sales tax or utilize whatever they provide you with on this place
if you’ve got a multiple Place prices and needs calculate for most of them
you don’t need to put a solution for each of them Excel do it for you personally.
The best thing to can is as soon as you type your own formula at cell B2 hit Enter
then visit the cell again then whenever you point into the bottom proper side of the cell A2 the
usual mouse pointer of Excel that’s White Cross is evolved to dark cross then
drag it for the last cell you will have your locations.Good luck along with your interview.