SWITCH Function - Free Excel Practice Online

This free, interactive exercise teaches you SWITCH Function in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Logical Functions track and works right in your browser - no Excel install, no download, and no signup.

Practising SWITCH Function this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this SWITCH Function lesson

1. The SWITCH function in Excel compares a value to a list of possible match/result pairs and returns the result of the appropriate match. Say you wanted each number spelled out rather than in numerical form. Type in this formula to reference the value in cell A1, and return the matching result of "One." =SWITCH(A1, 1, "One")
2. Now let's add another match/result pair so our formula can handle more numbers. Type in the following formula - it will return "One" if the value is 1, and "Two" if the value is 2. =SWITCH(A1, 1, "One", 2, "Two")
3. What would the result of the following formula be? =SWITCH(A1, 1, "One", 2, "Two", 3, "Three")
4. What would the result of the following formula be? =SWITCH(A3, 1, "One", 2, "Two", 3, "Three")
5. The SWITCH function also allows an optional default value at the end. The function will return the default value if none of our values match the value in the cell we're referencing. Try typing the following formula, which returns "Unknown" if the value doesn't match any of our conditions: =SWITCH(A1, 1, "One", 2, "Two", 3, "Three", "Unknown")
6. What would this formula return? =SWITCH(A5, 1, "One", 2, "Two", 3, "Three", "Unknown")
7. What would this formula return? =SWITCH(A6, 1, "One", 2, "Two", 3, "Three", "Unknown")
8. What would this formula return? =SWITCH(A2, 1, "One", 2, "Two", 3, "Three", "Unknown")
9. What would this formula return? =SWITCH(B2, "A", "Great", "B", "Okay", "Bad")
10. What would this formula return? =SWITCH(B5, "A", "Great", "B", "Okay", "Bad")

SWITCH Function practice - FAQ