In-Class 7 (Progress)

In-Class 7 (Progress) - // Spreadsheets I n-Class 7 Fall...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: // Spreadsheets I n-Class 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

Page1 / 2

In-Class 7 (Progress) - // Spreadsheets I n-Class 7 Fall...

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

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