Computer Applications Final Exam Review Sheet – Mrs. Miñoso

The following are topics which will be found on your final exam. **Please note that not all of the topics are listed on this sheet, therefore, it would be a good idea to consult your textbook and notes.

Window’s ’98 Concepts (Chapter 2)

1. Applications Software

2. Parts of a Window

3. GUI

4. Desktop

5. Help (how to get some)

6. Network Neighborhood

7. My Computer

8. Recycling Bin

9. Icons

10. Taskbar

11. Start Button

12. Minimize, Maximize and Close Buttons

13. Resize Tab

14. Scroll Bars

15. Collapsible Lists

16. Radio Buttons

17. Check boxes

18. Default Options

19. Shut Down Command

20. CPU

21. Hardware vs. Software

22. Input vs. Output Devices

23. Multitasking

Microsoft Word (Chapters 3-6)

1. What is a word Processor?

2. Parts of the Word Screen

3. What is Word Wrap?

4. What are the different ways that we can save a document?

5. Discuss the Spell Checker and its various features. How to use it.

6. What is the difference between closing a file and exiting?

7. Be able to name all of the icons on the Tool bar.

8. What is the Show/Hide icon used for? What does it look like?

9. What is the difference between font face, size and style. Be able to list examples of each.

10. What is the difference between a superscript and a subscript? How do I create them?

11. What is meant by the word “Alignment”? What are the different types of alignment?

12. How can I double space my document?

13. If I change the margins in my document, does that affect only the page that I am working on or the entire document?

14. How can I create a Header or a Footer?

15. How can I add page numbers to my document?

16. Discuss the difference between Cut, Copy and Paste.

17. Where does information that is cut or copied go?

18. What are the control key commands for new, open, save, print, Bold, Italics, Underline, Cut, Copy, Paste?

19. What is the difference between Find and Replace? List the steps on how to find the word “Cut” in this entire document?

20. What is the Go TO Command? What is it used for?

21. How can I find a synonym for the word “alternatively”? List the steps.

22. How do I add bullets to my document? What are bullets used for? What are numbered lists used for?

23. How can I insert a Table into this document? List the steps.

24. What is a row? A column? What is the intersection of a row and column called?

Excel (Chapters 7 –9)

1. What is a spreadsheet?

2. Be able to identify the parts of the Excel Screen.

3. What is the Entry Bar? What does it look like? What is it used for?

4. What are the different types of data that can be stored in a spreadsheet?

5. What is the order of operations that excel uses in order to perform calculations?

6. What is the difference between using a formula and a function?

7. What is the fill command?

8. What is the difference between a range and a list?

9. Be able to write formulas using the Sum, Average, Minimum, Maximum, Round, IF, and PMT functions.

10. How can I change the column’s width in excel?

11. If your spreadsheet displays ######, what does that mean?

12. How can I use pointing in order to speed up the time that it takes me to type in a formula?

13. What does Ctrl + ` do?

14. What is the difference between relative and absolute copying?

15. How can I insert or delete a row in Excel?

16. What is the difference between a pie, bar and line graph?

17. How can I insert any of the above in my spreadsheet?

18. What are x-axis, y-axis, legend, and series?

19. How can I resize a graph?

20. What are “What if Questions”?

21. How can I alphabetize my spreadsheet by last name?

22. What is Freezing Panes? How do I do it? What is it used for?

23. What is an amortization table? How do I use the PMT function?

24. What are gridlines and row and column headings?

25. What is the difference between portrait and landscape orientation?

Access (Chapters 11-13)

1. What does RDBMS stand for?

2. What is the difference between a field and a record?

3. What are the different types of data that can be stored?

4. What is the difference between a Table, a Form, a Query and a Report?

5. What is the primary key?

6. What is the easiest way to enter information into your database?

7. What is a filter? What are they used for? List the steps.

8. How can I sort my table?

9. What are relationships? How do I establish relationships? Why do I establish relationships?

10. What is criteria when referring to a query?

11. What is it called when you add or correct information that has been placed into your database?

12. What is a report?

13. What are the steps used to create a report?

PowerPoint (Chapter 15)

1. What is this program used for?

2. What is a design template? Why do we use templates?

3. Discuss the differences between Slides View, Slide Sorter View, Slid Show View, and Notes Pages View.

4. How can I insert a slide? How can I delete a slide?

5. What are “Build Effects”

6. What is transition?

7. How can I add Build Effects or transitions to my presentation?

8. How can I add a Header or a Footer to my presentation?

9. Can I copy a graph created in Excel into my presentation? How?

10. What is Notes Pages View? What is it used for?

11. What are the different ways that I can print my presentation? (3 ways)

12. How can I print 6 Handouts per page? List the steps.