Hmm, let's see. I'm going to go with E, F, and G because those sound like the names of my favorite cartoon characters. Wait, what? This is a certification exam, not a cartoon trivia quiz. Time to get serious!
Ah, I see what's going on here. If we're filtering out the sub-category where [Overall Rank] - 1, then the Rank value will change for the sub-categories that are ranked higher than that one. I'm going with B, D, and H.
The question says the Rank is calculated using the RANK function, so it's gotta be the sub-categories that have a rank value. I'm going with A, B, and C. No, wait, that's not it. Let me think this through again.
Ooh, this is a tricky one! I'm going to go with C, E, and G. Wait, did I just pick the wrong answer on purpose to be a rebel? Nah, that can't be right, I need to focus.
Hmm, let's see. If we're filtering out the sub-category where [Overall Rank] - 1, then the Rank value would change for the sub-categories that are affected by that filter. I think the correct answer is B, D, and H.
Linsey
28 days agoReed
1 days agoMisty
13 days agoReita
1 months agoFelix
4 days agoVincent
2 months agoFrederick
16 days agoLaura
1 months agoHector
1 months agoVincenza
2 months agoShakira
1 months agoAudry
1 months agoTaryn
2 months agoAlaine
2 months agoMarquetta
2 months agoDominque
2 months ago