EXERCISES

Job Interview

SPREADSHEETS

Active cell	An active is the cell you are currently working on
Auto sum	A formula that will add up a column of numbers
Cell Reference	The column number and the row letter of a cell
Cell	Each individual box on the spreadsheet
Column	The vertical reference on the spreadsheet
Fill	To fill a cell with color using the paint bucket tool
Fill handle	The dot at the bottom of each cell while it is active
Filter	The procedure to select certain information in a spreadsheet.
Formula	A formula must always starts with “=” signs and what the calculations for each cell
Graph	A visual representation of data
Grid Lines	The horizontal and vertical lines on the spreadsheet
Row	The horizontal reference on the spreadsheet
Selecting	To highlight a set of cells
Sheet	One page of a worksheet
Sheet tabs	Tabs that identify the worksheets in a workbook
Spreadsheets	A grid that organizes data
Value	A number that can be entered into a cell
Workbook	Many worksheets
Worksheet	One page of a spreadsheet

HOW TO TRANSFER DATA INTO EXCEL - CREATE CHARTS

Model Fax - Transportation

Dear Sir/Madam,

We are interested in using National Containers Ltd. to trasnport and deliver, door-to-door, a number of consignments in Europe over the next few months.

Our consignments consist of fragile crokery. An average crate measures 187x172x165 cm, and
weighs approximately 35 kg.

Could you please send a quotation and details of schedules. I would also be grateul for information about the necessary documentation.

Yours faithfully,

J. Merton
Sales Manager

Model letter - Bank

The Counties Bank

60 City Road

Salford M5 4WT

2 February2016

Richard Grey

Grey Transport Ltd

350 Dock Street

Salford M6 3WT

Dear Mr Grey,

Further to our meeting on 28 January, I am sorry to inform you that we will not be able to offer you a bridging loan at the present time.

Our decision to turn down your request was influenced by the current economic recession, which has affected our policy on loans to all sectors of industry and commerce. Fuerthermore, our directors now insist that all loans shoud be covered by negotiable securities, such as shares or bonds.

You may, however, be able to raise the capital you need from other sources, such as finance houses. Nevertheless, I should warn you that such sources will probably charge a higher rate of interest than that levied by us.

Once again, I am sorry not to have better news for you, but hope that we may be of more help in the future.

Your sincerely,

John Steele

Manager

Blog Vocabulary 

• Address bar- the bar at the top of the webpage where you type the URL.
• Adsense- ads from Google that run on the internet, even on your blog if you sign up.
• Archive- a list of your past posts.
• Beta- a description meaning a program or software is not yet completely finished, but is in test mode.
• Blogger- the person who blogs/author.
• Blogger- Google's blog systems/platform. It's fairly simple and often recommended for new bloggers due to ease of use.
• Blogging- the actual act of writing posts, or, over the long term, the ongoing activity of keeping up a blog is called blogging.
• Blogosphere- slang for the world/culture of blogs on the net
• Calendar- displays a record of when you've posted
• Category/Label- placing each post in a category or labeling it with a topic will help readers to find posts that interest them.
• Coding- using HTML codes to alter the appearance of the net, such as making it bold, or to insert links, photos or so on. However, many platforms have this built in with the simple click of a button.

• Comment Form- space where your readers are able to interact with you by leaving comments
• Comments- feedback and conversation from your readers.
• Content- the text entries, photos and videos in your blog
• Cookies- when your computer saves info about where/what you've visited on the net.
• Dashboard- administrative area where you manipulate your blog

• Domain name- what someone types into the address bar to find a site, the URL
• Email subscription- when someone signs up to receive an email whenever you post
• Flame war- insults, attacks or personal arguments in the comments.
• Font- how the type appears
• Google news alert- service that sends notice when news stories relating to your topic comes up
• Header- top of a document, blog post or webpage, typically contains the title, author, etc
• Link- a pathway to another page on the web
• Padding- putting together many posts to get your blog ready to roll out, or to prep for a vacation/time away from writing
• Permalink- the permanent place on the web where you can always find one certain post.
• Platform- software program used to blog.
• Rankings- how well a blog, post, or website performs as far as getting traffic.
• RSS Feed- similar to email subscription above

