Back to website Back to group fusion

Keep in mind: you can use any papers I have given you, any of your NOTEBOOK notes (but no loose written notes, no Xeroxed/copied notes that are not written in your notebook)

You may look at any of your own files, or any files in the shared directory. You can also use the HELP menu. HOWEVER, and this is a BIG HOWEVER, if you need help on every step, you will not finish the exam on time, and you WILL fail. Similarly, you need to use SHORTCUTS that you have been taught, or you WILL run out of time. The exam is designed for you to show me what you LEARNED, not what you can LOOKUP.

** These are example directions, so you have an idea what to expect. You can’t really DO them now. I am listing the EXCEL directions first, but on the day of the exam, you will be able to choose to do EXCEL first and then WORD, or you can do WORD first and then EXCEL. It’s always better to do what is EASIEST for you FIRST. You will be given a two minute warning at the end of the period. At that time you must STOP what you are doing and submit everything you saved in the EXAM1 subdirectory to GROUPFUSION. All your files must be in BOTH PLACES.

You may see one or two things on the exam I never taught you. This is on purpose, to see who really deserves the A+ instead of the A, because usually, there are a lot of A’s.

EXCEL Directions: Open Tri1Exam.xls from the SHARED directory and save it in a new directory called “EXAM1” that you created under your APPS directory

• You MUST do SHEET1.
• Choose any TWO from SHEET2, SHEET3, SHEET4. Indicate on this paper which two you chose
• Choose any ONE from SHEET5, SHEET6. Indicate on this paper which one you chose
• If you do EXTRA, it won’t be extra credit, but I will count your “Best” ones in that section. However, don’t waste time here doing extra until AFTERR you have finished the WORD section of the exam

---

On sheet 1, do the following: Blah Blah Blah

On sheet 2, do the following: Blah Blah Blah

On sheet 3, do the following: Blah Blah Blah

On sheet 4, do the following: Blah Blah Blah

On sheet 5, do the following: Blah Blah Blah

On sheet 6, do the following: Blah Blah Blah

---

---

---

WORD Directions: Open Tri1Exam.doc from the SHARED directory and save it in the same new directory called “EXAM1” that you created under your APPS directory.

Read the letter. It has 4 shaded words. I also typed them in ALL CAPS, just to make them easier to find. Begin to turn this letter into a mail merge letter by creating 4 fields to replace those shaded words. Save this customized list as EXAMDATA. Then create 3 records each with the 4 fields.**(see below)

---

Choose 2 of the following

• Merge the records, creating three letters in alphabetical order by name. Save as EXAMMERGED
• Add a conditional statement in TRI1EXAM that will print on the two letters NOT going to Mary
• Create a directory using all the fields. Add a top line of categories. Turn it into a colorful table. Save as EXAMTABLE

For the rest, go back to YOUR Tri1Exam; do NOT reopen the one in the shared directory.

You must do everything in column 1 below. Choose 3 of the things in column 2, and 1 of the things in column 3

• #1 blah blah blah #2 blah blah blah #3 blah blah blah
• #4 blah blah blah #5 blah blah blah #6 blah blah blah
• #7 blah blah blah #8 blah blah blah #9 blah blah blah
• #10 blah blah blah #11 blah blah blah #12 blah blah blah
• #13 blah blah blah #14 blah blah blah #15 blah blah blah

** For example, you might see the words MARY, $19.99, PENCIL, and FAJITA in caps and shaded pink. You would customize data using field words like NAME, PRICE, SCHOOLSUPPLY, and FOOD. Then you would make up three different people (one of whom should be MARY) with 3 different prices, 3 different school supplies and 3 different foods, that fit the context of the letter)