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

Subject:MS ExcelPrice:19.99 Bought7

Share With

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 from

the 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 file

SC_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.

Final Figure 1: Current Accounts Worksheet