• SEO- search engine optimization, making your text optimal for the attention of search engines like Google, which helps you get traffic and ranking.
• Title- can be the title of either your blog or of a post.
• Widget- items on the side of your blog like calendar, archive, Adsense. Anything in the side columns.
• WYSIWYG- What You See Is What You Get (if you are posting in WYSIWYG mode, then you are NOT using code. What you type is what is seen on the blog after you publish.)

GIANT BLOGGING TERMS VOCABULARY

Comercio - Vocabulary In Company

Unit 15

Unit 17

future tenses - will, going to, doing game

future tenses - will, going to, doing game

Example Business Telephone Conversation

Ms Anderson (sales representative Jewels and Things): ring ring ... ring ring ... ring ring ...

Secretary (Henry Smith): Hello, Diamonds Galore, this is Henry speaking. How may I be of help to you today?

Ms Anderson: Yes, this is Ms Janice Roberts calling. May I speak to Mr. Franks, please?
Henry Smith: I'm afraid Mr. Franks is out of the office at the moment. Would you like me to take a message?

Ms Anderson: Uhm... actually, this call is rather urgent. We spoke yesterday about a delivery problem that Mr. Franks mentioned. Did he leave any information with you?
Henry Smith: As a matter of fact, he did. He said that a representative from your company might be calling. He also asked me to ask you a few questions..

Ms Anderson: Great, I'd love to see this problem resolved as quickly as possible.
Henry Smith: Well, we still haven't received the shipment of earrings that was supposed to arrive last Tuesday.

Ms Anderson: Yes, I'm terribly sorry about that. In the meantime, I've spoken with our delivery department and they assured me that the earrings will be delivered by tomorrow morning.
Henry Smith: Excellent, I'm sure Mr. Franks will be pleased to hear that.

Ms Anderson: Yes, the shipment was delayed from France. We weren't able to send along your shipment until this morning.
Henry Smith: I see. Mr. Franks also wanted to schedule a meeting with you later this week.

Ms Anderson: Certainly, what is he doing on Thursday afternoon?
Henry Smith: I'm afraid he's meeting with some clients out of town. How about Thursday morning?

Ms Anderson: Unfortunately, I'm seeing someone else on Thursday morning. Is he doing anything on Friday morning?
Henry Smith: No, it looks like he's free then.

Ms Anderson: Great, should I come by at 9?
Henry Smith: Well, he usually holds a staff meeting at nine. It only lasts a half an hour or so. How about 10?

Ms Anderson: Yes, 10 would be great.
Henry Smith: OK, I'll schedule that. Ms Anderson at 10, Friday Morning... Is there anything else I can help you with?

Ms Anderson: No, I think that's everything. Thank you for your help... Goodbye.
Henry Smith: Goodbye.

Keywords and Important Phrases

How may I be of help - This is a formal phrase used to show politeness. It means 'Can I help you?'
calling - telephoning
out of the office - not in the office
take a message - to write down a message from the caller
urgent - very important
delivery - the bringing of goods to a client
mentioned - said
resolved - taken care of
as quickly as possible - in the fastest manner, ASAP
shipment - delivery, the bringing of goods to a client
assured - certainty that something is true or will happen
pleased - happy
delayed -not be able to do something on time
looks like - seems
staff meeting - a meeting of employees
lasts - to take time
schedule - future appointments

Short Summary of the Telephone Conversation

Ms Anderson telephones Diamonds Galore to speak with Mr. Franks. Mr. Franks is not in the office, but Henry Smith, the secretary, speaks to Ms Anderson about a delivery problem with some earrings. The earrings have not yet arrived at Diamonds Galore. Ms Anderson tells Peter that there was a problem with the shipment from France, but that the earrings should arrive tomorrow morning.

They next schedule a meeting between Ms Anderson and Mr. Franks. Mr. Franks is not able to meet with Ms Anderson on Thursday because he is busy. They finally decide on Friday morning at 10 o'clock after a staff meeting that Mr Owen usually holds on Friday mornings.

IMPORTANT PHRASES

Introducing yourself

This is Ken.
Ken speaking

Asking who is on the telephone

Excuse me, who is this?
Can I ask who is calling, please?

Asking for Someone

