PPC4YOU.COM Mobile News.

PPC4YOU.COM Mobile News.

Latest collection of news from a number of reliable sources.

How to Create a Quiz on Your Mac

Oct 21 2014 9:36PM EST | Source: MacLife.com

Improving your Numbers skillset can take some effort, but with this tutorial we can have a little fun at the same time. We’re going to design an interactive quiz you can use just for kicks or for educational purposes, then share it with friends and family — and it'll let you brush up on some spreadsheet techniques as well.

Our basic quiz lets you ask a series of questions — some with accompanying sounds, photos or even movie clips — so you can invite players to select the correct answer from a drop-down menu. If they answer correctly they score a point, and a final tally (along with a rating) is kept at the bottom. All that leaves you with is the job of populating the Welcome sheet with your quiz’s title, plus some introductory text.

 

1. Get Started

Create a blank workbook in Numbers. Click "+" next to Sheet 1 to create a second sheet. Rename Sheet 1 to “Welcome” and Sheet 2 to “Questions” by right clicking on the sheet names. Save, then switch to Questions. Resize the table to five columns, then resize each column as shown, with A as the widest.

 

2. Set up Headers

Click Format in the upper-right corner to show the Format Inspector, then set the row headers to 0. Next, type “Question” into cell A1, “Select your answer here” into B1, “Correct?” into C1 and “Score” into D1. Type “Answer” into E1. Select the header row and style it using the Format Inspector’s Text tab.

 

3. Add Choices

Type a question into A2, then select B2. On the Cell tab on the Format Inspector, change Data Format to Pop-Up Menu. Enter possible answers by double-clicking an item to rename it, or tap + for a new one. Click the Start With First Item menu and change to Start with Blank.

 

4. Answers and Formulas

Type the correct answer into cell E2, making sure it matches the answer in the pop-up menu in B2. Select cell C2, enter the formula “=IF(B2=E2, “Yes”, “No”)” and click the green check button. Type “=IF(C2=”Yes”, 1, 0)” into D2 and click the check mark.

 

5. Test the Formulas

To make sure the formulas are correct, select B2, click the drop-down menu and choose an incorrect answer. You should see “No” and “0” appear in cells C2 and D2. Select the correct answer — the cells should update to “Yes” and “1.” Once verified, set the menu back to blank.

 

6. Add More Questions

Repeat the steps for the second question. When you come to fill in C3, select C2 and press Command + C to copy. Next, select C3 and press Command + V to paste in the formula, which is automatically updated to apply to the current question. Repeat the process for D3 using D2. Use the same steps for additional questions.

 

7. Use Multimedia

You can insert sound, movies, and photos into your quiz by using the Media button or by dragging files from a Finder window into Numbers. Take care with photos — if you drag them onto a cell they embed as a background. Resize the row to accommodate the media object.

 

8. Set up Scoring

After setting up all the questions and answers, at the bottom, type “SCORE” into the next available cell in column C. Type “=SUM” into the adjacent cell in column D and select cells in column D from D2 down to the final question for the total score. Select a cell in column E and, from the top menu bar, choose Table > Hide Column.

 

9. Final Result

Add a rating for the player based on their score. Type the formula into the cell beneath the score, adapting for the number of questions and the cell the score is in. For example, if the final score tally is in D12, enter: “=IF(D12<4, “Poor”, IF(D12<7, “Okay”, IF(D12<10, “Very good”, “Perfect!”)))”


ppc4you.com is an Upfront Merchant on TheFind. Click for info. eTrust Pro Certified
Copyright © 2002-2013. ppc4you.com. All rights reserved.

Company and products names mentioned on this site are registered trademarks of their respective companies.