Ferrante & Dahl has a company policy to contact their clients once every two weeks. In...

 

Transcribed Image Text:

Ferrante & Dahl has a company policy to contact their clients once every two weeks. In cell H4, create a formula without a function that adds 14 days to the date the client was last contacted (cell G4). Fill the range H5:H9 with the formula in cell H4. 7. Ferrante & Dahl has a company policy to contact their clients once every two weeks. In cell H4, create a formula without a function that adds 14 days to the date the client was last contacted (cell G4). I 8. Fill the range H5:H9 with the formula in cell H4. 9. 10. In cell 36, enter 34675 as the contract amount for Claricomm. In cell 310, enter a formula that uses the SUM function to sum the contract amounts (the range 34:39). 11. Change the orientation of the worksheet to Landscape, and then change the print scaling to fit the sheet on one page. Client Tracker Current Accounts H 1 3 ID Name Company Contact Info Met at Notes Last Contacted Follow-up Done Contract Amount 4 1202 Janet Mahajan ARC Logistics Operations Manager (845) 555-2301 New system launched Trade show 2020 March 2021 2/18/2021 No $ 50,575 Resourcing Manager 5 1203 Louis Bednarski Zephyr Networks (914) 555-3309 Networking con Second contract 2/18/2021 No $ 63,455 Executive Director 6 1204 Amin Shanti Claricomm 71205 Carrie Drake (212) 555-8440 President Drake & Associates (973) 555-6405 SEO convention Travels frequently 2/18/2021 No $ 34,675 Trade show 2020 Major upgrade work 2/25/2021 No es 72,375 City Manager 81206 Lane Chowdhury City of Trenton 91207 Will Miranda US Fabricating (609) 555-4565 CIO (862) 555-0423 Client introduction Networking conference Pilot project System upgraded November 2020 2/25/2021 No $ 13,500 2/26/2021 No $ 75,560 10 $ 310,140 11 navalonad her Iordan Lemay Ferrante & Dahl has a company policy to contact their clients once every two weeks. In cell H4, create a formula without a function that adds 14 days to the date the client was last contacted (cell G4). Fill the range H5:H9 with the formula in cell H4. 7. Ferrante & Dahl has a company policy to contact their clients once every two weeks. In cell H4, create a formula without a function that adds 14 days to the date the client was last contacted (cell G4). I 8. Fill the range H5:H9 with the formula in cell H4. 9. 10. In cell 36, enter 34675 as the contract amount for Claricomm. In cell 310, enter a formula that uses the SUM function to sum the contract amounts (the range 34:39). 11. Change the orientation of the worksheet to Landscape, and then change the print scaling to fit the sheet on one page. Client Tracker Current Accounts H 1 3 ID Name Company Contact Info Met at Notes Last Contacted Follow-up Done Contract Amount 4 1202 Janet Mahajan ARC Logistics Operations Manager (845) 555-2301 New system launched Trade show 2020 March 2021 2/18/2021 No $ 50,575 Resourcing Manager 5 1203 Louis Bednarski Zephyr Networks (914) 555-3309 Networking con Second contract 2/18/2021 No $ 63,455 Executive Director 6 1204 Amin Shanti Claricomm 71205 Carrie Drake (212) 555-8440 President Drake & Associates (973) 555-6405 SEO convention Travels frequently 2/18/2021 No $ 34,675 Trade show 2020 Major upgrade work 2/25/2021 No es 72,375 City Manager 81206 Lane Chowdhury City of Trenton 91207 Will Miranda US Fabricating (609) 555-4565 CIO (862) 555-0423 Client introduction Networking conference Pilot project System upgraded November 2020 2/25/2021 No $ 13,500 2/26/2021 No $ 75,560 10 $ 310,140 11 navalonad her Iordan Lemay