Correct answer for 14:30 is B... right? I see someone else put C, but that wouldn't work because the logic in that function only shows E2 if it is greater than B$6$, and will not include values that are equal to. Since we need to show E2 for all values both greater than and equal to, B makes more sense because it will show 0 for all values less than, leaving any value of E2 that is not less than to populate.
Thank you for watching April and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you very much for watching and for answering TC! Please make sure to watch my other video tutorials - lots of great information available there. Please keep learning as it'd help you to stay employed and enhance your carrier. ruclips.net/user/OnlineTrainingforEveryonevideos
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
6:08 shouldn't that be =EOMONTH($B$2,F1) ? Because the sequences misses out June and skips to July. Excel is taking the (Start Month + #months) or 1+6=7
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
You're welcome Brandon! Thank you for watching and leaving a kind comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well. Please check out my other videos on Excel ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel You can also check out my website for other extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Very sorry Han this video isn't giving you the answers you're looking for! In this video I'm trying to make you think, but I do have video tutorials where I explain everything. Please check out my newest video and let me know what you think about it ruclips.net/video/Op0Kdemme_w/видео.html Many other tutorials are available here ruclips.net/user/OnlineTrainingforEveryone Just type in Excel in the search tab - many different videos to choose from Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thanks for watching Shanta and for answering! Please check out my other videos - lots of helpful information there as well. Please don't ever stop learning - keeps you employed and helps you to advance your carrier. Good luck in your journey! ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Great job Brandon! Thank you for watching and leaving a comment with your answer as well. Please check out my other videos ruclips.net/user/OnlineTrainingforEveryone More great information there to get ready You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and ansewring ! Good luck in your journey! Happy New 2021 Year! Hopefully it'd be a healthier and happier year for everyone! Please check out my website for an additional information and sources. www.howtoanalyzedata.net/resources/
Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well! Great tip! Please check out my other video tutorials on Excel and let me know what you think about them ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel Many other videos are also available here ruclips.net/user/OnlineTrainingforEveryone Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Download Excel Assessment Test PDF Self Study Guide: www.howtoanalyzedata.net/zcmg
The right answer to display the last day of the month is A (EOMONTH(B2:F2,G1)
Correct answer for 14:30 is B... right? I see someone else put C, but that wouldn't work because the logic in that function only shows E2 if it is greater than B$6$, and will not include values that are equal to. Since we need to show E2 for all values both greater than and equal to, B makes more sense because it will show 0 for all values less than, leaving any value of E2 that is not less than to populate.
Thank you for watching April and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
I'm not so sure but I think the correct answer for Question 14:30 is D.
Thank you very much for watching and for answering TC! Please make sure to watch my other video tutorials - lots of great information available there. Please keep learning as it'd help you to stay employed and enhance your carrier.
ruclips.net/user/OnlineTrainingforEveryonevideos
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
6:08 shouldn't that be =EOMONTH($B$2,F1) ? Because the sequences misses out June and skips to July. Excel is taking the (Start Month + #months) or 1+6=7
no, that can only work for the 6th month and cannot be applied as a general formula
It worked fine in testing.
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
thank you
You're welcome Brandon! Thank you for watching and leaving a kind comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
13:41 this answer confused me for quite a while until I realized it's supposed to say "range A1:A4 and range B1:C1"
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Hi, Correct Answer for Quesion 6:08 its (B) =EOMONTH($B$2,G1)
Thank you very much BIl for watching and for answering the question! Good luck in your learning journey!
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
the correct answer for question at 14:30 is d
Thank you for watching and leaving a comment as well. Please check out my other videos on Excel
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
You can also check out my website for other extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
For 09:56 is C?
14:41 is A
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Why is this so confusing to follow can you just give the answer instead of asking us to post in the comments? I have an exam and am left hanging here
Very sorry Han this video isn't giving you the answers you're looking for! In this video I'm trying to make you think, but I do have video tutorials where I explain everything.
Please check out my newest video and let me know what you think about it
ruclips.net/video/Op0Kdemme_w/видео.html
Many other tutorials are available here ruclips.net/user/OnlineTrainingforEveryone
Just type in Excel in the search tab - many different videos to choose from
Lots of helpful information in each and every one of them.
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
I absolutely agree
B
Thanks for watching Shanta and for answering! Please check out my other videos - lots of helpful information there as well. Please don't ever stop learning - keeps you employed and helps you to advance your carrier. Good luck in your journey!
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
A
Great job Brandon! Thank you for watching and leaving a comment with your answer as well. Please check out my other videos
ruclips.net/user/OnlineTrainingforEveryone
More great information there to get ready
You can also check out my website for extra materials that would help you to get ready for an interview.
www.howtoanalyzedata.net/resources/
Please let me know if it was helpful and good luck in your journey!
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
Correct Answer for Question 14:30 is (B)...........=IF(E2>$B$6,E2,0)
Thank you very much for watching and for answering the question! Good luck in your learning journey!
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
c
Thank you for watching and ansewring ! Good luck in your journey! Happy New 2021 Year! Hopefully it'd be a healthier and happier year for everyone!
Please check out my website for an additional information and sources.
www.howtoanalyzedata.net/resources/
Thank you for watching and leaving a comment as well!
Please check out my other video tutorials on Excel and let me know what you think about them
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other great videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!
These videos are so out of order. give the question then the answer to the question simple.
Thank you for watching and leaving a comment as well!
Great tip! Please check out my other video tutorials on Excel and let me know what you think about them
ruclips.net/user/OnlineTrainingforEveryonesearch?query=excel
Many other videos are also available here ruclips.net/user/OnlineTrainingforEveryone
Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!