letter

September 23, 2008

Mr. George Gilhooley
XYZ Company
87 Delaware Road
Hatfield, CA 08065
(909) 555-5555

Dear Mr. Gilhooley:

I am writing to apply for the programmer position advertised in the Times Union. As requested, I am enclosing a completed job application, my certification, my resume and three references.

The opportunity presented in this listing is very interesting, and I believe that my strong technical experience and education will make me a very competitive candidate for this position. The key strengths that I possess for success in this position include:

• I have successfully designed, developed, and supported live use applications
• I strive for continued excellence
• I provide exceptional contributions to customer service for all customers

With a BS degree in Computer Programming, I have a full understanding of the full life cycle of a software development project. I also have experience in learning and excelling at new technologies as needed.

Please see my resume for additional information on my experience.

I can be reached anytime via my cell phone, 555-555-5555. Thank you for your time and consideration. I look forward to speaking with you about this employment opportunity.

Sincerely,

John Doe

------------------------------------------------------------

506 Country Lane
North Baysville, CA 53286
July 16, 2007

Dear Susan,

It feels like such a long time since the last time I saw you. I know it's only been several weeks since I saw you. So far my summer has been great!

I spend my all my weekends at the beach. I am getting a nice tan and you can no longer say I am paler than you. I have been playing lots of volleyball, surfing and building a nice collection of sea shells. Just this past weekend I took second place in a sandcastle building contest!

On the weekdays I work. I drive an ice cream truck around and sell ice cream to the kids. It is so cool. It is a combination of the two things I love most, ice cream and kids. The pay isn't too great but I love the job so much.

I hope the summer's been going well for you too. There's only a month and a half left in summer vacation and after that it's back to school. Would you like to meet up some time to before school starts?

Your friend,

John Doe

P.S. John Austin says hi.

answer this exercise

A firm pays its salespersons by a commission system. Each unit costs $30 and each salesperson is paid $5 per unit sold. As an added incentive, a bonus of 7% of the total sales made should the salesperson’s sales exceed $1000 is awarded. Calculate the wages earned by each of the salespersons:

Salesperson Units Sold
Jennifer Smith 34
Adrian Walshe 27
Norah Walker 38
Deirdre Connolly 29
Michael Durnin 44

Excel IF function

♦ The logical functions in Excel are a small group consisting of six functions
♦ These functions are noted for their black or- white results
♦ A logical function can return only one of two values: TRUE or FALSE
♦ The most common and powerful of the logical functions in Excel is the IF function
♦ This function is particularly powerful because it can test for a particular condition in the worksheet and use use one value is the on condition is TRUE and another is the condition is FALSE

♦ The format of the IF function is:
IF(logical_test, value_if_true, value_if_false)
♦ Logical_test is any value or expression that can be evaluated to TRUE or FALSE
♦ Value_if_true is the value that is returned if logical_test is TRUE
♦ Value_if_false is the value that is returned if logical_test is FALSE
♦ Value_if_true and/or Value_if_false can be another formula

♦ Consider the following IF function:
=IF(B2>=1000,100,50)

♦ If the Logical_test is TRUE, or in other words if the value of B2 is greater than or equal to 1000, than the function returns a value of 100
♦ If the Logical_test is FALSE, or in other words if the value of B2 is not greater than or equal to 1000, than the function returns a value of 50


♦ Consider the following IF function:
=IF(B2>=1000,B2*0.1,B2*0.05)

♦ If the Logical_test is TRUE, or in other words if the value of B2 is greater than or equal to 1000, than the function returns 10% of B2
♦ If the Logical_test is FALSE, or in other words if the value of B2 is not greater than or equal to 1000, than the function returns 5% of B2

♦ Consider the following IF function:
=IF(B2>=1000,”A $1000 or better”, “Less than a grand”)

♦ If the value of B2 is greater than or equal to 1000, than the function returns the string “A $1000 or better”
♦ If the value of B2 is not greater than or equal to 1000, than the function returns the string “Less than a grand”
♦ When you use text as the value_if_true or the value_if_false arguments, you must enclose the text in a pair of double quotation marks (“ “)

Practice:

A firm pays its salespersons by a commission system. Each unit costs $30 and each salesperson is paid $5 per unit sold. As an added incentive, a bonus of 7% of the total sales made should the salesperson’s sales exceed $1000 is awarded. Calculate the wages earned by each of the salespersons:

Salesperson Units Sold
Jennifer Smith 34
Adrian Walshe 27
Norah Walker 38
Deirdre Connolly 29
Michael Durnin 44

How IT changed the world?