FINAL EXAM - REVIEW

Please review the following and study from your notes, tests, puzzles and exercises:

EXCEL:

1. What is Excel? What is a cell? What is an “active” cell? 
2. When can you use Excel? 
3. What is a formula in Excel? How do you enter a formula in Excel? Which sign should you enter first? 
4. What is a workbook? What is a worksheet? 
5. How many default worksheets are in a workbook? 
6. What is the Auto Fill Handle (or AutoFill Fill Handle or simply Fill Handle)? How do you use it?
7. Which are four automatic features in Excel? Explain all of them. Know the difference between these features. 
8. How are columns in Excel labeled? How are rows labeled?
9. How is an entire column selected? How is an entire row selected?
10. What is a  “cell reference”  or  “cell address ”? When does a cell display ###?
11. How do you use the AutoSum feature?
12. Which is the Excel Formula that adds the numbers in cells A1 through A6?
13. Which is the Excel Formula that multiplies the numbers in cells B3 and C3?
14. Which is the Excel Formula to calculate the average of the numbers in cells B3 to B8?
15. We will have an Excel Exercise. Study your Excel Test. Review Excel exercises. Practice creating charts (column, pie, line, etc.)
16. Study the Excel Review Paper Mrs. Feld gave you, and practice the exercise. 

True/False Excel Practice:

1.  A cell reference consists of a column letter only.

2.  Selected cell and active cell mean the same thing.

3.  The contents of the active cell are displayed in the Name Box.

4.  A cell’s alignment can be changed.

5.  A cell address is also called a cell reference.

6.  The “AutoComplete” Feature in Excel will automatically insert data in a cell that begins the same as a previous entry.

7.  The “AutoCorrect” Feature automatically formats your data to your liking.

8.  The “AutoFill fill handle” is the white cross (pointer) in an Excel workbook.

9.  The “AutoSum” feature in Excel allows you to add and calculate the sum of a list of numbers in your worksheet.

 10.  The multiplication symbol in an Excel formula is an “x.”

 11.  The division symbol in an Excel formula is represented by a slash (“/”).

 12.  All formulas must start with an equal sign (=).

 13.  Any expression in a formula that is enclosed within a parentheses is calculated first.

 14.  Certain formulas can be entered in Excel without entering an equal sign.

 15.  To enter "today's date" formula in Excel you enter =TODAY().

 16.  The "AutoCalculate" feature in Excel is a shortcut that allows you to view the calculation for a selected range of cells without placing a function in a cell.

FORMATTING DOCUMENTS USING MICROSOFT WORD:

1. What are Tab Stops? Mention four types of Tab Stops. Which is the most popular one?
2. What are Indents? Indent Markers? What is a Hanging Indent? First Line Indent? 
3. What are the default Tabs in Microsoft Word? 
4. How do you remove a Tab Stop from the ruler? 
5. How do you select a different Tab Stop? (Where do you go?) 
6. What are Margins? How can you change the Margins? (Mention two ways) 
7. What are Indents? How can you change the indentation of individual paragraphs in a Word document? What is a Hanging Indent? What is a First Line Indent?
8. How do you insert a Page Break in a document? (Mention two ways) 
9. How can you change the line spacing in a Word document? (Mention two ways)
10. What are bullets? When do you use them? How do you insert bullets in Microsoft Word 2010?
11. How do you insert a Header and Footer in a Word Document? When do you insert a Header and/or Footer? What is a Header? What is a Footer?
12. Study your last test on “Formatting Documents and Tabs and Indents,” and your notes.

BUSINESS LETTERS:

1. What are Business Letters? When do you use them?
2. What is a “personal” Business Letter? What is a “regular” Business Letter?
3. Mention the 10 Basic Parts of a Business Letter. Describe each of them. (You should know well what each part is)
4. What are the three styles of Business Letters? Which is the most popular one? Describe them. (Know the difference between the different styles)
5. How should you type the date in a Business Letter?
6. What is another name for the “Greeting”? It normally begins with the word …
7. The “Closing” is also called…
8. When do you add the word “Enclosure(s)” in a Business Letter?
9. Can you add “Postscripts” in a Business Letter?
10. Can you use “lined paper” when typing a Business Letter?
11. Can you use  “Fancy Fonts”?
12. Study your notes (taken from Mrs. Feld’s PowerPoint Presentation) and your test.

There will also be a two minute timing. If you have any questions, please feel free to ask Mrs. Feld.

Business Letters

BUSINESS LETTERS: By now you should have two Word Documents with the Business Letters' Exercises in the Server (in the WORD folder > in your Period folder in "Keyboardall") - "Letters" or "Business Letters" and "Tiny Tots" with your name on them. The idea was to learn how to create business letters using the three different styles (Full Block, Modified and Semi-Block). You should know and understand the difference between these styles very well (especially for our next Test - May 15, 2012).

On Thursday, May 10, you will work in groups of two (only if necessary one group can be of three students) to create your own "Complaint Letter." You can get ideas from the Tiny Tots letter exercise and online on how to create an effective "Complaint Letter." Enter a Return Address (with a made-up name, and a made-up address -get creative- you can use the names of the students from the group to come up with an interesting one) and in the Signature Line just type that same name from the return address (BUT MAKE SURE YOU PUT THE NAMES OF THE GROUP MEMBERS IN THE FOOTER so that Mrs. Feld can tell which were the members of your group for grading). Create the three different styles of letters, but print only one (the Full Block Style). Mrs. Feld should be able to find it in the Server too. Also, practice folding the letter properly, per the instructions behind the Business Letters Puzzle that Mrs. Feld gave you. The idea when you fold a letter is that the body of the letter should be centered on the middle of the page - the page will be divided in three sections (and the middle section will contain the body of the letter). Also, when you cover the middle section with the bottom section, you should be able to read the "Inside Address."

Other guidelines: you must decide to whom you're writing the letter to and what are you complaining about: is it about a product (dress, computer, camera, video camers, iPod, iPad, dress, other item of clothing, a handbag, etc.)? or is it about a service (the Prom driver was drunk, the dry-cleaned dress or suit is ruined - stained or other, the dog has a rash after the grooming service, etc.)? GET CREATIVE! It can be funny, but well-written and using the proper styles of business letters. One letter - three styles.

Save your letter as Complaint-"your last names." (YOU SHOULD KNOW WHERE!)

Please keep your voices down and be respectful and considerate of the Subs. Thanks! I'll see you Friday. Have a great time at the Soph-Hop. I'll see you there!

Reminder: Test on May 15 on Business Letters. Study your notes and the paper with the puzzle (both sides). Any questions, please feel free to ask Mrs. Feld.