Ask Your Question

How do mark answers on a quiz

asked 2018-04-28 01:10:34 +0200

rlgreeson gravatar image

what year did franchisee first open

a) 2011 b ) 2013 c) 2015 d) 2014

edit retag flag offensive close merge delete


What has it to do with LibreOffice?

Mike Kaganski gravatar imageMike Kaganski ( 2018-04-28 07:46:29 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-04-28 17:35:31 +0200

Regina gravatar image

You can use a group of radio buttons or a drop-down list, both are form controls. You can bind the form control to a cell, so that you can evaluate the answer using the functions of the spreadsheet. You can put the form control in front of the bound cell, so that it hides the bound cell.

Or you can use the tool Data > Validity of kind list and enter the possible answers in the list. The user can select one value from a drop-down-list then. You can mark answers correct/wrong by using conditional formatting. Here too, you can evaluate the answers using functions of the spreadsheet.

Or using a macro, that reacts on mouse click.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-28 01:10:34 +0200

Seen: 109 times

Last updated: Apr 28 '18