This preview shows page 1. Sign up to view the full content.
Unformatted text preview: e. Click in the Value_if_true box. Key Yes . f. Click in the Value_if_false box. Key No and click OK . 5. Center the results. Copy the formula to cells D5:D20. 6. Right-click the row 21 heading and hide the row. Add the missing border. Press CTRL+HOME. 7. Add a header: On the Page Layout tab in the Scale to Fit group, set both the Width and Height commands to 1 page . 8. Make a copy of the worksheet and name it CustBirthdaysFormulas . Display the formulas, fit the columns, and fit the sheet to one landscape page. 9. 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