What can Excel be used for? Is it only capable of storing name list? Or to perform summation or tedious calculations? That is what a lot of people thought. The truth is, Excel can do more powerful things than that. One of the interesting things that it can do very well is forms, e.g. survey forms, feedback forms, etc. We are not talking about forms with boxes but form with dropdown list, option buttons and/or with check boxes, something like the form given below:
It is useful to create forms in Excel because by putting the answers in one row through links, users just need to copy and paste the answers into a consolidated worksheet. Thus saving time on consolidation.