DEVELOP AND USE COMPLEX SPREADSHEETS 2016

1.Using manuals, user documentation, what the following topics and provide a short explanation of the features.

a.Explain what the PMT function is and when 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 what a macro is and give 3 examples of the sort of repetitive tasks you would record in a macro.

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

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

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