1 - West Chester University

Spreadsheet Sheet Exercise 1



What to buy for a notebook computer?





Wesley W. Thomas

Department of Management

West Chester University









1

Comparing different types of computer systems



Computers come in varying sizes, levels of power and performance. Use the Web to find out

about computer system configurations. Do some comparison shopping for notebook computers

from four different vendors (Dell, LENOVO, Hewlett-Packard and Sony). Please note that

Lenovo purchase the PC division from IBM. In many instances this lessons will use both names

interchangeably. From each of these sites, choose the most expensive and least expensive

notebook computer systems you can find for each of the four companies. Create a table for each

of the three types of computers and compare them based on the following criteria:

 Type and speed of CPU

 Type and speed of RAM

 Amount of CPU cache

 System bus speed

 Hard disk capacity and speed (revolutions per minute or rpm)

 Number and type of ports

 Size of monitor

 Cost

 Docking features

If the information in this list is NOT available, then you should plan to put the value NA for not

available in the respective cells when necessary.



In order to help you develop certain software skills, we are going to enhance this exercise to

include instructions on how to use a spreadsheet software system to present the information.

Follow these instructions you will create an Excel spreadsheet. We are using Excel since it is the

most common spreadsheet software system used by business today. The more skills you have

with this and any other business software systems the more employable you will be when you

graduate.



We are going to simulate the process whereby you would analyze what system would be best for

your company to buy for its staff. Remember … the most important thing is to focus on what the

staff need to do their jobs. This will be both generic in the sense that everyone needs it and

specialized since some staff often need specialized systems to do their work.



The first question is “what common tasks are our staff going to be doing” and the obvious

follow up is “what is the best software to support those tasks?”



You should open a Microsoft Word file and list those common software tasks you expect you

staff will be doing. Save this rough document under the name memo.doc so you can use it later.



We are going to build a matrix of the characteristics of various notebook computers using Excel.

Start Excel…Usually you go to the Programs option and look for Microsoft Office and Microsoft

Excel. The system should start with a blank spreadsheet. If you have used a spreadsheet system

before you know that it involves columns and rows. Each column indicated by a letter and each

row indicated by a number.



We will make some simple assumptions about these lessons. Unless you are told differently you

will be using the left button on the mouse. In a few instances you will use the right button but you

will be explicitly told to use the right click button if it is needed. Otherwise you click the left

button.







2

Move the cursor to cell A1 .. in other words Column A Row 1. We are going to put text in the

column so move to the line break between the A and B column. Click on the line between them

hold the left button down and pull the line to the right. Let the button go and the column will be

wider. As is often the case with software systems there is often more than one way to completing

a task. In this case you can click on column A to highlight the entire column. The column will

appear as follows …



Now click the right button to show the options for this column.









The options are a little involved but we want the Column Width option.

Click on it to show the following …









Place the number 45 in the column width space and click OK.

Later on, if the column is too wide, you can change it.



When we set up spreadsheets, it is always a good idea to place some blank lines at the top

of the worksheet area to add text and labels. Let us begin our table in cell A5. Click on

A5 and enter the following text Characteristics of the Computer followed by the Enter

key.



We are going to study four computer companies so go to cell B6 and enter input

LENOVO. Press the enter key. Notice the default is to move to the cell below the input

cell when you press the enter key. You can make input a little easier by using the cursor

arrows on you keyboard. Move the cell C6 input “Dell” and press the right directional

arrow. Notice the system moves you to the next cell to the right. Put Hewlett-Packard in

cell D6 and press the right arrow key.









Notice that the name for Hewlett-Packard does not fit in the column. It moves over into

cell E6. Now this is fine if you are not going to put something in cell E6. Move to E6 and

put in Sony. Notice that this now cuts off the display of D6. Click on cell D6. If you look

at it carefully and look at its content displayed cell content display area in the upper left,

you see that the display has been impacted but not the actual data.









3

The obvious problem is the width of the column and/or the default size of the letters.

Click on column D.. right click to select the Column Width option and change the width

to 15 spaces and click OK. Note that column D is wider but the others are not.



Now we will show you something COOL. You can select multiple columns. Click on

column B so that it is highlighted. Now hold the Shift key down and click on Column E.

You have selected all four columns. Right click and change the spacing to 15. This

changes for all of the selected columns. If you do not like that simply select the Edit

menu option



