Shelly Cashman Excel 2019 | Module 1: End of Module Project 1 | Help in Homework |

24 / 7 Live Support
[e-mail]
[phone]
[phone]
Shelly Cashman Excel 2019 | Module 1: End of Module Project 1
Ferrante & Dahl Consultants
COMPLETE A CLIENT TRACKER WORKSHEET
GETTING STARTED
Open the file
SC_EX19_EOM1-1_FirstLastName_1.xlsx, available for download fromthe SAM website.
Save the file as SC_EX19_EOM1-1_FirstLastName_2.xlsx by changing the “1” to a“2”.
If you do not see the.xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
With the fileSC_EX19_EOM1-1_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
If cell B6 does not display your name, delete the file and download a new copy from the
SAM website.
PROJECT STEPS
1 .Jordan Lemay is an associate consultant for Ferrante & Dahl, a global company that helps businesses succeed. She handles accounts in the northeast region of the United States and has created a worksheet to help her keep in touch with each client. She asks for your help in completing the worksheet.
Go to the
Current Accounts worksheet. Cut the worksheet subtitle from cell E2 and paste it in cell A2.
2. Copy Jordan's name in cell J2, and paste it in cell J12. Clear the contents of cell J2.
3. In cell C3, enter Company as the column heading.
4. Change the font size of the range A3:J3 to 12 point, and then bold the contents. Use
AutoFit to resize columns G and J to their best fit.
5. Apply the Text number format to the range A4:A9.
6. In cell E5, use Networking conference as the complete entry for the cell.
7. In cell H4, add 7 days to the formula, which contains a reference to cell G4.
8. Fill the range H5:H9 with the formula in cell H4.
9. In cell J6, enter 34675 as the contract amount for Claricomm.
10. In cell J10, enter a formula that uses the SUM function to sum the contract amounts (the
Range J4:J9).
11. In cell J11, enter a formula that uses the AVERAGE function to average the contract amounts (the range J4:J9).
12. Change the orientation of the worksheet to Landscape, and then change the print scaling to fit the sheet on one page.
Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.