WordPress hosting doesn't really need to be managed. Just that you have to choose a provider that offers the service.
Definitely if you are new to WordPress you can ask the hosting company if they offer as not all hosting companies do.
Managed WordPress hosting is for those who are not that familiar with WordPress and managing it. Managed WordPress hosting is normally offered at a premium price as the hosting provider will not only keep your WordPress updated or help you out with issues related to plugins and themes but also monitor your website 24/7 for any downtime and take necessary steps if required. You can find managed WordPress hosting provider from here.
You should select a Hosting Assured Company by TheWebHostingDIR as they have verified the hosting provider service.
If you are not tech-savvy and often need support to manage the things, you should go with managed service. Most of the hosting providers offer managed service to their clients and manage their clients' account/server. Some providers offer monitoring service with their managed support.