Can I have extension 321?
Could I speak to...? (Can I - more informal / May I - more formal)
Is Jack in? (informal idiom meaning: Is Jack in the office?

Connecting Someone

I'll put you through (put through - phrasal verb meaning 'connect')
Can you hold the line? Can you hold on a moment?

How to reply when someone is not available
I'm afraid ... is not available at the moment
The line is busy... (when the extension requested is being used)
Mr Jackson isn't in... Mr Jackson is out at the moment...

Taking a Message

Could (Can, May) I take a message?
Could (Can, May) I tell him who is calling?
Would you like to leave a message?

Business Phone Call - Interactive Practice

Haga clic en Escuchar todo y siga adelante. Después que se sienta cómodo con toda la conversación, conviértase en la Persona A haciendo clic en el botón Persona A. Usted escuchará únicamente a la Persona B a través del audio. Habrá una pausa para que usted repita los enunciados de la Persona A. Haga lo mismo para la Persona B. La velocidad de conversación es de hablante nativo. Use el botón de pausa si la pausa entre cada enunciado es demasiado rápida para usted. Después de practicar varias veces, usted podrá hablar igual de rápido que un hablante nativo.

1

Listen All  |  Person A  |  Person B

A: "Hello? This is Steve." B: "Hi Steve, this is Mary from ABC Company. I'm returning your call." A: "Hi Mary. How are you doing?" B: "I'm doing great thanks." A: "Thanks for returning my call. I couldn't figure out why the ending balance on fiscal year 2003 didn't match the beginning balance on of 2004." B: "When I checked, it was matching. How much is the difference?" A: "The amount is exactly $42,000." B: "Oh. I know what the problem is. We opened another bank account at the end of fiscal year 2003. I might not have included the new bank statements when I sent over the information." A: "That makes sense. I'm just glad it wasn't out of my miscalculation. Can you send over the statements? I should be done by end of day since everything looks good." B: "Sure. I'll fax them to you immediately. Is 555-123-4567 the number I should fax it to?" A: "Yes. That is the correct number." B: "I'll do it right now." A: "Thank you for your help." B: "I should have sent them over to you the first time. I apologize for that." A: "No problem." B: "Thank you." A: "Thank you. Bye."

2

Listen All  |  Person A  |  Person B

A: "Hello, ABC Company." B: "Hi, this is Janet from Consult R Us. May I speak with Alex please?" A: "He's in a meeting right now. Would you like to leave a message?" B: "Yes. Can you have Alex call me back when he is available? My name again is Janet, and he can reach me at 555-987-6543." A: "It's Janet at 555-987-6543. Can I tell him what this is regarding?" B: "He sent over a fax, and the last page didn't print out. I will need for him to resend the fax to me." A: "I'll let him know." B: "Thank you." A: "Thank you for calling ABC." B: "Good bye." A: "Bye."

3

Listen All  |  Person A  |  Person B

A: "Microsoft, this is Steve." B: "Hi Steve, this is Richard from Third Hand Testing. I'm calling in regards to the MSN assignment. Do you have a minute to answer a couple of questions?" A: "Sure. What can I help you with?" B: "We originally agreed on 5 testing procedures, but our program manager received a mail indicating 4 testing procedures. Is 4 the correct number?" A: "Yes it is. We found that we can do the last one here." B: "Great. Does the timeline change because we reduced one of the testing procedures?" A: "We don't have to change the timeline. Our original timeframe was very aggressive." B: "That makes our job a little easier." A: "Do you have any other questions?" B: "No. That's all I had. Thanks for your time." A: "No problem." B: "Ok. Good bye." A: "Bye." http://es.talkenglish.com/lessonpractice.aspx?ALID=483

SHIPPING AND TRANSPORTATION

English Vocabulary for International Trade

TRADE DICTIONARY

TRADE DICTIONARY (from English to Spanish)

VOCABULARY LIST

BUSINESS DICTIONARY

Administración y Finanzas

KEY VOCABULARY

REVISION

These are the solutions for exercise: A) Classify these words under the following categories

Possible specific solutions: exchange, refund, replacement, credit note, repair

Proofs of purchase: invoice, credit card statement, bank statement, guaranty, warranty, receipt

Service providers: seller, trader, manufacturer, staff, supplier

Generic names for things you buy or sell: merchandise, goods, item, and article

Generic names for compensating a client: compensation, remedy, resolution, solution

This is the most important vocabulary from B) Bubble game

Problems with a product: not fit for purpose/ misdescribed /faulty / out of order / broken down / malfunctional / low standard / damaged / missing parts.

