Yes, Hondas are great cars.
'4 cylinders' means that four pistons turn the drive axle. It's really not important to know exactly what it does, just that with 4 cyliders you will get better gas mileage, but the car will not be as fast as one with 6 or 8 cylinders.
One thing I would check (having...