Cartela de bingo excel: como criar e imprimir cartelas sem repetição
How to Download and Play Bingo Cards in Excel
Bingo is a popular game of chance that can be enjoyed by people of all ages and backgrounds. It is a simple and exciting game that involves marking off numbers on a card as they are called out by a caller. The first player to mark off a row, column, diagonal, or pattern of numbers wins the game.
But did you know that you can also create your own bingo cards in Excel and play them online with your friends or family? In this article, we will show you how to download and play bingo cards in Excel, as well as the benefits of playing bingo for your health and well-being.
cartela de bingo excel download
What is Bingo and Why Play It?
The rules and variations of bingo
Bingo is a game that originated in Italy in the 16th century and spread to other countries over time. The basic rules of bingo are as follows:
Each player gets a card with 25 squares, each containing a number from 1 to 75. The card has five columns labeled B, I, N, G, and O, and each column has a range of numbers assigned to it.
A caller randomly draws and announces numbers from 1 to 75, usually using a machine or a software that generates random numbers.
Players mark off the numbers on their cards as they hear them. They can use chips, coins, pens, or any other small objects to cover the squares.
The first player to mark off five squares in a row, column, diagonal, or any other pattern specified by the caller wins the game and shouts "Bingo!"
There are many variations of bingo that have different rules, patterns, and prizes. For example, some games may have more than one winner per round, some may have bonus squares or free spaces, some may have different card sizes or number ranges, and some may have themes or special words instead of numbers.
The benefits of playing bingo for your health and well-being
Bingo is not only a fun and entertaining game, but also a beneficial one for your health and well-being. Here are some of the benefits of playing bingo:
Bingo can boost your mental agility, memory, alertness, and cognitive functioning. It requires you to pay attention, process information quickly, and recall numbers. It also exercises your brain cells and prevents mental decline.
Bingo can help you build social connections and reduce loneliness. It allows you to interact with other players, make new friends, share laughter, and have fun. It also fosters a sense of community and belonging.
Bingo can induce sportsmanship and positive emotions. It teaches you how to play fair, respect others, cope with losses, and celebrate wins. It also releases endorphins, which can relieve stress, pain, and anxiety.
Bingo can improve your hand-eye coordination and physical health. It involves using your hands, eyes, ears, and mouth to mark off numbers, listen to the caller, and shout "Bingo!" It also encourages you to move around, exercise, and stay active.
How to Create Your Own Bingo Cards in Excel
The steps to make a bingo card generator in Excel
If you want to create your own bingo cards in Excel, you can follow these steps:
Open a new workbook in Excel and name it "Bingo Card Generator".
In the first worksheet, enter the numbers from 1 to 75 in cells A1 to A75. These are the possible numbers that can appear on your bingo cards.
In the second worksheet, enter the following formula in cell A1: =RANDBETWEEN(1,75). This will generate a random number from 1 to 75. Copy and paste this formula in cells A2 to A25. These are the numbers that will appear on your first bingo card.
In the third worksheet, enter the following formula in cell A1: =IF(COUNTIF(Sheet2!$A$1:$A$25,Sheet1!A1)>0,Sheet1!A1,""). This will check if the number in cell A1 of Sheet1 is present in Sheet2. If yes, it will display the number. If no, it will display a blank space. Copy and paste this formula in cells A2 to A75. These are the numbers that will be used to create your first bingo card.
Select cells A1 to E5 in Sheet3 and click on Insert > Table. This will create a table with five columns and five rows. Name the table "Bingo Card 1".
Select cells B1 to E1 and type "B", "I", "N", "G", and "O" respectively. These are the column headers of your bingo card.
Select cell C3 and type "FREE". This is the free space of your bingo card.
Select cells B2 to B6 and type the following formula in cell B2: =INDEX(Sheet3!$A$1:$A$15,RANDBETWEEN(1,15)). This will randomly select a number from 1 to 15 from Sheet3 and display it in cell B2. Copy and paste this formula in cells B3 to B6. These are the numbers that will appear under column B of your bingo card.
Select cells C2 to C6 and type the following formula in cell C2: =INDEX(Sheet3!$A$16:$A$30,RANDBETWEEN(1,15)). This will randomly select a number from 16 to 30 from Sheet3 and display it in cell C2. Copy and paste this formula in cells C4 to C6. These are the numbers that will appear under column I of your bingo card.
Select cells D2 to D6 and type the following formula in cell D2: =INDEX(Sheet3!$A$31:$A$45,RANDBETWEEN(1,15)). This will randomly select a number from 31 to 45 from Sheet3 and display it in cell D2. Copy and paste this formula in cells D3 to D6. These are the numbers that will appear under column N of your bingo card.
Select cells E2 to E6 and type the following formula in cell E2: =INDEX(Sheet3!$A$46:$A$60,RANDBETWEEN(1,15)). This will randomly select a number from 46 to 60 from Sheet3 and display it in cell E2. Copy and paste this formula in cells E3 to E6. These are the numbers that will appear under column G of your bingo card.
Select cells F2 to F6 and type the following formula in cell F2: =INDEX(Sheet3!$A$61:$A$75,RANDBETWEEN(1,15)). This will randomly select a number from 61 to 75 from Sheet3 and display it in cell F2. Copy and paste this formula in cells F3 to F6. These are the numbers that will appear under column O of your bingo card.
Format your table as you like. You can change the font size, color, alignment, border, etc. You can also add some images or logos to make it more attractive.
To create more bingo cards, you can copy and paste the table in Sheet3 to other worksheets and rename them accordingly. You can also refresh the formulas by pressing F9 or clicking on Data > Calculate Now. This will generate new random numbers for each bingo card.
The tips and tricks to customize your bingo cards
Here are some tips and tricks to customize your bingo cards:
You can change the number range or theme of your bingo cards by modifying the values in Sheet1. For example, you can use letters, words, phrases, symbols, or pictures instead of numbers. You can also use different languages, categories, topics, or genres to suit your preferences or purposes.
You can adjust the size or shape of your bingo cards by changing the number of rows and columns in your table. For example, you can make a 3x3, 4x4, or 6x6 bingo card instead of a 5x5 one. You can also merge or split cells to create different patterns or designs.
You can add some variations or challenges to your bingo game by changing the winning conditions or rules. For example, you can require the players to mark off more than one line or pattern, or to mark off the numbers in a specific order or direction. You can also add some penalties or rewards for certain numbers or squares.
How to Play Bingo Online with Your Friends or Family
The best websites and apps to play bingo online
If you want to play bingo online with your friends or family, you can use some of the following websites and apps:
A website that allows you to create and play custom bingo cards online.
- You can choose from various templates or upload your own images.- You can share your bingo cards with others via email, social media, or QR code.- You can play bingo online with up to 30 players in real time.- You can use a virtual caller or a voice synthesizer to announce the numbers.- You can track the progress and winners of your bingo game.
An app that lets you play bingo games with millions of players around the world.
- You can join different bingo rooms with different themes and prizes.- You can collect various items and power-ups to boost your chances of winning.- You can chat with other players and make new friends.- You can earn coins, gems, tickets, and rewards by playing daily missions and events.- You can sync your game across different devices.
An app that offers you a fun and immersive bingo experience with unique twists.
- You can play over 30 bingo rooms with original themes and graphics.- You can unlock exclusive bingo games and mini-games as you progress.- You can collect special bingo balls and chips to activate amazing effects.- You can join tournaments and competitions with other players and win big prizes.- You can connect your game with Facebook and invite your friends to play together.
The advantages and disadvantages of playing bingo online
Playing bingo online has its advantages and disadvantages. Here are some of them:
Playing bingo online is convenient and accessible. You can play anytime and anywhere, as long as you have an internet connection and a device. You don't have to travel to a bingo hall or buy physical cards.
Playing bingo online is diverse and exciting. You can choose from a wide range of bingo games and variations, with different themes, graphi