What type of microsoft office is used in making payroll?

In office excell can do it easily.

Mostly Microsoft Excel and Microsoft Access.

Microsoft Excel is most commonly used. However, Microsoft Access or Accounting are also made for such jobs.

As a primary tool we can use Microsoft Excel as payroll system. Advanced users can use Microsoft Access.

Microsoft Office Accounting, Microsoft  Access and Microsoft Excel

You need to purchase a payroll software for a payroll system

You can use any type (version) MS Access and Excel are most appropriate applications.