Then select the Undo Column Width option. This sets

to column width back to what is was previously. This

Undo capability is an extremely valuable feature since

it will often help you Undo major changes that you

mistakenly made. Keep it in mind if you make a mistake. You should also note that key

functions such as this can also be completed with ctrl characters. This is shown about

where the Undo Column Width option can be easily executed by holding the CTRL key

down and pressing the Z key.



Input the title for Sony in cell E6. This looks fine thus far. Now let us move to column A

to input the characteristics of our computers we are considering. Input the various

characteristics in column A as shown below in the row positions indicated…









\\









You might want to file the workbook at this time to make sure your changes are saved. It

is always a good idea to save you work regularly so you will not lose the work due to a

power failure. Remember!!! You are always working on a copy not the original. Click on

the File menu option and the Save sub-option.



We now have a minor problem since we need to examine two computers for each

company… the most powerful and the least powerful. This is usually defined by the type

and speed of the primary processor, the BUS speed and the hard disk capacity. You are

going to research both for each company. It is not uncommon for the most powerful to be







4

the most expensive and the least powerful the most expensive although this is not always

the hard and fast rule.



If we are going to compare the least and most for each company we will need to have

some additional columns. This involves inserting some columns. Move to Column C and

click on it to highlight the column. Right click and select the Insert option. This places a

blank column to the left of the C column. This will make space for the least and most

powerful systems for LENOVO. Do this for the other companies until the columns

appears as follows …









Move to cell B7 and enter the words Most Expensive. Add an additional space between

the words Most and Expensive. We will explain why later. Click cell C7 and enter the

words Least Expensive. We have to set up columns for each type of machine. Now we

can do a simple copy of this ..

Click on cell B7 . Then hold the shift key down and click on cell C7. You have therefore

selected these cells together. Right click and select the Copy option. Now move to cell

D7 and click it. Hold the shift key down and click on cell I7. The screen should appear as

follows…









What the system is saying is that you are copy from the cells highlighted in the dashed

lines to the cells outlined. Right click and select the Paste option. Now that is cool…

You just learned how to Copy and Paste. If you had used the Cut option rather than Copy

the system would have removed the results from the cell and pasted them into the

designated location.



This is just fine but we can make our system better by centering the company names over

the two columns. This involves selecting the two cells above the Most and Least columns







5

for each company and merging them together. Click on cell B6 to select it. Press the shift

key and select cell C6. both are therefore selected. Click the merge button in the tool bar

….





Notice that it merged the two cells together and centered the text within the resulting cell.

Do this for the columns of each company.



Our cells representing Most Expensive and Least Expensive have the text pushed to

the left in each cell. This is referred to as being left justified. This is the default format

for text while the default format for numbers is right justified. When right justified the

numbers are pushed to the right. This formatting is often very valuable in simply telling

you if the computer is handling the data as text or numbers. We need to change this form

these descriptive cells so it looks better. We want each cell to have the text centered

within the column. This involves using the powerful format utility. Click cell B7 to select

it. Then press the shift key and click cell I7. You have selected all the cells with the text

to be formatted. Another way is to select cell B7 and slide the cursor to the right until you

reach I7. This also selects the desired cells. Right click to cell base menu and pick the

Format cells option …





This menu appears a little overwhelming

but it is not. Notice there are a number of

tabs along the top. Each one contains a

set of options for formatting cells. Click

on the Alignment tab.









The Format Cells Alignment options screen will

appear as shown here.



This has a number of different options for aligning

text mainly within a cell. Click on the Horizontal

pull down and change the option from General to

Center. Click OK. You changed the format to

centered within the cell.







6

We can also make the worksheet look a little better. Move to row 8 column A. Move all

the way to the left moving the cursor over the row identifier on the far left. Click the cell

with the row value. In this case the number 8. This highlights an entire row. Right click a

select the insert option. This puts a blank line above the selected line and should make



the worksheet look a little better. Your cost values should now be in row 20.



One problem that may occur in formatting the output for printing is that width of the

columns. The Most Expensive and Least Expensive headings may make the columns too

wide. Making them smaller will cut off some of the text and making the text size smaller

will make it harder to read. One powerful feature of the system is the ability to not only

widen a column but also widen a row. By widen a row we mean changing the height of

the row. Move to the far left of column seven. Click on the seven label on the far left to

