quiz

1- To improve the Quick Insights supplied to your dataset’s users, what should you do? (Select all that apply.) i. Hide columns that don't return useful results. ii. Display only one date column. iii. Hide redundant columns (e.g., keep StateName, hide StateAbbreviation). iv. Rename columns...

Hi, I'm trying to compile a "leaderboard" for our weekly quizzes, which since the start of the pandemic have become our mainstay social activity (and good fun they are too). It's only among friends but can get pretty competitive! I have produced a spreadsheet to record the weekly scores, but...

Question: Supposed that the above percentage (I got 49%) is a probability that a county has it's unemployment rate higher than the average unemployment rate. You visit 5 other counties in the region, what is the probability that at least 3 counties has a high unemployment rate? I can't show...

Hi All. Didn't find anything in the search results for this. Apologizes if it has surfaced before. Building a quiz and need VBA code to randomly re-arrange cells within a given range. Answers to the quiz are one an "Answers" worksheet. Cells A8:O13 are linking to those answers. Starting...

Hi, I want to organize a quiz with multiple choice questions (a, b, c & d) which I send t the participants by e-mail. I would like to register how they score per question but also how long the participants have to think for each question. In other words, from seeing the question until they...

I am trying to figure out the best way to create a multiple choice Quiz from excel that can be printed for students to fill out. what i have is Sheet 1 is full of test questions in Column A (rows 1 to 100 and growing) in columns B,C,D and E are the answers for the question on that row. I can...

I need to figure the average of the 4 highest of 6 quiz scores for a class that I am teaching. I drop the two lowest scores, but those are the two lowest submitted quizzes; a zero (= student skipped the quiz) does not count as one of the two dropped. So: a sample student has these six cells...

I am using Excel 2013. I need to create an outcomes report by analyzing the data from a test that students have taken. I am reporting only on the number of students who properly identified the correct answer. Some of the questions are “Select All That Apply," meaning that students may have...

Hi, does anyone know if you can use the codes from module to call/retrieve multiple sheets. I have created a quiz(game) and I wanted to add "level difficulty" in my quiz. For example, Users can choose to select level 1(beginner), level 2(advanced) and so on from the home page(user form) of the...

I am a teacher and I am trying to incorporate more technology when it comes to exams. Here is the scenario. Students take an exam online using google forms. The data is put into a spreadsheet. Unfortunately the student does not get a printout of their exam and which ones they got right or...

Hi, I am trying to create a multiple choice test in Excel 2010. I know nothing about programming in VBA. :( I would like to thank Joe Was for his excellent contribution on creating a MCQ quiz in Excel. I have compiled the following code from his various posts. However I have two questions...

Hello everyone. I'm very new to using userforms in excel. I want to create a simple userform that will pop-up when you click on a cell in a worksheet that will ask three or four simple yes or no questions and score the answers yes =1 / no = 0 and then return the score in the cell clicked. Can...

Hello, my problem is following: I have a quiz with 40 questions and with only 1 correct answer for each question. My students will submit their answers on paper and I would like to input them into excel in order to produce statistical data swiftly. I am unsure about implementing this, because...