How to Pass Advanced Excel Test for Job Interview: SUMIFS Formula Questions and Answers [+XLSX]

[@OnlineTrainingforEveryone]

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

[@hasnulfitri2115]

excel for interviewed test, this is the right yotube channel for the candidate of the test.

[@OnlineTrainingforEveryone]

Thank you very much for the kind words! Good luck in your learning journey!

[@MrKurber]

You are awesome. I have an excel interview assessment in a week and feel very confident thanks to your videos.

[@OnlineTrainingforEveryone]

Best of luck! Thank you very much for your kind words! Thank you for watching and leaving a comment as well. Please check out my other videos on Excel kzbin.infosearch?query=excel You can also check out my website for other 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!

[@saasa2761]

Thank you Vadim for these Excel insights. I find them very useful. Keep it up!

[@OnlineTrainingforEveryone]

Glad you like them!

[@Leauda]

Had a test that covered these topics, and got a little confused on the last one. 1. Write a VBA function that changes the cell value. Create a button to increase the value by 1. Name this button "Higher". Then create a button below it that will decrease the number by 1 and name it "Lower". 2. Do your best to write a formula that will automatically calculate total price for any amount of units placed in Cell 9. Unit Quantity Price per unit: Below 5 36 5 to 10 34 11 to 30 31 31 to 50 26 51 above 20 # of Units = (C09) Total Price =(Formula??)

[@patrickgatti4868]

Let's say we choose cell A9 to input the # of units. The formula... =IF(A9=5,A910,A930,A950,A9*20,0)))))))))

[@patrickgatti4868]

Both formulas are accurate, but this one is slightly more efficient (notice the difference in the first AND function) =IF(A94,A910,A930,A950,A9*20,0)))))))))

[@lewisross9376]

I love your videos. I do not know what i am doing wrong, but I am following this video along and my calculations for the first 2 questions keep coming up as 0. I have them the exact same as yours and I do not know what is going on?

[@OnlineTrainingforEveryone]

Thank you for the kind feedback! What version of Excel do you have? You might want to update it to the latest version, because that's what I use. Please let me know if it'd help. Thanks and good luck!

[@manisymone8622]

@@OnlineTrainingforEveryone kjk

[@MrKurber]

Put the product/name of it in the quotation marks. The video missed it

[@Dravenousone1]

Your other vids have been great... this one... no. Very confusing due to not actually showing parts of the steps

[@OnlineTrainingforEveryone]

Thank you very much for the honest feedback! I'll check this video and will try to fix whatever isn't clear. Please make sure to subscribe to my channel if you haven't done it yet. I'm working on creating new videos and considering all suggestions that viewers leave here for me. Stay tuned :)

[@DebzillaTV]

True/False question 3 in your video appears to be wrong. The question says SUMIF not SUMIFS. So, the answer should be False.