This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	OfficeScripts (21 exercises)
Topic ==>	Functions (2 exercises)
Level ==>	Average difficulty
Subject ==>	Office Scripts training

Create functions in Office Scripts to validate user inputs.

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

Open the WODA Application.xlsx file and WODA Functions script.

Feel free to replace the sample details with your own.

The aim of the exercise is to create functions to validate the user input on the Apply worksheet.

We'll start with a function which checks if the provided cell is empty.

Create a function called cellIsEmpty which accepts an ExcelScript.Range object as an argument and returns a boolean value.

Add code to the function to check if the cell passed to it is empty. If so, change the cell's fill colour to red and return the value true, otherwise clear the cell's fill colour and return the value false.

Run the script and test that it works.

Use the same function to check if the cell containing the user's height has been filled in.

Add a second call to the function at this point.

Add a new function to test if a cell contains a positive number. The function should accept an ExcelScript.Range object as an argument and return a boolean value.

Add code to the function so that it returns true if the value of the cell is a positive number, otherwise it should change the cell's colour and return false.

Call the new function to check that the cell containing the user's height has a valid number. If the function returns false you should exit from the main function.

Add a new function to test if a cell contains a valid date. If not, the function should format the cell passed to it and return an appropriate value.

You can use the Date.parse method to check if a string represents a valid date. If the method does not return a number, the string does not represent a date.

Call the function at the point shown below and exit from the main function if the date cell doesn't contain a date.