8 hours 33 minutes
Okay, we have a ride of the end of this macho, and we're going to do the short recap, and I going to give you the guidelines for the exercise file that you will be able to find under resource is stab off this course.
So in this macho, you have been able to learn the detailed explanation off some malfunctions text functions in for functions or information functions and look up functions. Um, when I say selected or ah group of functions in each,
it's like that set the functions in each group.
Um, I have chosen those to match the level of this course, which is intermediate course. And also, I have excluded
the functions that have some kind of niche usage, for example to economically functions I abused by people who need them in their populations, for example, engineers or somebody doing some math calculation geometry.
Um, and they're pretty much simple to use, and they're basically not interested. Interesting for general population off axel users, Um,
so after you have learned all of this functions, it is time for you to do your exercise. And the exercise file for module tree has four,
uh, exercises for tasks.
So the 1st 1 is that you're given a list of invoices sent to a group of customers With their status status can be paid or pending
in S O F. Three. You have to make a formula that will calculate some off influences that
comply with both. Criterias directed from dropdown List and sells F one and if do and let's clarify that a little.
So I have invoice number, which is basically not interesting in this
task. You have customer name I should have just placed ABC doesn't matter the names of the customers. Then there is amount. And then there is status paid and unpaid. And here you can have
customer A, B and C
status could be paid and paid.
And upon a selection, you should calculate the total amount of invoices that are, for example, in this case for customer A and that they're paid or you can just select unpaid. So this formula should work. Whatever the selection off these is
is in sell off S L. A. One of the worksheet us do You're given the sentence with misspelled upper and lower case Little's letters, and you should make a formula that will just to correct spelling. So the first letter of the sentence should be upper case and all the other should be lower case
because we don't have names in this sentence. Um,
in sale. A wonder is the drop down a list of increasing numbers and letters
in cell to create formula that will calculate square root of the number.
Or just copy the content is sell a one doesn't contained in America, will you? So here we have a drop down list. Didn't you see what we can have? A king? 498 25 Q et cetera.
So here you should make a formula that will simply
calculate with square. Oh, do whatever you have selected here. If this is a number and if this is ah, something else, then it should just copy the cell
and final tusk
in cells. Ah, a two
to a seven.
It was a typo. I will correct it and their names of, uh, contestants in the race and this is their position at the end of the race. So else it was, for instance, on some.
So here we have a drop down list with the
and in this cell cell C three, you should calculate
ah list the initial culture. You should retrieve the address of the cell
off with containing the name of competitors. Er, that has finished.
As the selection says. So if it's one, it should be Elsa. If it's five, it should be beat.
So he's the winner. But here, you don't want to put his name. You need to put the address of this cell.
So, for example, if it's five and it's beat, it should be a
So you have to make it for formula that we retrieved that address
and that soul for the,
uh, this exercise file. I hope you'll solve it without any problems. If you still have some problems, you should look. ATT The Salt exercise file, which is also available. The resources step.
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