This preview shows page 1. Sign up to view the full content.
Unformatted text preview: f. Click cell E16. Click the Insert Function button. g. In the Or select a category list, choose All . Quickly key coun and find COUNTIF . Select it and click OK . h. For the Range box, select cells I6:I12. i. In the Criteria box, key >250 to count employees who earned more than $250. Click OK . 8. Key Over $250 in cell C16. 9. Add Top and Double Bottom borders to cells H13:I13. 10.Press CTRL+HOME. Add a footer and adjust the left and/or right margin to fit the sheet to a portrait page. 11. Make a copy of the worksheet and name it Formulas . Have the formulas utilized in the spreadsheet on this page. 12.Press CTRL+~. AutoFit the columns. 13. Click the Page Layout tab. Click the Page Orientation button and choose Landscape . 14. In the Scale to Fit group, click the arrow with the Width button. Choose 1 page . Use the same choice for Height . 15.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