thank u for your wonderful videos on Excel have truly enjoyed watching them it has helped me to improve my productivity at my workplace One small doubt though can I create a user form similar to the one in Excel
You are so welcome! Thanks for the comment. If you are using Office for Business, yes, the form in Excel and Microsoft Forms is very similar. Unless you are referring to the type of form you use for data entry in Excel? It's a little confusing because there is Microsoft Forms within Excel in Office for Business as well as a programmable form for data entry in Excel. Which one do you mean?
Great question! I don't think this can be automatically done in Forms, but I bet there is a flow you could create in Power Automate to help you disburse this. Check out some of our Power Automate videos here to give you some ideas: studio.ua-cam.com/users/playlistPLWSweFpA2PEgo2PZNM36rMv14cCqh_c5p/edit
Hi! What if I want my students to be able to see the results of their test, but don't show them what would have been the correct answer? In case I want them to redo it until they pass it.
I think if you do not mark which answer is correct when creating the quiz (but keep that to yourself) then the students won't be able to see the answers at the end.
Thanks for the question. If you go to the Form edit page, then click the three dots for setting, you can select the option for “One response per person”.
thank u for your wonderful videos on Excel have truly enjoyed watching them it has helped me to improve my productivity at my workplace
One small doubt though can I create a user form similar to the one in Excel
You are so welcome! Thanks for the comment.
If you are using Office for Business, yes, the form in Excel and Microsoft Forms is very similar. Unless you are referring to the type of form you use for data entry in Excel? It's a little confusing because there is Microsoft Forms within Excel in Office for Business as well as a programmable form for data entry in Excel. Which one do you mean?
Great video
Thanks!
can we put time limit or a timer for every question?
Thanks for the question! That feature was supposed to come out in Jan 2022, but I have not yet seen it.
Can we give them a certificate after they complete the quiz if their score exceeds 80%?
Great question! I don't think this can be automatically done in Forms, but I bet there is a flow you could create in Power Automate to help you disburse this. Check out some of our Power Automate videos here to give you some ideas: studio.ua-cam.com/users/playlistPLWSweFpA2PEgo2PZNM36rMv14cCqh_c5p/edit
Hi! What if I want my students to be able to see the results of their test, but don't show them what would have been the correct answer?
In case I want them to redo it until they pass it.
I think if you do not mark which answer is correct when creating the quiz (but keep that to yourself) then the students won't be able to see the answers at the end.
@@MyExcelOnline Thank you for your answer
You're welcome!
How can we add name of the students in Microsoft forms
Thanks for the question! When you go to Add New, choose Text and type Name as the question.
How can you prevent a user from taking the quiz twice?
Thanks for the question. If you go to the Form edit page, then click the three dots for setting, you can select the option for “One response per person”.