IF & Naming Quiz

Study IF Hint page including some of the linked to sites

Create the Pancake Breakfast sheet shown below. This example has only 4 names, but the final sheet will have hundreds, and the person who hired you is not sure what will be the charge for individuals or family maximum. So your sheet MUST be flexible.

Family name goes in column A, Number of people in family goes in column B and then the charge for the family is computed in column C.

The charge is $4 per person or $15 per family. A family is a group of people who come in together and want the group rate if it is more than they would pay as individuals,

Create the sheet with 4 or more families and a Total row below.

If you put the 4 and the 15 in the formula, it will work fine, BUT it is NOT the right way to do it. See Spreadsheet hints.)
The best way to do it is to name the 2 charge values column E (using the names in column D) before creating the formula in cell C1. But, if you have already written the formula in cell C1, name the 2 values in column E, and then Apply the names to the formula cell C1 (see Naming & Absolute value hint).

Save your file.

Add Heading with a title, your name and the date and a footer with the file name.

Print the Sheet

and then switch to formula view, add Row and column headings and Gridlines and print that.

Change the rules to $7 per person with a $20 maximum per family.
This is no effort and the calculated values should change correctly if you have done your IF properly, which is to compare what the "family" would be charged if they pay as individuals compared to the per family rate.

Print your formatted values again (remember to remove gridlines and Row and Column Labels).

This could be another way the sheet is used: Change the values in cells E1 and E2 for a gala charity dinner where the per person cost would be $100 and the cost for a table, which holds 12 would be $1,000. All column C values should change once you change E1 and E2. To test your IF formula, put 12 in B1.

[ Home ] [ Up ] [ YouTube ] [ Longer Videos ] [ VLOOKUP Function Hints ] [ IF Function Hints ] [ Cell Names & Reference ] [ Pancake Bfast: IF & Naming ] [ PMT Function Hints ]
[ References ] [ In the News ] [ Learning Pyramid ] [ Photos of Students ] [ CIS100 Comp. Apps ] [ The Internet - CIS120 ] [ Web Page Development ] [ Tips and Tricks ] [ Job Search ] [ Fall '10 Schedule ] [ Tutorial Sites ] [ Hints for Printing ] [ About M.L.G. ] [ Disclaimer ]

This page was created by Professor Maureen Greenbaum and was last updated on 04/02/09 .

Page Name: IF & Naming Quiz - UCC-MLG
URL: http://faculty.ucc.edu/business-greenbaum/Quizzes/IFandNamingTest.htm

Disclaimer: Information on this site represents the thoughts and opinions expressed by the author and not that of Union County College. The author takes full responsibility for the information presented. By using the information contained herein, the user willingly assumes all risks in connection with such use. Neither the author nor Union County College shall be held liable or responsible for content, errors, and/or omissions in information herein or information contained on any Web Page to which it is linked. Furthermore, neither the author nor Union County College shall be liable for any special, consequential, or exemplary damages resulting, in whole or in part, from any user's use of, or reliance on, this material or material set forth on any Web Page to which it is linked.
Copyright: ã Maureen Greenbaum Sumware in NJ 2001, '02, '03, '04, '05, '06, '07, 08, 09, 10, 11, 12, 13. All rights reserved.