You should start drawing the grid of the crossword puzzle and select the required quantity of cells. With the same principle, draw the complete crossword puzzle. You have to make up questions for the crossword puzzle. The first thing is to draft your crossword puzzle with the help of pencil and paper. Determine the grid size where you think the clues will be placed. And how they will be placed across the grid. You can make a new crossword clue as per your choice. The next step is to open a new blank document of Microsoft Excel.
Then you have to select the total number of rows which is of the vertical size of your planned grid. For example, if you need a grid 20 spaces high, you have to select 21 rows. Next is to click in cell A1. Select a number of columns equal to one more than the horizontal size of your planned grid for example, if you need a grid 20 spaces wide, select 21 rows.
You have to start with the cell B2 and then select the grid area. The key in the answers as the letter in every cell. Make sure that all the answers are correctly spelled and words cross at the appropriate letter. You then have to choose the empty cells by holding down the control key and then clicking the empty cells.
In the front box on the Home ribbon and then click on the Fill Color button. Start with the row first followed by a column. Select your crossword grid and delete all the answers. All you have to do is to type your numbered clues. That too one clue per cell in separate cells to the right of the crossword grid. A detailed description and crossword generator with pictures:.
In the introduction column, the answers entered in the crossword by a user will be displayed. The cell displays the number of correct answers. Next glue the individual letters in the puzzle by using concatenation function. The formula is being used in the column cells. The total number questions is 5 in cell Sheet1! Hence, the formula will be as follows in cell N11 on Sheet To check the functionality of the formulas, enter all the answers into the grid of the crossword.
Hide the correct answers from a user. Remove them from the crossword grid on the second worksheet. Select the rows of the auxiliary table. Use «Group» tool. In «Changes» group, find «Protect Sheet» button.
Assign a password in the opened window. If a user tries to open the answers, the program will show the following warning: "You cannot use this command on a protected sheet The basic work on creating the crossword puzzle is over. Do the same for the rest of the word and you should have something similar to the picture I have. Now we will check if the answer given is correct.
The first word is IF , with this command, we will see if both the cells are the same. After that, I have entered a 0 to say if the condition is not true then print 0 in the cell. Select all the values under Status. Under Formulas click on the auto sum button, and you will get all the values added up! Now go to Sheet1 over there pick a cell where you can tell the user how many words he has left to find you can do that by putting in this formula. D9 is the cell for this, you should select the cell where all the values are added up.
Hit enter and see the value appear. Merge a couple of cells near that and type in this formula:. Here we are basically saying if the number of words left is equal to 0 then say "You are done" else say "left". We are almost done! Just go to the sheet where you have all the answers typed in and select the whole table, under data select group and press ok. Now you should see a - sign, if you click on it the whole table will get minimized.
Now under review click on the Lock sheet button while the table is minimized and enter in a password. That's it your sheet is locked now nobody can cheat by looking at the answer sheets. Just a few finishing touches now. That's it!
0コメント