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.