highlight the entire column. Then right click to show the following…



Click the Row Height option. Enter the number

25 in the box and click OK. This increased the

height of the row considerably but it is not

enough since we have to tell the system to do a

word wrap if the text is too wide for the column

width. With the entire row selected, right click

and select the Format Cells .. option.









Click the Wrap Text option and change the horizontal

text alignment option to Center as indicated and click

OK. This telling the system to center all words in the

middle of the column and wrap the words on more

than one line in the cell if the column becomes to

narrow.









To demonstrate this move the cursor to column B and click the B at the top to select the

entire column. Press the shift key and click the I in column I to select it. Columns B

through I should be selected. Right click and select the Column Width option. In the box

enter the value 10 and click the OK button. Notice the way the system changed the text to

accommodate the narrower width.



Save your work at this time. You can do this with the File Menu option at the upper left

followed by the Save option. Another easier trick is to use a CTRL character and the letter









7

S. Hold the CTRL key down and press the S key. This takes your workbook and saves it

back on the disk replacing the previous copy under the same name.



Now if you have not researched the result for each vendor do so now and fill in the

respective cells. You may need to widen the various columns to accommodate the data.

In addition you should get a price on the Microsoft Office Suite software to support the

needs of your staff. This should include Microsoft Word, Excel, Access, Outlook, and

Powerpoint.



It is most important that you input the total cost of each system in the respective column.

We need to add the software costs to each machine. Since you probably have one number

for the software we can put it in row 21. In cell A21 place the text “Office Suite”. In cell

B21 input the dollar value. You can save a great deal of time by simply copying this

value to the other cells. Click on cell B21 , right click and select the copy option. Move to

cell C21 and select it. Hold the shift key down highlight cell I21, right click and select the

Paste option. This should copy the value into all of the cells.



We need to know the total cost of each machine. In cell A22 place the following text

Total Single System Cost. In cell B22 we need to see the total cost of hardware and

software. We can build it by typing as we did before or we can use our cursor. First place

a + in cell B22 then click B20 which will select it. Type another + and select B21. This

builds the formula. Simply press the Enter key to apply it. We do not want to do this for

each computer so we will use the copy features as indicated in the previous section.

Select cell B23 right click and select Copy. Click cell C23 then hold the shift key down

and click cell I23. Right click a select the Paste option. This replicated the formula for

each cell but if you look at the contents of each cell you see that the system adjusted for

the columns. Click on cell C23 and look at the contents. It is the same formula but for

the fact that it is using column C rather than column B. It changed the column reference

in each cell.



From the viewpoint of management we need to decide how the purchase of these

machines will impact out budget. In cell A25 type in the following Total Units to

Purchase. In cell B25 type in the value of 20.



We can put the computer to work by making it total the cost of each type of computer by

multiplying the number of units to purchase times the cost per unit.

In cell A23 type in the following Total Cost of Units. Move to cell B23 so we can input

a formula. Enter the following in the cell and press the enter key … +B22*B25. This

formula is multiplying the value of the computer times the total number of computers to

purchase. This will be the total cost of purchasing 20 systems.



Copy this formula from cell B23 to cells C23 thru I23. This looks weird doesn’t it. Look

at cell C23. It changed the cell positions instead of focusing only on the number of

computers desired. You want this number to be a constant and therefore it must be

handled as an “absolute” value. Excel does this by placing a $ sign prior to the cell and









8

the row reference. This seems difficult but it is not. Click on cell B23. The formula will

be shown in the upper left.









You can move the cursor in this area and change the formula to place a dollar sign before

the B in B25 and a dollar sign before the 25 as follows.









Then hit the enter key. You have told Excel to use this as an absolute value. Now copy

the contents of cell B23 to cells C23 thru I23. Look at the contents of each cell and you

will notice that the reference to B25 remained constant while the reference to the column

positions changed. This is a very powerful feature that all spreadsheets can do.



Simply go to cell B25 and change the value from 20 to 10 and watch what happens. You

can play “what if “ with this to determine total costs depending on the number of units

purchased. This is a very small representation of the true power of a spreadsheet. It does

multiple calculations and therefore saves time and increases productivity. A simple

question. How long would it take to do those calculations it the boss asked you want it

would cost for 10, 20 or 30 units?

We are going to need to format our costs figures so that they look like dollar values rather

than just raw numbers. Click on cell B20 to select it. Using the shift key click on cell I23.

