How To Pass Excel Pre-Hiring Assessment Test

[@OnlineTrainingforEveryone]

Download Top 50 Excel Test Questions PDF eBook: www.howtoanalyzedata.net/zcmg

[@jacksonvaneekeren5660]

20:36 answer B has B1 B2, B4, B5, and B6 included but skips B3. It also includes B1 which is a cell with words in it not a numeric value Edit: at 20:55 answer B changes to replace B1 with B3

[@daniellegonsalves6809]

Thank you! 😀

[@OnlineTrainingforEveryone]

Thank you for watching and leaving a comment as well. Please check out my other videos kzbin.info Many more great videos there to choose from You can also check out my website for extra materials that would help you to get ready for an interview or learn new skills. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

[@xenthiamang9739]

Thank you 💗

[@OnlineTrainingforEveryone]

You’re welcome 😊

[@beaudale9039]

I appreciated the content, but too large a portion of the time was spent asking for like, subscribe, etc. I understand asking viewers for these compliments and I normally would have done so, but this was repeated in some fashion after EACH question.

[@OnlineTrainingforEveryone]

Sorry about that Beau! I stopped doing that - I was following youtube suggestion asking for subscriptions. You're correct - it was overboard. Please check out my other videos - perhaps you'll find them helpful and no begging :) . Good luck in your learning journey! kzbin.info

[@beaudale9039]

@@OnlineTrainingforEveryone Thank you for your reply! I have not checked out any other videos yet, but I will do so. Also, I will change that that "Like" rating once I have watched the other videos!

[@mimibooknerd408]

On the last question in the video, I understood how to use Data Validation to create the drop down menu, but I'm curious what formula or method was used to display the Total Sale Value based on the drop down menu selection. When recreating it, I used the IFS function, but that seemed very inefficient.

[@OnlineTrainingforEveryone]

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. There're so many great features in Excel - please keep learning! kzbin.infosearch?query=excel Many other great videos are also available here kzbin.info 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!

[@toreyburse1324]

VALUESHEET!A1 I didnt need to use the single quotes .

[@OnlineTrainingforEveryone]

Thank you so much for watching 😀 Please check my other video tutiorials which I add regularly. There's lot of great and helpful information there. Please don't ever stop learning and good luck in your journey!