Quiz In Excel Using Random Question On Screen
Feb 22, 2014I would like to know how to use macro to create quiz. in the quiz question are appear randomly from the question bank.
View 1 Replies
ADVERTISEMENT
Excel Quiz Question Randomizer
Jan 26, 2014Where I can find a sample of an Excel Quiz question randomizer. I am attempting to create a multiple choice quiz with the capacity to randomly select 40 questions from a total selection of 120 questions.
I've got a handle on creating the questions but I'm struggling with the randomization part.
Check Multiple Choice Quiz Answers
Mar 28, 2008I have a table in excel that i need to use to mark a 20 question quiz. I have the correct answers in one column and the students answers in the next column. I want to mark a correct answer with 1 and an incorrect answer with 0 marks. I know how to use IF, however the students answers can vary eg, correct answer could be B and D but the student writes B + D. Is there any way of marking this correct even tho it is not exactly written out correct?
Excel VBA To Activate When Printing Screen
Oct 19, 2010I am trying to run vba clear clipboard. Not sure how check if Application.SendKeys "(%{1068})", is pressed.
View 5 Replies View RelatedOpening Excel Files - Getting Blank Screen
Apr 29, 2014When I attempt to open a file I get a blank screen. If I try to close the window it asks if I want to save the file so it is must be open but not visible. Have I inadvertently clicked on an icon with which I am not familiar?
View 1 Replies View RelatedExcel - Can't See Worksheet Tabs On Screen Anymore
Oct 12, 2005Microsoft Excel is no longer displayed at the top of the screen, and I can't see my worksheet tabs at the bottom of the screen.
View 3 Replies View RelatedUserform To Always Open In Center Of Excel Screen?
Apr 5, 2010Is there any way to tell a userform to always open in the center of the excel screen? It always seems to open somewhere in outer space on multiple screen setups.
View 9 Replies View RelatedExcel Dashboard - How To Get Data From Other Pages Onto First Screen
Feb 24, 2014I want to get into dashboards, I've looked at video on YouTube etc. I now know how to design them but what do I need to know is what search phrase etc I need to use cos I'm a bit confused. How do I get data from other pages onto first screen where dashboard is.
View 3 Replies View RelatedExcel 2007 :: Screen Gets Distorted And Data Disappears
Aug 12, 2014Excel 2007. Basically, I'll be working in excel and all of a sudden, my screen sort of blurs; gets scramble like below. This only happens when using Excel.
Myscreen.PNG
Excel 2013 :: VBA - Trigger Event On Print Screen
Jun 27, 2014I have a project report, which is user-configurable, allowing the user to customise the data that is displayed based on a number of parameters.
To ensure the report always prints neatly (the number of visible columns and rows varies, depending on the above parameters), so I have a macro that dynamically sets the print area of the worksheet.
At present, I call the macro from the workbook.beforeprint event, which works fine in terms of printing. Ideally however, I would like the macro to be called when CTRL+P is first pressed - i.e. the resulting 'print screen', containing a preview of the print out should reflect what will subsequently be printed, when the 'Print' button is then pressed.
I am not sure if this makes sense (Excel 2010 and 2013 are different from previous versions).
Pop Up Message To State That Excel Is Updating:Screen Update
Dec 6, 2006i was wondering if there is a way to display a pop up message that a stating that the spreadsheet is currently updating.
What i have is a macro running on Auto_Open when workbook is opened. I have switch off the screen updating. What i want now is for maybe to have a pop up stating the spreadsheet is updating. Setting screen updating to false means that my excel freezes for a few seconds. I think users might be thinking that excel has crashed and therefore would like to include the message that the spreadsheet is updating its information.
Excel Camera Tool - Print Preview Different From Display On Screen
Nov 27, 2012I have place a camera-picture of a table on the right side of a chart. On the screen it looks great! (See below - with some redaction)
Problem Example.png
.... but when I print it the table expands off of the side of the chart. Scale is 100%, zoom is 100%, Excel 2010 (See below - with some redaction). Whether or not I have a print area does not seem to make a different in the problem. Also, it appears that this happens with any shape I put in that place, it's not specific to the camera tool.
Problem Example_Print Preview.png
How Do Make Pictures In Excel Full Screen Or Larger When Click
Jan 13, 2014I had a spreadsheet with 17 photos on, one in each cell. I had to resize so you can see them all on the screen. If you have some pictures that are resized to fit in cells, is there any way to double click (or hover?) them and make them actual size or full screen when you want to view them in detail?
View 2 Replies View RelatedExcel 2007 :: Sheet Tabs At The Bottom Of Screen No Longer There
Apr 26, 2012I am using Excel 2007. When I pulled up a workbook today with 3 sheets in it, all that comes up is the first sheet and the sheet tabs at the bottom of the screen are no longer there. I must have accidentlly pushed some button, but I can't get to the other sheets. I really need the information on the other sheets. How do I restore the view that shows the sheet numbers at the bottom?
View 2 Replies View RelatedHow To Clear Contents Of Clipboard Before Tool Takes Screen Print In Excel VBA
Apr 20, 2014I've have a tool/code that takes the screen prints of the active window (when I press F9) and pastes it in a word document.
But whenever I do copy some text or any other image and when I press F9 to take the screen print of the active window. I get the text pasted into the word, this is because the clipboard content has text first and then the screen print of the active window.
Instead When I press F9, I wanted the below to happen
1. Content from the Clipboard should be cleared
2. Take the screen print
3. Paste it in the word document.
Note: My tool/code already does 2 and 3. Looking for 1 alone, ,
Application Onkey: Prevent Users From Using The Print Screen Or The Alt Print Screen Buttons On The Keyboard
Dec 29, 2009I'm just looking to prevent users from using the print screen or the alt print screen buttons on the keyboard. I have this script that works if I use "39" (Right Arrow)but wont work if I use "42" (Print Screen Button).
View 5 Replies View RelatedRandom UserForm When Opening Excel
Apr 24, 2009I have 2 UserForms at the moment. They only serve as a sort of welcome screen when you open the xls file. I have this code to open the Userform.
View 14 Replies View RelatedExcel 2010 :: Random Numbers In One Function
Jul 22, 2012I'm currently working on my masters dissertation and am using excel 2010.
Basically, I'm trying to generate a list of say, 1000 numbers within a range. I can already do this using the rand() function. However, I need excel to take each random number, apply it into a formula, and then list the answers in a seperate location. This would be easy to do if there was one simple function (which i could just insert into any adjacent cell). The problem is that each random number value is input into a table. The table, which has about 10 columns and 200+ rows, gives one final answer.
I'm sure there has to be a faster way than creating 1000 tables for each random number generated.
Let's say I have a list of 1000 random numbers in sheet 1. the function table is in sheet 2 and produces the answer in the same sheet, in a single cell. I'd like excel to use each random number generated, input it into the function table, attain the answer from the table, and list it in the cell next to the random number.
Get Random Prize Draw Working With In Excel?
Apr 17, 2014I'm trying to get a random prize draw working with in excel. My worksheet structure as follows.
A1 person's name
B2 points obtain by the person.
A1 B2
John 10 points
Ken 20 points
Amy 30 points
1st draw. If random number result between 1 and 10 display John wins then delete John's entries.
2nd draw etc... and delete anyone that has already won a prize.
With the following code I found on this forum it partly works. It only randomly select a cell but missing displaying the winner and removing it afterwards.
[Code]......
Excel 2010 :: Random Numbers In One Function?
Jul 22, 2012I'm currently working on my masters dissertation and am using excel 2010.
Basically, I'm trying to generate a list of say, 1000 numbers within a range. I can already do this using the rand() function. However, I need excel to take each random number, apply it into a formula, and then list the answers in a seperate location. This would be easy to do if there was one simple function (which i could just insert into any adjacent cell). The problem is that each random number value is input into a table. The table, which has about 10 columns and 200+ rows, gives one final answer.
I'm sure there has to be a faster way than creating 1000 tables for each random number generated.
Let's say I have a list of 1000 random numbers in sheet 1. the function table is in sheet 2 and produces the answer in the same sheet, in a single cell. I'd like excel to use each random number generated, input it into the function table, attain the answer from the table, and list it in the cell next to the random number.
Excel 2010 :: Creating Random Trending Data
Aug 11, 2014Im looking to create random data for an athlete over about 4 months with daily tests, however when im using the =randbetween(*,*) function the data is too 'Random'. so im looking to create a trend in the data, like real athletes will have. is there a function in Excel 2010 that can do this?
The boundaries of the data are -336,416 (i know its quite a big range)
Generate Random Times In Excel Between Upper And Lower Limits?
Aug 23, 2013I want to generate random times in excel between upper and lower limits , which i can do , but i also want dates in same cells with out randomization , means dates should act independently and time should randomize
it should be something like that
8/1/2013 05:55 AM
8/2/2013 07:55 AM
8/3/2013 04:44 AM
Generate Random Numbers In Random Cells
Sep 18, 2009I am working on a Random Cycle Count Generator that provides random SKU#s based on 3 separate columns of SKU listings. The user clicks a button to generate the SKU#s to cycle count for that day. What I would like to see is a date stamp in the columns next(B,D,F) to the referenced SKU listing(A,C,E) based on which SKU#s are generated. This will let me see the last date that the SKU was generated. I would also like it to automatically save after generating.
View 2 Replies View RelatedExcel 2010 :: Generate 6 Digit Unique Random Number For ID Column A
Jul 18, 2012How do I create a 6 digit unique random number for use as an ID in column A. Once created the rows with preexisting 6 digit unique random ID numbers must not change every time new rows are added.
View 9 Replies View RelatedExcel 2010 :: Creating Multiple / Repeatable Lists Of Random Numbers
May 19, 2014I am trying to create challenge/response cards. Each card will have a 5-digit number in the upper-left and lower-right corner along with a series of rows containing a line number and 3 pairs of challenge/response words.
Rather than have have copies of these cards, I want the central office to have a macro-enabled workbook wherein they can enter the two numbers from the card and have the challenge/response matrix regenerate on a worksheet.
So, essentially, I want the challenges random number generator seeded from one of the 5-digit numbers and the responses random number generator seeded from the other 5-digit number.
I am trying to use
Code:
Randomize(Seed)
where Seed is one of the 5-digit numbers.
The problem appears to be that, no matter what I use for Seed, the RND(-1) function is not resulting in different numbers.
I am using Excel 2007 and Excel 2010.
Excel 2007 :: Insert Random Number Preceded By X If Adjacent Cell Has Data
Nov 24, 2011i have a problem in that i need to generate a random 6 digit number preceeded by an X if the data in column B is either blank or 0. This needs to be filled in if the adjacent cell in column C has data in. i am a moderate macro writer and am finding this part quite challenging.
i am ussing excel 2007.
Excel 2003 :: Daily Stock Chart AND Random Scatter Chart Data
Jan 14, 2014I need to plot various data on top of stock charts.
This data could be irregular in date: it could be weekly, or simply random.
To plot this data by itself requires a Scatter Chart.
From what I know so far, you CANNOT DO THIS.
However, I suspect this could be done if I build a Stock Chart from scratch using a Scatter Chart.
Error bars can be used to make the tails, however, I don't know how they built the body bar which has the characteristics of a bar (border, and interior.)
But since I don't really need those two characteristics, I just need a wider error bar line that is provided in the chart edit window. I'm guess through a macro, there are wider line widths assignable.
2003 Is Too Far Up On The Screen
Sep 27, 2009I did the restart our company required and when Excel reopened it was on my laptop rather than the big screen. I run 2 screens. Excel 2003 is now so far up on the laptop screen, I cannot move it. I can barely see File, Edit, View, etc. How can I drag Excel down so I can resize it?
View 4 Replies View RelatedScreen Size
Dec 7, 2009what size monitor do you use?
I'm thinking about upgrading my 17" to a 23" monitor so I can see more cells without zooming
Anyone currently use a 23" for Excel?
Screen Position
Aug 18, 2009I would like to end a macro with a specific cell (e.g. E50) in the first cell in the upper left hand corner of the screen. How might I accomplish this?
View 3 Replies View Related