REVIEW FOR FINAL EXAM

The Final Exam will cover the material learned after the Midterm (January 2013). 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.) and review the Blog Entry of February 4, 2013.
16. Study the Excel Review Paper Mrs. Feld will give you, and practice the exercise. There's a mistake in the Excel exercise with the term "First Quarter," since a quarter refers to three months not four; but this won't affect anything. It's basically the Total Sales for the First Four Months of the Year (January, February, March and April).

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 the PowerPoint Presentation and your test. Review the Formatting Documents Exercises done in class (from the Microsoft Office Textbook).

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 the PowerPoint Presentation and your test (review the Business Letters Exercises done in class, check the Microsoft Office Textbook).

Study the last test (Mrs. Feld will give you this test as soon as possible, one student still has to take it). There will also be a two minute timing. If you have any questions, please feel free to ask Mrs. Feld.