Logical Functionslesson 12 of 95
IF, VLOOKUP and Data Shortcuts Practice
Loading the data...
IF, VLOOKUP and Data Shortcuts - Excel Practice Online
This interactive exercise teaches you IF, VLOOKUP and Data Shortcuts 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 and no download. Start free.
Practising IF, VLOOKUP and Data Shortcuts 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 Excel practice course.
What you'll practice in this IF, VLOOKUP and Data Shortcuts lesson
- Write an IF statement that returns 0 if A1 is less than 1, and returns 1 otherwise
- Use the shortcut to remove duplicates from the list
- Use VLOOKUP to get the name of employee ID # 4355
- Use a combination of IF and VLOOKUP. If employee #4355 is Jake, return 1. Otherwise, return 0.
- Use the shortcut to filter the lists
- Use a combination of IF and VLOOKUP. If the hurricane that happened in 1991 was greater than category 1, return "strong". Otherwise, return "weak".
- Sort the list in ascending order
- Use VLOOKUP to return the birth date of employee # 9094
- Sort the list in descending order
- Use VLOOKUP to get the population of Maine
IF, VLOOKUP and Data Shortcuts practice - FAQ
How do I practice IF, VLOOKUP and Data Shortcuts in Excel?
Open this LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation. You need no Excel install.
Is the IF, VLOOKUP and Data Shortcuts exercise free?
Your first two lessons are free with a free account. After that the pass opens all 95 lessons, the Academy and the accounting course. Lessons you finish stay open.
What will I learn in this IF, VLOOKUP and Data Shortcuts lesson?
This lesson covers IF, VLOOKUP and Data Shortcuts as part of the Logical Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.