1.Using manuals, user documentation, online help and the internet, research the following topics and provide a short explanation of the features.

a.Explain the PMT function is andthe time you would use it?

b.How would you split the screen so you could view the top and lower part of a worksheet?

c.Explain a macro is and give three examples of the sort of repetitive tasks you would record in a macro.

d.Explain you would develop a template and what aspects of a workbook or sheet it would contain.

2.A.the recommended ergonomic, work breaks for an employee whose job is data entry. Summarise the information into two paragraphs or dot

points.

B.What ways in which paper can be conserved in a workplace. Summarise the information into two paragraphs or dot points.