INT012 Create Excel Document with Template and Formatting

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 these objectives you will complete the following:

• Step 1. Create RDMLX function iiiFN14

• Step 2. Complete Function iiiFN14

• Step 3. Create Function iiiFN15 and test

• Step 4. Add DEFINE 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.