Answered step by step
Verified Expert Solution
Link Copied!

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 E2 and paste it in cell AZ.
Copy Jordan's name in cell J2, and paste it in cell J11. Clear the contents of cell J2.
In cell C3, enter Company as the column heading.
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.
Apply the Text number format to the range A4:A9.
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 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,
In cell J6, 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).
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Data Mining

Authors: Pang Ning Tan, Michael Steinbach, Vipin Kumar

1st Edition

321321367, 978-0321321367

More Books

Students also viewed these Databases questions

Question

1.who the father of Ayurveda? 2. Who the father of taxonomy?

Answered: 1 week ago

Question

Commen Name with scientific name Tiger - Wolf- Lion- Cat- Dog-

Answered: 1 week ago

Question

13. You always should try to make a good first impression.

Answered: 1 week ago