New Trick on Excel, March, 16/09

Today we did mental math and then Mr. Max wanted to show us a new way of solving problems on Microsoft Excel. We had a problem trying to solve how big a woman's garden could be given the size of her fence. Go to excel and type in the formula for length x width. After that put that number in another column (vertically or horazontally) and then highlight them with your mouse. There should be a black dot in the bottom right hand corner of your highlighted boxes, click and drag the length down as far as you would like, and do the same for the width. Then scroll down and find the biggest area number and that will give you the answer.

Making a colored box on Excel

Making a colored box on Excel is a way to divide sections up and give color to your work. First you click on the screen wherever you want and drag it to how big you want your box. Then go to the "fill color" button and choose which color you would like. If the color is too dark you can go to "no borders" and click on the drop down arrow and click "all borders".

How to use formulas in Excel

This is a brief example on how to use a formula in excel. The first two boxes are the page numbers and there is 6 pages to read for the pages 4 to 9. The formula is B3 which is (9) minus A3 which is (4) and plus 1 because you are counting each and every page not the inbetween pages so the software uses the formula posted and figures it out. Once you learn more about the program you can do other neat things as shown like find digits per page and the total amount of digits read.