Microsoft Excel  Test 1
Getting Started with Excel, Setting up your Workbook, Working with Files. Test + Exercise worth 2 Points	Back to The Lesson   Go to the next lesson Go To: Computer Class Syllabus
Occasionally, there may be a hint in the question.  It may be a hyperlink that looks like this.   Hint: Right-Click a link and then click "Open in New Window" (as in this image )   In a Word Document, hold down the CTRL key then click the link.
Directions: You need to have already read through the lesson in order to pass this test.     Answer the questions that can be found below... THEN complete the exercise that can be found after that.	Remember: You must pass with 80% Don't forget that you can use  the Microsoft Help feature!

 

ALWAYS SAVE YOUR WORK !

 

 Spell Check!  Proof read!  Typing errors are unacceptable!

 

Answer in complete sentences!!!   (unless a word or two really will do)

1. Copy these questions (between the lines below),

2. Paste into MS Word,  [Click to see how.]

3. type your answers In Bold or Italics,

4. USE the SPELLCHECKER AND GRAMMAR CHECKER,

5. and then SAVE TO YOUR "U" DRIVE FOLDER or any other storage media that will assure it is safe!
   - At school or at home, print this and turn it in for grading.

If you are not at school and need to turn this in right away, email it to me: [carlsjr@d11.org] as an attachment, OR if you are not able to email a Word document to me (I cannot read a Works document) print this Word document and bring it to class.

---

Excel Test 1     (1 Point)

          Name__________________________Date_______

 

1.       What is an Excel file called? (Word has "Documents")

 

Match the following (#s 2-7) with the correct counterpart in the next column...(Click in the box, type the #)
(see Excel Window & Windows Components) :

2.     Active Cell 3.     Sheet tabs 4.     Worksheets 5.     Formula Toolbar 6.     Rows 7.     Columns

A. Clicking on these will open up worksheets in turn.   B. Horizontally aligned cells designated by numbers.   C. Displays formulas or text that is in a selected cell.   D. A selected cell.   E. Vertically aligned cells designated by letters.   F. Separate screens contained in a workbook.

8.        What 3 primary components does a worksheet have?

 

9.        What 3 toolbars will you use most often in Excel?

 

10.      What are templates, and where can you find them?

 

11.      How do you select a cell in your worksheet?

 

12.     On a large worksheet, how can you quickly find particular text or numbers?

 

 

---

 

Exercise:

1. You should have an Excel workbook open.

2. Save as Excel_1-1your initials here.

   1. Save to your "U" drive as previously instructed.

3. You may wish to refer to the VIOLET instruction sheet, if available for this assignment, found in the classroom file. 
    Follow any other instructions and refer to it for examples.

4. Ask for help!

 

REMEMBER

• Refer to the tutorials for help.

• Consult the Office Assistant (Help) for information.

• Have the teacher check this exercise when you are done so that you can receive your points.
  - Remember, you also have to complete the questions above.

• You may have to look back at preceding assignments on the tutorial page which you  have not been assigned in order to complete an exercise.

 

Procedure...

1. Open a workbook if you haven't already.

2. Type what you see below, in the exact cells as shown.

3. For this exercise, you don't need to format anything fancy, but do make column A wide enough.

4. Re: the months in row 3...

   • HINT: Check AutoFill in the next lesson.

5. Make your worksheet look like this:
   
   
    

6. Remember, Save the worksheet as Excel_1-1 initials . The second 1 can be changed to a 2, etc., should you need to do this over and wish to create a new file but save the old one. This is a good policy for Backing Up Data, to avoid creating extra work for yourself.

 

 

SAVE THIS FILE!

 

When you are finished with this assignment you should ask your teacher to grade the questions that you submitted from the table.  Then you need to follow any other directions particular to this assignment.  The demonstration answers should be done at your computer. 

Several people may need help at the same time, so:
start work on another assignment while waiting for help.

 

AND don't forget to speak up to ASK for help.

 

When you think you are done:

While you are waiting for this assignment to be graded,