You have now selected a large region of cells rather than segments of a single row. Right

click and select the Format Cells option. Select the Number tab and the Category: called

Currency.





The default for the currency option is a $

symbol before each value and two decimal

places. Click OK.



The result is nice but it does now follow

standard accounting formats where the

decimals are in the same column.



Change the alignment so that you select the

Accounting option rather than the Currency

option for these cells. Click OK.









9

A problem may have developed with the data. What happened you ask !!!! Why the ###

symbols in each cell? DO NOT PANIC! The system is telling you the columns are not

quite wide enough for the data. Widen the Columns until the numbers appear. We might

want our columns to be the same so let us standardize the width. Select the column B

through I that is the widest and widen it more if necessary. Select this column and right

click to display the Column Width option. Select the option, change the width to a new

value and click OK. Now that you know the width of the widest column select column B.

Hold the shift key down and select column I. You have selected all those columns. Right

click … select the Column Width option and change the value to match the widest

column. Then click OK. This changed the column width of all the selected columns to

match the widest.



Save you work one more time. CTRL S



The most immediate question now is …”will the columns be too wide to print?”.

Click on the File Menu option (upper left) and select the Print Preview option. You may

have a significant problem in that the columns do not fit on a standard 8.8 by 11 sheet in

what we call a Portrait mode. You can solve this in one of two ways. One is to modify

any columns to be more narrow and taking less space. The other is to modify the printing

format. From the Print Preview screen select the Setup option. The following standard

page setup screen should display…



You defaults are set to Portrait,

normal size, fit to page, etc.



Click on the Landscape option and

click OK.



If this does not work, then lower the

Adjust To: value to a lower

percentage and click Ok.



Now see if your data are going to

print properly.



You could also make column A

smaller in width since it may not need to be 45 characters wide.



There are a number of other ways to make the data fit on one page. These include but are

not limited to ….



- Selecting all the containing data or text … right click select the Font Size option

and make the font size smaller. You can then make the columns smaller in width

- Select a row … right click select the Row Height option to allow text in a given

cell to wrap around with the cell. This avoids having the text suppressed by data

in the cell to the right.







10

Note that once you have looked at the possible output using the Print Preview option the

system will start to put a dashed line around the outside of each printed page in the actual

worksheet. This should help in looking at potential output in the future.



As you get more familiar with Excel your skills and abilities to manipulate the

information with increase. Remember! The more knowledgeable your are with this

software the better off you will be in your business career. This does not mean you have

to be an Excel expert but it does mean you will have the skills that business wants and

assumes you should have.



In cell A1 you should place your name. In cell A2 place you course number and section.

This will help identify your output. The neat thing about spreadsheet software systems is

that they have unique functions built into the software. These functions are quite diverse

and can be somewhat complicated as well as quite simple. One of the simpler ones is the

ability to put the present date into a cell. Click on cell B1. Just above this cell on the

toolbar you will see a fx button. This is the function button ..



It is the insert function button. Click on the fx.





The insert function window will appear.



You can type in a free form request to

find a given function in the Search for a

Function option. In addition the system

lists those functions that have been

recently used on this computer.



Click on the Search for a Function

section and type in the words today’s

date and click the GO button. The

system displays three or more date

functions. Click on the NOW function in

the list. Notice that the system indicated

that you were going to insert the present

date into the field. Click OK. The system

will pop up another screen showing you exactly what the function does. Click OK. With

many other functions this second screen would ask for various parameters that the

function may require. The =NOW() and =TODAY() functions essentially do the same

thing. The data in the cell will always be the present date when you activate the

workbook.



This dating option can be valuable since it will automatically insert the present date into

the cell so you know the date that the data were created. Dating all output like this is a

good common practice. Indicating the source and the author of the spreadsheet is also







11

good practice. Your future employer may have their own common practices but if they do

not you should develop your own.



You may want to familiarize yourself with the many functions in Excel. This will help

develop your knowledge of the capabilities of the software



Press the CTRL key followed by the S key to save your work.



Now let us go and have some fun. If we really want to impress our superiors, we can

graph the data showing the results of the spreadsheet. Some people think in terms of

numbers and tables and others are better at processing information in a graphic format.

Using the power of the spreadsheet to create graphs is always a good idea.



We are going to graph the total cost of purchasing systems comparing each company.

