Spreadsheet comments I could make:

• This tells you how to change your defaults to save as office always:
  http://www.mydigitallife.info/2007/01/25/configure-change-or-set-openofficeorg-to-default-save-files-in-microsoft-office-formats/
• I just want you to have more than 1 page. You can either wrap the text or change your margin to 8.
• To test the if statement, just make the quantity 2 for a minute - see the No change to Yes. Yours wont change because it is just typed in a yes or no. To fix, look at the instructions for creating that column and set it as a formula (if quantity > 1, then "yes" otherwise "no"). After the formula is set in one cell, you can copy it down to all the other cells.
• You did more work than you needed for the % of total. Just enter the first line's formula, and then add the $ before the total row and total column and then copy that one formula down. It looks like you typed in the formula over and over. I would actually like you to redo it to see how easy it is, and how to use the $ to make a cell reference stick when you copy.
• You needed to use formulas for all the columns after the %. Please redo these with formulas.
• You need to use a formula to make the sentence, not just type it in. Please redo that one.
• You needed to use a min formula for the minimum, not just type it in.
• Instead of fitting to 1 page wide by 1 page tall, fit to 1 page wide by 99 pages tall. That way you wont squish it all onto one page, but will not run over onto two pages wide.
• To freeze the headings so they stay put when you scroll, highlight all of row 2 and hit window/ freeze pane. Then scroll forward and see the difference.
• There should be a double border above the sum. Select the sum cell. Format cell / border / pick the double line by clicking it and that is now your pen / click the none box to remove any existing border, click the top line of the box to put a double line on top.
• Please change the single border above the sum to a double border. Select the sum cell. Format cell / border / pick the double line by clicking it and that is now your pen / click the top line of the box to put a double line on top.
• You could use spaces between your words, so change "of" to " of ". Spaces inside the quotes stay.
• You selected the heading (row 1) as the print area instead of as the row to repeat. To fix, redo sheet headings and be sure to select the "rows to repeat" box instead of the "print area" box.
• You need to freeze the window pane so it stays put when you scroll. First, highlight row 2 and then: In 2007, : view / window panel / freeze pane / freeze pane. In 2003: window, freeze pane.
• The total value (column F) should be a formula, not a calculation. Type "=" and then click on the quantity and type "*" and click on the unit value and then press enter. Copy that formula down. Do this even though you may only have a quantity of 1.
• The sentence needs to be a formula, not a sentence you type. Look back at the instructions to see how to create that formula.
• The total value of all items needs to be a formula, not something you calculate. Same for average and minimum.
• I wanted you to have at least 2 pages, so make your bottom margin 7".
• Make one of your columns wider so you can see your sentence break onto another page wide. Then, go to page setup (or layout) and click fit to 1 * 99 to squish it back to 1 page wide.
• Your headings need to wrap. Make the % of total a smaller column, and then wrap it with format cells / alignment / wrap. Then, the cell will take up more room (it will be higher).
• Your headings are frozen so they stay put when you scroll, but they wont show at the top of each page. To make that happen, you need to use file / page setup (or the page layout ribbon in 2007) and choose the sheet tab and then fill in the rows to repeat. Watching the video for this may help.
• You are fitting to 1 page wide by 2 tall. That works, but if you added more items, it would squish your report to 2 pages when you don't want that. I usually just put a huge number such as 99 so that only the width is squished.
• You put too many $ in your formula. You stopped it from changing the total (F22), which you wanted. You also stopped it from moving down a line for the value for which you were finding the percentage (F2), so every line is showing the percentage that the first line is of the total. On row 2, take the $ away from F2 and recopy and see all the percentages relate to the line they are next to.
• Copy the min, avg and sum formulas below the quantity column so you have the total, min and avg quantity also.
• Your finance chart would go up instead of down if you multiplied every payment by -1. I It is okay not to do that.