This preview shows page 1. Sign up to view the full content.
Unformatted text preview: , nest AND . For Logical1 , use D4>=1 . For Logical2 , use D4<5 . This tests if the customer is between 1 and 4 years old. 7. Return to the second IF function and key Between 1 and 4 as the Value_if_true . For the Value_if_false , key Over 10 . Click OK . 8. Format the results to match other labels in the row, and copy the formula. Set a horizontal left indent of 1 for the results. 9. Center the labels in rows 1:2 across the data. Use borders, fill, row height and column width to enhance the readability of your worksheet. 10.Change the birthday for Maureen Weinberg to one that will make her over 10 years old. 11.Add a header using a 9point font in all sections. Make sure the sheet will fit on a portrait page. 12. Make a copy of the worksheet and name it CustBirthdaysFormulas . Hide column C and display the formulas. Fit this sheet to one landscape page. 13.Prepare and submit your work. Save and close the workbook....
View
Full
Document
This note was uploaded on 12/03/2011 for the course INFS 3250 taught by Professor Gordon during the Fall '11 term at Toledo.
 Fall '11
 Gordon

Click to edit the document details