Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PROJECT STEPS Jordan Lemay is an associate consultant for Ferrante & Dahl, a global company that helps businesses succeed. She handles accounts in the northeast
PROJECT STEPS
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 E and paste it in cell AZ
Copy Jordan's name in cell J and paste it in cell J Clear the contents of cell J
In cell enter Company as the column heading.
Change the font size of the range : to point, and then bold the contents. Use Autofit to resize columns and to their best fit.
Apply the Text number format to the range A:A
In cell ES use Networking conference as the complete entry for the cell.
Ferrante & Dahl has a company policy to contact their clients once every two weeks.
In cell create a formula without a function that adds days to the date the client was last contacted cell G
Fill the range : with the formula in cell
In cell J enter as the contract amount for Claricomm.
In cell enter a formula that uses the SuM function to sum the contract amounts the range :
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started