This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: // Spreadsheets I nClass 7 Fall 2009 Let us continue the discussion of last week. This week will introduce conditional logic and some advanced concepts of spreadsheet mechanics. 1. Give names to the values in cells C1 – C7. 2. Give an example of a condition (not an equation) that would check to see if E10 is greater than or equal to ten. __________________________ 3. For column F, you want to write a formula to turn text like “breakfast” or “buffet” (in column E) into prices we can work with. Write the nested IF f rom F10 below. _____________________________________________________________________________ _ _____________________________________________________________________________ _ 4. Use a single IF statement to give a 25% discount if a party buys breakfast on Monday morning, and put the subtotal after the discount in H10. _____________________________________________________________________________ _ 5. Write the formula you’d use to determine the gratuity for row 10 _____________________________________________________________________________ _ 6. Write the formula you’d use to determine the total bill for row 10. _____________________________________________________________________________ _ 7. Write the function you’d use to find the total revenue by meal for dinner (C49). _____________________________________________________________________________ _ 8. Write the function you’d use to find the total number of parties of 10 or more (C51). // _____________________________________________________________________________ _ 9. Write the function you’d use to find the total revenue for Wednesday (C56). _____________________________________________________________________________ _ 10. Generate a bar graph based off of the “Total # Served (by meal)” data. Don’t forget to submit the f inished spreadsheet before you leave class! 11. ...
View
Full
Document
This note was uploaded on 11/02/2009 for the course E E115 taught by Professor Burgett during the Spring '09 term at N.C. State.
 Spring '09
 BURGETT

Click to edit the document details