 Hello viewers, welcome to my channel. In this video, we are going to see how to insert checkbox and google sheet. First, select the cells where you are going to insert the checkbox. Then, click insert menu in menu bar from that multiple option, select checkbox. Now you can see the checkbox and the cells. In the next column, I want to mention the student's present and absent and text as per the checkbox. So, I use if formula to get the output according to checkbox. In if function, logical expression should be the checkbox cell. In value if true, type present in double quotation and in value if false, type absent in double quotation. Now, close the bracket and press enter. Copy pays the formula to required cells. Now you can click the checkbox, the present and absent of the student will update according to the checkbox. Thank you for watching this video. If this video is useful, consider to subscribe my channel and don't forget to like and share the video. Thank you.