How to Pass Excel Test: Questions & Answers

____
LETS CONNECT:

#MicrosoftExcelTest #ExcelTest #OnlineTrainingForEveryone #VadimMikhailenko #HowToAnalyzeDataNet

[anon]

You are amazing!! Thank you for these wonderful videos. Many blessings, Mr. Vadim!

[Mychannel-wxqm]

thank you for your provision of so much valuable information 🙏🏼

[w.tollefson]

Vlad this is awesome information; presented in a good learning style.

[brcguy]

I think you wanted:

=EOMONTH($B$2, G1)

but that gives you the last day in July when the chart wants the last day of June, so:

=EOMONTH($B$2, G1-1)

no?

[XXP]

Thank you for the video Mr. Vadim. My suggestion is to try to maintain the volume stable throughout the whole video so we don't need to constantly change the volume up and down. This can be done by playing with the volume levels in the video editing software.

[amiradam]

23:44 C : =SUMPRODUCT(C2:C5, B2:B5). B is wrong because it doesn't cover till cell 5.

[aprilammons]

what exactly does the 3 stand for in the formula for the vlookup question?

[vivianar.ferrer]

Answer "C" for formula to calculate the weighed average score in cell C8

[JayHennigan]

Brilliant presentation once again Vadim! I have a question regarding finance & Excel and I would be very grateful if you could reply. I have Excel 2016. Is there a way to link live market cap number (or with the option to refresh) from yahoo finance (or any finance website) ?
I'm going into the Data ribbon and clicking on 'From HTML', but I only get options to open files from my laptop. Is my version of Excel corrupt, out of date or is it just that this is just not available for the 2016 version? Thanks

[saphire]

Hi! why the correct answer is not like this: =AVERAGE(B2:B5)?