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 needs to 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.

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 values in column E before you write the formula in column C. But, if you have already written the formula in cell c1 , name the values in column E, and then Apply the names to the formula in column C (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 $6 per person with a $20 maximum per family.

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 ] [ VLOOKUP Function Hints ] [ IF Function Hints ] [ Cell Names & Reference ] [ IF & Naming Quiz ] [ PMT Function Hints ]
[ References ] [ In the News ] [ Cyber-Briefcase ] [ Learning Pyramid ] [ Photos of Students ] [ CIS100 Comp. Apps ] [ The Internet - CIS120 ] [ Web Page Development ] [ Tips and Tricks ] [ Job Search ] [ Spring '08 Schedule ] [ Tutorial Sites ] [ Hints for Printing ] [ About M.L.G. ] [ Disclaimer ]

This page was created by Professor Maureen Greenbaum and was last updated on 03/28/07 .

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, 2008. All rights reserved.