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 9-point 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
- Fall '11
- Expression, Tuple, customer birthday list, column D. Format, horizontal left indent