6 hours 3 minutes
Okay, so we are now at the end of model four and we're now going to do the labs. I strongly suggest that if you have opened this video first,
you don't watch it through the end. Instead, you should open the Model four labs Excel file and try to do labs by yourself. You get stuck. Look, ATT, the instructions and
or this video. So, um, in this labs, we're going to create exchange rate software secretary, not exchange rates after, but the exchange rate table, which automatically give you the,
exchange rate and the amount in all other currencies according to one that you pick up. So this is our basic exchange rate table
that represents Ah,
the data we have pre entered
and now in Ah ah, tab model for labs. You should create
a table like the one that you have seen in the instructions,
a pdf file that comes with this labs.
So it should have exchange rate calculator as calculator as ah, heading.
And then it should be a date here, and we're going to use today function which give us today state,
and then we're going to merge these cells so that
it looks nicer and we're going to change the size.
So it looks like it is supposed to look like
and we're going to
change with size
like this. So it fits so that everything fits in.
And then we're going to set the comet equal for all of these cones
just to make it look nicer again. We're going to merge cells
see we have changed the front size and color
big runs size.
And now we are.
I'm going to use data
change rate Basic table.
we're going to go again and copy these files. We could type them as well, but this is easier thing to do.
So the idea is that if you're looking, for example, how many years dollars is worked all other currencies,
you're going to just enter the amount for us dollars,
and the stable is going to calculate everything for you.
So we're going to make them
so that they match the
the colors that we have given is a task.
this is a little bit of former thing
We have used the former pager command to copy
the former. It's off
that they mentioned color.
now we have finished the formal thing,
and now we're going to enter the formulas.
So you're going to see
for U. S dollar? It's the U. S. Dollar. There is no calculation.
And now we're going to use the exchange rates to calculate
the well use.
And of course, we can also named the cells.
So for example, this one we're going to call us dollar two euro
and this one will be used Dollar,
and so on and so on.
And we're going to continue that with all off the cells.
So now we're at the end. I just kept the naming of the cells because the logic is the same everywhere.
So now Hungarian forint to Canadian dollar
and her guarantee, for instance, ground.
And now we have finished
the naming of the cells,
as you can see.
So instead of reference to the cell
with sheet name, you're just going to say you is don't Euro and you get to the
list off all the names that we have defined that begin with the same name. So we're going to basically
do this for all off the cells.
Okay, so we have done it for years. Dollar.
And now we're going to follow the same logic
for all the other cells.
Yeah, conversion from euro, too.
than two Canadian dollar
and so on. So so were we skipped
a few steps, and now we're at the end.
So just remember that on the day agonal of this table,
the formula should be equal just
before or C four or D for
up to g four.
Because we don't
We don't need the conversion from the currency to the same currency. So it's always
I just need to do some corrections.
And this is it. This is our table.
We have done the finished lab, and now we just have to hide the exchange rates
We're going to hide it,
and then we go to protect World Book,
and we add password for opening the exchange rate table
tab so that you can
later at it if needed.
I just entered the default. Want to three password? Never do that by yourself.
And now just a test are
This is what this calculator should
act if done properly.
LPI Linux Essentials
LPI Linux Essentials practice exam helps to prepare for the LPI Linux Essentials 010-160 certification ...
Being an intermediate level user of Excel can help save a user hours of work ...
9 CEU/CPE Hours Available
Certificate of Completion Offered