8 hours 33 minutes
and the of this module. Let's look ATT past four lessons and make short recap of what you have been able to learn.
first and most important thing you have bean
able to learn
are the pros and cons off use of Harry's.
So the pros are that there is no accidental change of cells. When you, um, do a single cell formula or you define a constant or you may come full range of multi self formulas with Reyes,
they cannot be easily changed by just changing one cell.
You have to select the whole range and type the formula again.
it also eliminates the needs for intermediate formulas, making your worksheet much clearer to read.
you have the ability to do things that are otherwise impossible.
Now cones are
that it can slow worksheet calculation, especially if you have a very, very large number
or multi cell formulas with Berries.
so when you type constance you, it requires two.
Do the exact sells election to be entered, so if you make a mistake, you have to type it all over again, or to just re type it. It's a complicated process, anyway.
and it requires more care, man entering. So if you forgot to press control shift, enter And you have been typing the very complex formula. You mess things up. You have to sometimes do it again.
So, um, these are pros and cons.
Ah, off the other things. You have learned what the right constants are.
What are the,
ah, single dimensional two dimensional rays? And what are the single cell? Ah ah. Think the single cell and multi cell functions with race. Also, you have learned how to use the raise in simple calculations as well as in
much more complex formulas, especially ones that require Look up.
Um, So, um,
now we're going to use these rays much further, especially in the last model where we're going to do some very, very complex calculations
and lookups. Um,
but in the meantime, you should do some practice off what you have learned in this model.
And here is how the exercise sheet looks.
So this is, uh,
this is exercise sheet. You have three tasks, and in the first time you have the instructions. So for task one, you're supposed to create two errors in worksheet task one sheet
using cells a one to see four from Brooke Sheet task one template
one in cells A C
and A four another in cells D one
to defore. Then transform these areas into content, Constance. And then in cells a six to see nine creating area that adds thes two areas. So basically, this is this one template. So you have
these numbers and then on task sheet, you have to create one constant here, then one constant here and then two
making the ray, which is simply adding these two things.
So you'll see that this is not just in America have true and false.
Ah, but it will work Fine. Don't worry.
task to is that he s l e i three off the worksheet task to write to formula that will determine top selling week of the month and year that can be selected from drop down list in cell. I want I to
you have these drop down lists, so you have months
and then you have years.
So, for example, for January 2006 you have to determine make a formula that will determine which is the highest selling
Speak in that
Also, if you change, it should automatically re calculate this.
So this is tasked to and then we have test three. So, in currency of the worksheet,
that's three enter multi. Say, for your debt will,
in both know if both numbers in every rowing comb off A and B are negative. Give their some,
um, it number in Comey's negative income, bees off every row is positive. Calculate their product.
And if they're both positive, calculate the question. So sorry.
So in task tree, you have these numbers. So you have to make a multi cell formula that will expend true cell, See, want to see 14
and to follow these
conditions that were given. So you have to create a MME. Nested if to do this just as a hint.
So thank you ranch for
learning from this course so far
And good luck with your exercise
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand