Spreadsheet2(notes)

Spreadsheet2(notes) - Jim 85 B Credit Andrew 74 C Pass Bill...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
(Your name)'s Flower Shop Sales's Tax Rate 0.09 (Insert formula for today's date) Flower Number in Bouquet Price per bouquet Bouquets in stock Need to Reorder (<20)? Bouquets Sold Gross Income Sales Tax Net Income Roses 24 29.99 7 yes 95 2849.05 -2848.96 5698.01 Roses 12 18.95 28 no 23 435.85 -435.76 871.61 Roses 6 12.99 36 no 32 415.68 -415.59 831.27 Lillies 24 19.99 5 yes 128 2558.72 -2558.63 5117.35 Tulips 24 29.99 31 no 63 1889.37 -1889.28 3778.65 Narcissus 6 34.99 28 no 57 1994.43 -1994.34 3988.77 Carnations 24 22.95 15 yes 45 1032.75 -1032.66 2065.41 Carnations 12 17.49 21 no 58 1014.42 -1014.33 2028.75 Carnations 6 11.99 44 no 14 167.86 -167.77 335.63 Orchids 6 39.99 9 yes 76 3039.24 -3039.15 6078.39 Column Totals (use sum) 144 239.32 224 4 Number of items with values (text and numbers) 11 11 11 Number of items with numbers only 10 10 10 Number of items with text only 0 0 0 Median N/A Maximum N/A Minimum N/A
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Name Points Grade Comment Bob 90 A Distinction Loucas 80 B Credit Maria 95 A Distinction George 71 C Pass Joe 93 A Distinction
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Jim 85 B Credit Andrew 74 C Pass Bill 54 D Fail Peter 76 C Pass Karen 96 A Distinction Ananth 34 F Fail a lot Average 77.09090909 Median 80 Highest 96 Lowest 34 Number Passing (grade > 60) 9 Number Failing (grade < 60 2 Number of A's (countif) 4 Number of B's (countif) 2 Number of C's (countif) 3 Number of D's (countif) 1 Lookup Table for Letter Grade Points Grade 0 F 50 D 65 C 80 B 90 A Lookup Table for Grade Comment Grade Comment A Distinction B Credit C Pass D Fail F Fail a lot Notes: Use "Merge Cells" to merge the notes above, and apply word wrap to this cell 1. A Vlookup table must contain the values to look up in ascending order when used to look up a range of values 2. A Vlookup table must contain distinct values to look up, e.g. one A, one B, etc....
View Full Document

This note was uploaded on 12/28/2011 for the course 198 170 taught by Professor Kristianstout during the Spring '10 term at Rutgers.

Page1 / 3

Spreadsheet2(notes) - Jim 85 B Credit Andrew 74 C Pass Bill...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online