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
- Fall '11
- English-language films, Tuple, Click cell