NOTE: You will be asked to turn on TURBO MODE Full screen is recommended, but not necessary. The main sheet works like in excel: Click on a square to activate it and type to enter numbers. For other typing options use the -, . and backspace buttons next to the typing field. You can also copy and paste! Entering functions is a bit more complicated. Click ‘Edit function’ to see the functions menu, which has another grid in it. The last square has a yellow-coloured = sign in it, the answer to whatever you put in that square is what will be shown on the main grid. Ignore the other squares for now. Choose a function from the sidebar to put in the field (what the functions mean and do is explained in the ‘credits’ section). Functions like SUM refer to other squares on the main grid through coordinates (e.g. A01). Click a coordinate to change it. With VAL, you can give a square inside the functions menu a certain value. If you want to use just one of the functions for the square on the main grid you have selected, put this function in the square with the yellow = sign and ignore the squares. The other 15 squares in the functions menu are used when you use *, +, - or / to link different functions together. If you use one of these, the appropriate symbol and two red letters (e.g. a and b). These letters refer to other squares in the functions menu. Click a letter to change it, like with coordinates. Then simply enter into the relevant boxes in the functions menu with those letters next to them the two values that you want to multiply, add, etc.. For example, if you wanted to add together squares A01 and A02 on the main grid, you could put the function ‘Coordinate A01’ in square ‘a’ of the functions menu, ‘Coordinate A02’ in square ‘b’ and ‘a + b’ in the square with the yellow =, because this is your final answer. Think of it like operator scratch blocks: the addition block would be around the two things that you are adding and is your final answer.
scratch has set up excel for you.
