INT012 - Create Excel Document with Template and Formatting

Objectives

• To extend the function written in exercise INT011

• To write an Excel document based on a template

• To format the output written to the Excel document

To achieve the objective you will complete the following:

Step 1. Create RDMLX function iiiFN133

Step 2. Complete Function iiiFN13

Step 3. Create Form iiiFRM07 and test

Step 4. Add ADD Command to Format Output

Step 6. Insert a Total Salary Formula

Step 7. Password Protect the Document

Summary

Before You Begin

You must have Microsoft Excel or the Excel Viewer installed to complete this exercise.