all right so today i'm going to take linkedin excel test and see if i can actually pass it
so i guess we'll find out if i know anything or i'm a fraud so i'll just go ahead and
click on this i have some worries about this test i'm not sure what's going to be on it
hopefully it's not going to have some stupid questions about formatting and things like that
also i'm worried about like version differences when they ask you something that could be possible
in one version but not in the other we'll see how it goes so i'm gonna click on this microsoft excel
c tells me 15 multiple choice questions i have one and a half minute per question
and i need to score in the top 30 percent to earn the badge which i don't care about
i just made this uh fake account so i can see how this works out so i'm not gonna practice
i'm just gonna go right to it hopefully i'll be able to pass it
i'm curious if i'm allowed to open excel while i'm doing this one and a half minute
per question that seems to be quite a long time anyways so let's click start and see what we get
so which value is returned when we enter this function into cell g5
g5 so g5 is going to be
this one right here so it says if
e5 basically this if this is greater or equal to two which it is i guess i don't have to
check the second or anymore because the e is already greater than two so
then it's gonna just give us this monitor closely so
hopefully i didn't miss anything so seems to be no errors in the
formula so we'll just do this and hit next all right so which function when entered into
cell b7 calculates the range for average co length okay whatever that means so
b7 so let's see what's in b seven here so calculates the range of average coal length
so this is called length so i guess we should just get a
range oh okay i see so basically it will be the difference between max and
min i guess that's what we call a range here so then it would be b2 through b6
the max minus the min the same thing so this should take care of it
hopefully i got that right i'm not sure about this one
next let's see which function when entered into cell g7 again g7 g7 here
allows you to determine the sum total of annual sales for market region 18 and greater market
region 18 or greater so i guess that's going to be some sort of sum if function so let's take a look
uh it says in g7 right yeah g7 so i guess it doesn't matter where you enter the function
it's going to be the same thing so if we do sum if so did they do some ifs no sum if so in sum
if i think some range goes last which is kind of weird always uh but i hate it so therefore we need
the sum range g column to be the last range so it looks like it's going to be this one so g2 through
g6 that's the sum range so f would be this market region and we basically want it to be greater than
or equal 18 18 and greater yeah seems to be the right one so let's hit next and see what's next
all right what is colors inventory referring to here so that should be table
column in this case the inventory column in colors table yeah that seems to be the correct
thing the colors worksheet in the inventory workbook no the inventory worksheet in colors
workbook no and named range no name ranges cannot include square brackets so it's the first one next
how can you drill down into a pivot table to show details this is just double click basically
select the cell into which you want to drill down right click and select drill down maybe that's a
possibility i don't know select the cell into which you want to drill down and double click
that seems to be definitely right and select the cell into which you want to drill down right click
and select show details summary page select the cell see like this is what i consider a
meaningless question what difference does it make this doesn't show like you know something it just
shows that you remember how you got there anyways should be this one next from which field
list was the pivot table created from which field list was the pivot table created okay let's see
uh so it should basically have amount in values and then it should have two things in rows what
seems to be event and donor maybe this is really small how am i supposed to see this so let's see
this seems to be some amount that's right uh donor event this is not right it should
be event and then donor so this would not be it this would not be it this would not be it
there we go so event donor sum amount in values that should get us this pivot table so this
first one then break it down to the second one in rows both and then they change it to like show as
uh design tabular form or something it's one of those maybe this is not the tabular this
is the other one outline i guess anyways let's hit next before i run out of time
in this pivot table the continuous variable weight is shown in the row field
another continuous variable is in some values field
it is important to reduce a long list of body weights to a smaller set of weights categorized
how do you do this group it use if no click row labels arrow and then select group
right click on any row field in pivot table and select group that should be basically
you just right click on one of these things right here and you should be able to do that
hopefully i don't understand what they said okay let's hit next
let's see what's next monthly revenues for 2019 are entered in b2 through m2 b2
m2 to get year-to-date running total revenues what formula should you enter
in b3 and auto field to m3 b3 autofill to m3 okay so to get year-to-date running total revenues so
it should basically sum up this and this i guess let's see it should probably be this one so
take a look so b2 and then b2 and then b2 is locked b so if i go right b will stay yeah this
should work so next which is a valid excel formula okay interesting so there should be an invalid
one so this one is definitely valid this square brackets is not valid i guess this
because there's no operator after 7 is not valid this because there's no operator after
parentheses closed is not valid so this is the only valid formula here
okay which excel feature allows you to hide rows or columns with an easily visible expand collapse
oh this i guess that's group cut and paste filtering grouping uh let's read this again
hide rows or columns with an easily yeah that's grouping so that's where you go under data and
you group okay that's that cell d2 contains the formula this one b2 minus c2 so wage minus
deduction okay what is the fastest way to copy the formula into cell d3 through d 500 and one
not the flash fill click d2 field handle and drag it down double click
this this is one of those tricky questions see if i double click on that d2 usually that should work
but the problem is if we have some weird data set and there are some blanks in the middle
depending on a version of excel you're on it may go all the way may stop halfway through so this is
probably what it is but it could also be this one depending on the situation so let's just go with
this and do next and see what's next this data needs to be sorted by group then by last name
okay then by first name how do you accomplish this i guess you just sort this select any cell
in a data set in the data tab click sort button add two levels to the default level populate sort
by fields in the order group last name first name uh group so that all sounded about bright this one
so let's see what are the next ones select cell in a group column then sort
select cell in the last name column then sort and then in a first name column and then sort
uh what was it it's saying group then last name then first name so if i was doing it with
a regular sorting it should go the opposite way you should do first name last name and then group
so then this wouldn't work so then highlight the entire data set in data tab click sort
the headers appear drag the headers into order group last name first name i don't think headers
appear but again this is one of the stupid questions what difference does
it make if they appear or not uh time expired see as i was talking to this i
forgot i'm on time so that should be the right one but i
i'm not gonna get that one apparently uh what feature can you use to populate b2 through b7
with the number from each sentence in a2 to a7 b2 through b7 this is gonna be flash fill
so four four two four zero so there you go i guess this time i'm gonna hurry up because
as i talk through this i'm gonna end up timing out again you are determining percentage growth
by dividing growth by sales okay this by this okay which excel function would you use to avoid
div 0 error if error i guess yeah well this is interesting because divide
i think if you are in power pivot divide has an option to basically not get those errors but
the regular divide i think acts the same as division so we're gonna go with if air
what excel feature can you use to automatically format cells that are greater than a specified
value with designed feel and text colors i guess that's going to be conditional formatting
yeah that's that view results so i definitely messed up one of them i
mean top five percent of 13 million people so i think i just missed one
but then i don't know maybe i did some mistakes i wish it told you like what questions you got right
patch
no thank you so there is no way to check the results
so there you go thanks for watching please subscribe and i'll see in the next video