Everyone likes to solve crosswords. This is an extremely useful point that will certainly come in handy in different areas of activity: to lure users to the resource, come check and also consolidate knowledge during teaching, etc.
You are watching: Cell assignment crossword
Excel spreadsheets permit users come “automatize” fixing crossword puzzles: castle can instantly see the outcomes of the solution. Let’s develop them using typical functions.
How to make an interaction crossword in Excel
The conventional Excel sheet is a collection of rectangle-shaped cells that are not quite an ideal for drawing crossword puzzles. So first you must make them square.
Select every the cells by pressing Ctrl + A. Right-click anywhere and select «Row Height». Set the worth to 18.
Change the broad of the pillar by another way: take the right edge of any cell and move it to the left side, setting the value to 3.
At the exact same time, the broad of all columns of the worksheet is changed.
Begin illustration the grid of the crossword puzzle. Choose the required quantity that cells. Set all the limits in «Font» group.
By the same principle, draw the whole crossword. Nothing forget to placed numbers of concerns / answers.
Make up questions for the crossword puzzle. Create them to the appropriate of the grid.
How to do a crossword with checking in Excel
Create an assistant table v answers on a brand-new worksheet:
In «Introduced:» column, the answers gotten in in the crossword by a user will certainly be displayed. Pillar "?" represents matches. Cabinet V8 display screens the variety of correct answers.
Now adhesive the individual letters in the crossword into totality words by using «CONCATENATE» function. Go into formulas in «Introduced:» column’s cells:
A user can enter both lowercase and uppercase letters. As a result, some problems arise. To avoid them, use «LOWER» function. Place it in all cells before «CONCATENATE» function.
For questions:In cabinet C2:In C3:In C4:In C5:In C6:
The duty converts uppercase letters to small letter ones.
If a user start a correct answer, figure 1 will show up in column variety D2:D6. In situation of an not correct answer, 0 will appear. In cell D2 perform it by utilizing «=IF()» function: =IF(B2=C2,1,0). For calculating the number of correct answers, =SUM(D2:D6) duty is supplied in cell D7.
The number of all correct answers is 5 in cabinet Sheet1!N7. If "5" shows up in «Total» cabinet Sheet2!D7, it way that a user coped with solving the crossword. The article “DONE!!!” (for example) is presented on the screen.
If over there is an additional number in «Total» cell, “Still think …” is displayed.
Implement the task using «IF» role in cabinet O10 ~ above Sheet1:
Let’s show a user how plenty of answers room left come guess. The full number concerns is 5 (in cabinet Sheet1!N7) . Hence, the formula will certainly be as adheres to in cabinet N11 ~ above Sheet1:
Where Sheet2!D7 – is the variety of correct answers indigenous the auxiliary table.
To check the functionality of the formulas, enter all the answers right into the grid of the crossword. You’ll get the complying with result:
Hide the exactly answers indigenous a user. Remove them native the crossword net on the second worksheet. Select the rows that the auxiliary table. Walk to «DATA» tab - «Outline» group. Usage «Group» tool.
In the opened up window, pick the examine box in former of «Rows» entry.
The framework icons and also the minus prize will appear in the left ar of the worksheet.
Click top top "-" icon. The auxiliary table data will come to be invisible.
Next, go to «REVIEW» tab. In «Changes» group, uncover «Protect Sheet» button. Assign a password in the opened window. Currently an unauthorized human (who doesn’t know the password) will not have the ability to open the assistant table and see the answers.
If a user do the efforts to open the answers, the program will show the following warning: "You cannot usage this command top top a protected sheet...".
See more: Increasing The Mass Attached To A Spring Will Increase The Period Of Its Vibrations.
The basic work on producing the crossword puzzle is over. You have the right to beautifully finalize the worksheet, include a name, adjust the fill color of the grid, brighten the borders of cells, etc.