Click on cell B23. Hold the shift key down and click on cell I23. Thus you have selected



the data to display. In the toolbar there is a graphing icon.. It is in the form

of a little graph. Click on this tool to display the following…





Note that we have been using the word

graphs but Microsoft likes to word

charts. They mean the same thing in

this context. Graphs is the more

traditional word used for graphic

display of data.



Let us explore for a moment. On the

left side of the chart wizard you see a

Chart Type: list. Notice that Column is

the default and the various column

types are displayed on the right side.

Click on any chart type and you will

see the various types and sub-types.







We are going to use the column chart type and the simplest one in the upper left corner.

The first column sub-type should be highlighted in dark. One of the really cool features

of this is an ability get a rough view of the chart without actually creating it. Notice on

the lower right of the window there is a Press and Hold to View Sample button. Using the

left button on the mouse click this button and hold it for a moment. This gives a brief

view of what the chart will look like. The formatting and text will come later. Let go of

the button and press the Next button.









12

This moves you to step 2 of the chart process. This displays the chart and the data range

that you selected.



Notice the window has a Series tab at the top. Click the tab.









The series window allows you to modify the format of the graph before creating it. When

you developed the worksheet you gave it a title found in cell D4. We are going to use this

in our graph. This gets a little tricky so pay careful attention. To the right of the Name:

box there is a icon …Click on the icon . The following will

display









This is a little confusing but what the system wants you to do is insert in the narrow box

the cell reference to the Name: Click on cell D4 in the worksheet. Notice this places the

sheet reference and the cell reference in the box. =Sheet1!$D$4. Once this appears either

press the Enter key or Click the little box to the right.



Notice this places the text from the worksheet in the title of the chart. If you change the

title in the worksheet it will automatically change in the chart.



The Y axis is defined in the spreadsheet in terms of the vertical dimension in this case the

total dollars for the computers. We need to label the X dimension or horizontal axis. To

do this we use the Category (X) axis labels box. Click the icon box to the right side of

this.









13

This will bring up a similar box as was used in the naming process previously. Click on

cell B6 .. hold the shift key down and click cell I7. This highlights the text to be used.

Press the Enter key. This displays not only the model type but also the difference between

most and least expensive. Click the Next button.









This takes us to step 3 as follows …



This screen allows us to make even more modifications to make the graph easier to

