2010 1st Semester Final Exam

Study Guide

1. What is a word processor used for?  Give examples.
2. What is the insertion point?
3. What are formatting marks?  How are they used?  Where do they show up?
4. What is Undo?  Redo?
5. Why do a lot of proper nouns appear as misspelled?
6. How do you select different amounts of text in Word?  A work, a line, a paragraph, etc.
7. How can you cut, copy and paste between work docs?  Which creates a duplicate? Which moves?
8. What is definition of Font?  Is it the same as typeface?
9. What kinds of styles can be applied? Bold, Underline, Italic, superscript, subscript, etc.
10. Superscript vs. subscript?
11. How many clipboards does Office have?
12. Different views available in Print Preview?
13. Difference between left, center, right and justified alignments?  Give examples where each might be used.
14. How can you  create a hyperlink in word?  to other docs? to the web?
15. How do margins affect your document?  Larger margins vs smaller margins.
16. synonym vs antonym
17. How can you set custom tab stops?  There is more than one way.
18. Where are the default tab stops?
19. What are indents used for?
20. What happens to default stops when custom stops are added?
21. What kinds of tab leaders can be added to a tab stop?
22. How do you format one column of a table made with tab stops?
23. What is a 1st line indent, hanging indent, left and right indents?  what are all used for?
24. Numbered lists vs bulleted lists?
25. Why do we need a section break to have roman numeral page numbers and arabic page numbers in the same doc?
26. How do you get into the header/footer area?
27. What is a template?
28. How are web pages (html) viewed?
29. What are styles used for?  Know the difference between Normal, Heading 1 styles, Heading 2, etc.
30. How do you create new styles or custom styles?
31. Using the Insert Table... command, what are rows? columns? cells?
32. Can you convert between a tab stop table and a Word table?
33. Can you  enter a formula into a Word table? Give examples.
34. Sorting: Ascending vs Descending.
35. What is needed so Word can create a table of contents?
36.  Roman numerals vs Arabic numerals.
37. MLA and APA?  What  are they?
38. Define Template.  How can a template be used?
39. What is a workbook?
40. Which has letters/numbers?  Rows/columns?
41. Active cell?
42. What are the 3 types of data that can be entered?  What are they used for?
43. How do you change the width of a column or height of a row?  Can you change dimensions of individual cells?
44. What is the difference between Currency and Accounting formats?
45. Define adjacent.
46. Define formula.
47. Define function.
48. Be able to perform a calculation.  =15-5*3-2
49. #DIV/0! and ########?
50. What is Fill Handle?  How do you use it?
51. >       <       >=       <=        <>       =         4^2
52. Relative cell reference?  Also give example.
53. Absolute cell reference?  Also give example.
54. What do these functions do:  SUM?  AVERAGE? MIN?  MAX?
55. What is an argument?
56. Pointing?
57. Cell range?
58. Green triangle?
59. What is the difference between using the ROUND function and changing the formatting of the cell?
60. What can IF be used for?  How many arguments?  How can you also use text?
61. Define amortization.
62. What is PMT?
63. What is rate? Principal?
64. Worksheets vs workbook?  How many by default?
65. How can data be copied between sheets?  What are the choices for the end product?
66. Why create charts?
67. How does the chart react to changes in the source data?
68. Where can charts reside?
69. How many data series can a chart use?  All types of charts?
70. How can you move a chart on a sheet?  Resize a chart?
71. Know the difference between Embedded chart, Linked chart, and Paste as a Picture.
72. x axis? y axis? horizontal axis? vertical?
73. Legend?
74. Look at a Column chart and identify the parts.
75. Best chart type for different situations?  Pie? Bar?  Line?