Skip to content

All-Access: every lesson, no ads. $8.25€8.25US$8.25$4.08US$4.08$2.41US$2.41₹224.91MX$74.91 a month, billed yearly. Free to start. Cancel any time

See plans
All-Access, no ads: every lesson, course and template. $8.25€8.25US$8.25$4.08US$4.08$2.41US$2.41₹224.91MX$74.91 a month. + GST at checkoutSee the plans →

Logical Functionslesson 20 of 95

AND, OR, XOR, TEXTJOIN, LARGE and SMALL Practice

0daysLet's get rolling!

Loading the data...

0streak
0 XP today
All Lessons

AND, OR, XOR, TEXTJOIN, LARGE and SMALL - Excel Practice Online

This interactive exercise teaches you AND, OR, XOR, TEXTJOIN, LARGE and SMALL 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 AND, OR, XOR, TEXTJOIN, LARGE and SMALL 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 AND, OR, XOR, TEXTJOIN, LARGE and SMALL lesson

  1. Would =XOR(A1>20, A2>30) return true or false?
  2. What would =TEXTJOIN(A3, True, A1, A2, A4) return?
  3. What would =LARGE(A1:A4, 2) return?
  4. Would =AND(A1>20, A2>30) return true or false?
  5. Write a TEXTJOIN function to return "MN,WI,SD,ND,IA"
  6. Write a function to get the highest number from the list.
  7. Would =NOT(A2<20) return true or false?
  8. Write a SMALL function that would return 5.
  9. Would =XOR(1=2, 3=4) return true or false?
  10. What would =LARGE(A1:A4, 2) return?

AND, OR, XOR, TEXTJOIN, LARGE and SMALL practice - FAQ

How do I practice AND, OR, XOR, TEXTJOIN, LARGE and SMALL 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 AND, OR, XOR, TEXTJOIN, LARGE and SMALL 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 AND, OR, XOR, TEXTJOIN, LARGE and SMALL lesson?

This lesson covers AND, OR, XOR, TEXTJOIN, LARGE and SMALL as part of the Logical Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.