cs12

Sunday, March 19, 2006

Word Exam Sample

For the purposes of this exam, you will create several files.

1) Start Word. Type in the following text:
Dear Sir or Madam:

I am pleased to inforem you that the following students have made the Dean's List:

Hooray for them!

Sincerely,
[Your Name Here]

Save the file as Test2.doc.

Solution:
Start/Run/Winword
Highlight the text from the webpage. Edit/Copy. Move to Word. Edit/Paste.
Change [Your Name Here] to whatever your name is.
File/Save, and specifiy Test2.doc

2) Change the font of "Sincerely" to be Courier point size 14. Italicize the word "following." Make the font color for "Hooray for them!" red and the background color of these words blue.
Solution:
To change "Sincerely," highlight that text. Then, Change the Font From Times New Roman to Courier New. In the box right next to it, change 12 to 14.
Highlight "following." Click on the I button.
Highlight "Hooray for them!" To the right side of the toolbare, there are two icons, one to change the font color and one to set a background color. Use those.

3) Run spell-check to correct any errors in the document.
Solution:
Either right-click on misspelled words and choose the correct word, or else Tools/Spelling and Grammar... and then choose Change.

4) Insert a page number for the document.
Solution:
Insert/Page Numbers.../ OK

5) Add a page header, and type in Courier Bold, Centered, the words "Office of the Dean"
Solution:
View/Header and Footer. Click the center icon. Change the font to Courier. Click the Bold icon. Type "Office of the Dean."

6) Change the top and bottom margins of the page to be .25 inches.
Solution:
File/Page Setup
Change "Top" from 1 to .25
Change "Bottom" from 1 to .25

7) Insert a Table before the sentence "Hooray for them." The table should be 6 rows and two columns. Make up the names of 5 students. Make the first row the title of the columns (Name and GPA). For the remaining 5 rows: In the first column enter the student's name and in the second column enter the student's GPA.
Solution:
Table/Insert/Table
Set Number of Rows to 6
Set Number of Columns to 2


8) Save the file again.
Solution:
File/Save

9) Save the file as Test3.doc
Solution:
File/Save As
specify Test3.doc

10) Start Excel, Create a table with three columns. The first column should be called Title, the second FirstName and the third LastName. Make up information for 5 people. Save this file as merge.xls. Close Excel.
Solution:
start/run/Excel
Click OK

Click in the top-left cell.
Type "Title" (without the quotation marks).
Move to the cell to the right and type "FirstName"
Move to the cell to the right and type "LastName"
This is not required but may make things clearer - highlight these top three cells and click on the Bold icon.

Under the Title column, make up Titles for 5 people: e.g. Mr., Mrs., Sir, Mr., Ms.
Under the FirstName column, make up First Names for 5 people: e.g. John, Joan, etc.
Under the LastName column, make up Names Names for 5 people: e.g. Smith, Jones, etc.

Save the file as merge.xls.
Close Excel


11) Switch back to Word, and display the mail merge toolbar. Open a data source and choose the excel file you just created. Select Sheet 1.
Solution:
Switch back to Word.
Right-click on some blank space in the toolbar, and make certain that there is a checkmark next to Mail Merge.
There should be two icons enabled (and the rest greyed-out). All the way to the left, the icon for "Main Document setup." Since we will be using the current document, we need not make use of that icon. Immediately to the right is the second icon, "Open Data Source." Click on this icon.
Browse to the folder that contains merge.xls and click Open.
Select Sheet 1 and click OK.


> <12) Change Dear Sir or Madam to Dear [Title] [LastName],
where
[Title] and [LastName] are merge fields.

Save the file as Test3.doc

Solution:
Now, more icons on the Mail Merge Toolbar are enabled. Immediately to the left of the words "Insert Word Field" is an icon. Hovering over that icon will display the words "Insert Merge Field." Click on the "Insert Merge Field" icon to insert a merge field.
Insert merge fields for Title and Lastname. Erase any text that does not belong there.

Save the document as Test3.doc

13) Actually perform the mail merge to a new document.
Solution:
One of the icons on the right hand side of the toolbar is "Merge to New Document." Hover over the icons to find which one and click on it.

13) Save the file as Test4.doc. Call the proctor over to collect the files.

0 Comments:

Post a Comment

<< Home