557 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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.
Open the Choc Shop.xlsx file and create a new script. The aim of the exercise is to use an array to check that a range of cells contains only negative numbers.
Each cost should be entered as a negative number.
Create an array which reads the values of cells F6:Q8 on the Inputs sheet using the getValues method.
Loop through the array to check if any value is a positive number. If so, highlight the corresponding cell in the worksheet in a different colour.
You can use the getCell method to refer to cells within a range by row and column numbers. For instance, getRange("F6:Q8").getCell(0, 1) will refer to cell G6.
Run the script to highlight the positive values.
It should be easier to spot the positive numbers after you run the script.
Add code to change any positive number to its equivalent negative value and overwrite the value in the relevant cell.
If you'd like to revert the formatting of the cells back to their original colour you can apply the Input number style to the range using the setPredefinedStyle method.
Each cell should now contain a negative number.
Save and close the script and workbook.
25 Aytoun Street