understand. In the box entitle Category (X( axis type in Model of Computer.



In the Value (y) axis box type in Total Cost as indicated to the left. Notice the labeling

dimension of the graph change to reflect this.



No you are not finished yet. Click the Legend tab on the Step 3 window to display the

following …



The series box on the right side of the

chart is a little redundant. This allows

you to place this legend box in other

locations but in this case we want to turn

it off. Click the check box to the left of

the Show Legend option. This turns the

option off.



Click the Next button.









14

You have now moved to the final stage. The system wants to know where you want the

chart placed.



The default is to place it in the

worksheet itself as an overlay. This is

fine but it often blocks one’s view of the

worksheet data. It is valuable if you are

doing some kind of “what if analysis”

and what to see the graphic impacts of

the changes.



In this case we are going to place this as a new sheet in the workbook. Click on the As

New Sheet and then click Finish. NOW THAT IS COOL….



Save your workbook … CTRL S. By doing this you save the worksheet and the graph in

one file.



Now you know the boss has a preference for charts that have green bars. If you chart

bars are not green, you can change them. In the chart area click on one of the bars. This

should place a little black square in each of the bars. With your mouse over one of the

bars right click to display the editing options…



Note that there are a number of options here that allow you to

change the chart including the type, source of data, etc. Click

on the Format Data Series option.









There are a number of options here as

you can see by the tabs. In this case we

simply want to change the color of the

bars. Click on one of the little green

boxes in the Area section. This should

change in the Sample area. If this is the

color you want click OK.









15

This should change the bars. Excel often fills the background of a chart with grey shading

which is not very attractive and simply makes the printer work harder. The boss does not

like this so we need to change it. Click on the grey area outside the bars and right click…



Notice that this too has many sub-options. Select the

Format Plot Area option. This will display a new window

similar to the window for formatting a data series. Rather than

select another color simply change the Area option from

Automatic to None and click OK.









The chart looks great but it needs some personalization since the reader needs to know

the name of the author and the source of the data. This involves inserting text in the chart

area. You are going to need to activate the drawing tools to do this. From the Tools menu

option select Customize…



The new window will display a large selection of

Tools .. Simply activate the Drawing tool and

click on Close.









This will activate the drawing options at the bottom of the screen if they are not already

active. You are going to add some text to your graph using the Text Box option.



It is found on the lower left . Click on the box .







You have told the system to change its status and set up to place text on the chart. This

gets a little tricky so pay close attention. Move you cursor to the lower left corner of the

graph area. You are going to create the following text box as show by the outline with the

round dots at each corner. …









Click on a point slightly above the lower edge of the graph. While holding the left button

down move the cursor to the lower right along the lower edge of the chart. When you get





16

the text box where you want it let the left button go. There system will immediate place

the cursor in the box where you can type in the following information followed by the

Enter key.



Author: your name Source : Corporate web pages bh Date: today’s date



If the rectangle is not large enough simply use your cursor to grab the edges and stretch it

so it is larger REMEMBER! DO NOT OVERLAP ANY OF YOUR DATA SINCE THE

CHART IS THE MOST IMPORTANT OBJECT.



Here is a hypothetical example of what it might look like…









One of the odd things about the text box option is that if you get it wrong it appears the

system will not let you delete it. A simple trick around this is to move the entire box to a

different area of the chart and then press the DEL key on the keyboard. If the process

does not work the first time you might try this to start over.



Save your workbook … CTRL S.



Now that the chart is the way you want it, print the result. You may want to find a

computer that is connected to a color printer to make full use of your work.



Your superiors have asked that you convey the results of the analysis to them in the form

of a memo. If you recall we asked that you create a list of the expected tasks in a word

processing document in the early part of this exercise. Open the document use the

Microsoft Word software. Once you have done this you should have two software system

active. The word processing document and your workbook. Your task here is to copy the

spreadsheet contents and the graph in the memo. First draft your memo to Ms. Jane

Smith (your superior) describing the analysis and the results. There will be a point in the

memo where you wish to have the worksheet table pasted into the memo. Documents like

this can be either linked or embedded in a memo. Linked means that the spreadsheet is

copied into the memo and is dynamically linked to the spreadsheet. This means that if

you change the spreadsheet the contents of the memo will also change. Embedded means

you copy the contents of the spreadsheet into the memo and it will NOT dynamically

change if the spreadsheet changes. The obvious advantage to links is the dynamically

changing of the memo. The disadvantages is that the spreadsheet must always exist in the

same data path and name for the memo document to find it. If you email the memo to

someone and no the workbook with the spreadsheet, the memo will be corrupted.

Therefore the rule is simple .. Emailing memos or electronic copies of memos should









17

involve embedding documents. Dynamic constant updating of memos should use the link

feature.



In this case we are going to use the embedding feature. When you get to where you want

to paste the worksheet into the memo file make sure both the world document and the

spreadsheet are open. Move the Sheet 1 worksheet and click on cell A3 to select it. Then

hold the shift key down and move to cell I25. This will select the data area to be copied.

Right click and select the Copy option. Then from Edit menu click Paste Special..



Since is a Paste Special option the system will keep the spreadsheet in tact. The following

Paste Special option will appear…



Notice it is asking you what

kind of object you are pasting

into the document. Also notice

that the system is selecting the

Paste option as a default rather

than Paste Link: Select the

Microsoft Office Excel

Worksheet Object line and

click OK.







The spreadsheet area should be pasted into the memo. Notice the corners of the object

have little round highlighter marks. You can use these the resize the spreadsheet to fit in

your memo. Remember .. the challenge here is to get spreadsheet and graph embedded in

the body of the memo.



You may add more discussion of the table for the memo if you wish. The management

team likes graphs so open the Chart in your workbook. Click on the far upper left corner

of the chart so that the entire chart is highlighted by marks along the sides and in the

corners. Because the right click option activates special graphing options you need to

click on the Edit Menu option and Copy sub-option



Return to your memo and use the same Edit menu … Paste Special option and select the

Microsoft Chart Object option. Click Ok. . You will have to do some resizing of the

chart to make it fit in your memo.



Note that if you are using Microsoft Word the CTRL S option to save a file also applies

here. Save the file at this time.



Complete your memo giving your recommendations. Management will want you to

discuss in your memo the reasons for your choice. Save the document and print the

memo.









18