This page has 0 threads | Add post

Exercises

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

Software ==>	OfficeScripts (21 exercises)
Topic ==>	Arrays (4 exercises)
Level ==>	Relatively easy
Subject ==>	Office Scripts training

Use basic array techniques in Office Scripts to work with a list of pizza toppings.

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 Pizzas.xlsx file and create a new script. The aim of the exercise is to use an array to populate a list of your favourite pizza toppings.

If you're happy with the existing list feel free to leave it as it is!

Create an array to hold your three favourite pizza toppings and store the result in a variable (if you don't like pizza, pick your favourite ice-cream flavours or equivalent substitute).

Use the sort method on the array and then write it to the Output window using the console.log method.

An array written to the Output window in Office Scripts

Office Scripts clearly has no problem with our choices so far.

Just in case you've neglected to add the best topping, write an if statement which uses the includes method to check if your array contains Pineapple. If not, use the push method to add this item to the array.

There is no need to shake the tree after doing this.

You may have accidentally infected your list of delicious food with a fungus. Use the indexOf method to return the index of Mushrooms in your array. Check if the result is greater than -1 and, if so, use the splice method to remove the offending item.

A tooltip for the splice method in Office Scripts

You could use the optional third parameter to replace Mushrooms with Pineapple...

Use the toString method to store the contents of the array in a comma-separated string and write this into cell A2 on the Pizzas worksheet. You could add code to clear the existing list of toppings first.