This page has 0 threads | Add post

Exercises

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

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

Use if statements to validate a set of user inputs and verify the existence of objects in a workbook.

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 add a new script. The aim of this exercise is to validate the user inputs before adding them to the list of applications.

Some validation code is needed here.

Create if statements to check that the Apply and List worksheets exist. If not, use the console.log statement to print a warning message and then exit from the script.

The code should stop if either of these worksheets is not in the workbook.

Add an if statement to check that the user has entered a name. If the cell is empty, show a message in the cell next to it and exit from the script. Include an else clause to clear the message when a name has been entered.

Your error message could look like this.

Add if statements to check that the height has been entered as a number and that the number is not less than 0. Display an appropriate error message and exit the script if the value entered doesn't conform to your rules.

Make sure the error message is cleared when a valid number is entered.

Add another if statement to check that a valid date has been entered into cell C6. Display an error message and exit from the script if not.

You can check if the Date.parse method returns a number to check if the value is a date. You may find it useful to change to number format of the cell before you do this.

Once all the validation has been passed, add code to copy the details to the end of the list on the List sheet.

Save and close the script and the workbook.

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.

You can find other training resources for the subject of this exercise here:

This page has 0 threads

Add a new post