This page has 0 threads | Add post

Exercises

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

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

Use nested for loops in Office Scripts to check a range of cells contains only negative numbers.

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 Choc Shop.xlsx file and create a new script. The aim of the exercise is to check that each cell containing a cost value on the Inputs worksheet contains a negative number.

A range of cells with positive and negative numbers.

Each cost should be a negative number, formatted with round brackets.

To loop through the range of cells containing costs you could:

Create variables to hold the row and column numbers of the first and last cells in range F6:Q8.
Create a for loop to count from the first to last row numbers.
Nest another for loop within the first to count from the first to last column numbers.
Use the counter variables to reference each cell in the range.
Change the colour of a cell if its value is greater than 0.

Run the script to highlight the positive numbers.