OBJECTIVE OF THE CLASS
Reaffirm the necessary components for managing the =IF function, combining previous knowledge in the management of formulas and functions as well as conditional formatting and data validation.
REMEMBERING THE SYNTAX
The IF function in Google Sheets is a conditional function that allows you to evaluate a condition and return one result if that condition is true and another result if it is false. The basic syntax of the IF() function is as follows:
=IF(condition,result_if_true,result_if_false)
EXAMPLE (PREPARATION FOR THE ACTIVITY "MUSICAL DEL IdeC 2025")
Today we will go directly to preparing the test in a spreadsheet. For this activity you will have to create a completely new file.
Before starting in Google Sheets, you will have to get 10 images of some famous people, for example, athletes, actors or actresses, singers, fictional characters, characters from a trilogy of movies or series (remember that it cannot be a drug apology, crimes, drug trafficking, etc.).
To do this you will use the Google search engine, but you will use the image filter, the tools button and choose only icon type images. To download the image you will right click on it and select the "Save image as" option. This will store the images on your computer.
Now, create a new spreadsheet file in Google Sheets. To begin, you will write down the main instruction in cell B2 (Write down the correct name of each person or character)
In row 4, starting in cell B4, you will insert the images you downloaded, leaving a free column between each image. Use the Insert/Image/Image tab on the cell.
After inserting all 10 images, you will now mark a cell below each image for someone else to write down each person's name. Just change the background color of these cells to gray.
Finally, we program the evaluation of the answer noted in the previous cell with an IF() function. Look at the image.
In the example in the image the content of cell B6 is being analyzed. If the name “Michael Jordan” is written there then it will say CORRECT, if it is false then it will say BAD ANSWER. Logically you will have to repeat so that the 10 images are evaluated.
In addition to the activity with the =IF function, you will add formulas in which 2 points are awarded for each correct answer in a cell to turn it into a memory-style game.
IMPORTANT: Note that all texts within the IF() function are indicated in quotes, to prevent Google Sheets from confusing them with another function.
When finished you will have to send your file through Classroom.