Words related to rights and duties: to be entitled to / to be (legally) obliged to / to take responsibility for / to take (further) action / to carry the blame / to blame / to go to court / provide with a remedy/ claim compensation

Complainer’s points: refuse to pay / to demand / to be entitled to a complete (full) refund / inconvenience / get money back / shipping costs.

Possible problems for customer: supplier passes the buck (the hot potato) / overcharged.

Other: At our expense/ at no cost to/ retailer.

Grammar - Exam - Comercio

2 ASIR - Preparing for the exam

Conditionals Chart

Conditionals 1 - 2

Conditionals 3

Exercises

Passive

Passive 2

Exercises

1 ASIR/DAW - 10 Accidental Inventions

Writing / Discussion

What invention couldn't you live without? 

Describe it.

• Is it a simple everyday object or something more complex?
• What's it for?
• What kind of design has it got?
• Has the design changed much since it was invented?

Look on the internet. Find out some history

• Who invented it?
• Where was it invented?
• Was it invented by accident?
• Why and how was it invented?
• What were they trying to do when they invented it (what else were they working on)?

What do you think about it? 

• Why is it important?
• What did it change or make better for people?
• What couldn't we do without it?
• Why couldn't you live without it?

Write about your invention
Write it using 3 - 4 paragraphs (see above)
Don't forget to have an introduction (say what it is and why you are choosing it)
and a conclusion (your opinion of it / why couldn't you live without it and why you think it's important)

How Technology Has Changed Family Life: A Multimedia Mashup

Phrases for dicussion

1. Introduction

• Let's begin/start with ...

2. What you think about somebody/something

• As far as I'm concerned ...
• I think ...
• In my opinion ...
• As far as I know ...
• In my view ...
• I don't think ...
• I don't believe that ...
• Well, if you ask me ...
• If you want my honest opinion ...
• I've never come across the idea that ...

3. How to agree/disagree

• I must admit that ...
• I totally/fully/partly agree.
• I agree/don't agree with you.
• I believe/don't believe ...
• I'm convinced that ...
• The way I see it ...
• It seems to me that ...
• I wouldn't say that ...
• I don't think so.
• You're right up to a point.
• You could be right.
• That can't be right.
• I don't agree at all.
• As a matter of fact, ...
• That's right/wrong.
• Exactly.
• I can understand ...
• It's hard to say.
• It's a fact that ...
• However, ...
• That's why ...
• John likes computers. - So do I.
• Steve doesn't like mobiles. - Neither do I.

4. Asking for clarification

• What do you think?
• What's your opinion?
• Would you like to say something?
• What do you mean?
• What are your ideas?
• What are you trying to say?

5. How to interrupt politely

• I'm sorry, but ...
• Can/May I add something?
• Sorry to interrupt, but ...

6. Other opinions

• On the one hand ... on the other hand ...
• They claim that ...
• They also say ...
• Opinion among teachers is that ...
• That's a matter of opinion.

7. Phrases to keep a discussion going

• Let's get back to ...
• As we just heard ...
• Where were we?

Administración y Finanzas

VOCABULARY  English for Communications

Comercio Internacional

COVER LETTER

Refer to the requirement given in the job description and demonstrate that you meet the requirements. Emphasise on experiences that are relevant for the job.

Details

According to your advertisement, your position requires (skills). These skills I have developed during ... (experience).

I understand the position requires (skills). I ... (details why you meet the requirements).

I recently graduated from (university) with a degree in (field).

Since 2002 / For 2 years I have been working for (company).

Following my training as a (job title), I spent (time) working for (company).

As (current job) for (company), I have developed my skills and experience as (job title)

Prior to my current position, I was working for (company), where I ... (jobs, tasks, skills).

Throughout my career I have acquired a thorough knowledge of ...

I have solid experience in ...

I have more than ... years of ... experience.

My experiences / skills / ... will provide your company with a highly productive (job title).

I have always had a strong interest in ...

I am very competent in ...

I very much enjoy both ... and ...

My experience in (field) have convinced me that (future position) is a career option I would like to explore.

My high degree of motivation has been appreciated by my previous employers.

Thanks to my high degree of motivation I was quickly promoted to positions of greater responsibility.

The enclosed CV / resume elaborates on the details of my skills and experience.

USEFUL PHRASES (with translation to different languages)

PRACTICE

Example letter

JOBS

JOBS in Great Britain

REJECTING AN APPLICANT