zakruti.com » IT - Software » Geeks Tutorial

How to Make a Quiz in Excel 2013

video description

Rating: 4.0; Vote: 1

were going to show you how to make a quiz in Excel. Creating a virtual test or quiz can allow for a great deal of freedom and ease-of-use. Or if you simply wanted to save paper, creating a virtual quiz is a good choice. - join us on Facebook To get started, you will need two sheets. One for the actual test and one for the score. To create a new sheet, click the (+) button near the bottom left-hand corner. To rename it, double-click the default text and type the name On the Test sheet, you will need designated areas to have the Score sheet check After doing so, head over to the Score sheet and type in the answers in one column. In the next column over, type in the following Function: =IF(Test! B15=Score! B2, Correct, Incorrect) Test! refers to the sheet that the test is on and Score! Is the score sheet. B15 refers to the cell that the student places the answer in on the Test sheet. B2 refers to the answer on the Score sheet. When finished, click and drag the bottom right handle of the cell with the Function to encompass all the rows in the Score sheet that have answers. You will probably notice that it is not referencing the correct cell anymore on the Test sheet. Simply change B15 to the next answer cell (in this case it is B26) To automatically create a score depending on how many answers are correct, use the following Function: =COUNTIF(C2: C6, Correct) 5 & Pts. C2: C6 refer to the cells with the =IF function. The output in this case will be 10 Pts because each Correct is worth 1 point 5 with the concatenated Pts. Select the columns with elements on the Score sheet, right-click the letter axis at the top and click Hide (to Unhide, press [Ctrl+A] to select everything, then right-click the letter axis and click Unhide) Right-click the Score sheet and click Protect Sheet. Uncheck all boxes, then type in a password and retype the password (to Unprotect simply right-click the sheet, click Unprotect, then type in the password
Date: 2023-07-08

← How to Make a Table of Contents in Word 2013

Microsoft Office Sway Tutorial →

Related videos

How to Extend Windows 10 Support For Free (Enroll Now)

• Geeks Tutorial

After 10yrs of Testing, This is the BEST Upscaler. Period.

• PiXimperfect

Still Using Drop Shadow Fix This - Photoshop in Minutes

• PiXimperfect

How to Speed Up Windows 11 (Best Settings)

• Geeks Tutorial

I Was Wrong About Chromebooks...

• PC World

How to Speed Up Your Android Phone (Best Settings)

• Geeks Tutorial

Comments and reviews: 6

Penelope
Information was good, but you went a bit to fast and the visual were not clear. I had to pause several times to and squint to see what was being typed in.
reply

heba
How can I automatically collect the final results from hundereds of students quivkly, rapidly and without delays, manual work, and so on. Please?
reply

campupot
Thank you, I really need this for my exams that is to be taken inside the classroom without leaking my exams through Internet, Email, etc.
reply

Kent
I'm studying for the Real Estate Exam and they want $400 for the simulated test. I will use this template instead. Thank you for the video!
reply

Renee
Is anyone able to tell me how long this process takes from start to finish? i. e. how long it would take to make a 20 Q MC quiz? Thanks!
reply

SNO
Hlo boss
Muje quiz bnana btao jis me all ranking shows ho students ki
Aap ki jo bhi fees hogi m pay kr duga
reply

Add a review, comment