Applications Semester 1 Exam Study Guide

WORD
1. Text Editing
a. Cut
b. Copy
c. Paste
d. Replace: search a certain word, and type what you want to replace with
e. Move: You collect text , remove, and place it in new spot
f. Save: Saves your work; allows you to open again whenever needed
g. Open: Open documents worked on from before
h. Some examples of formatting text: color, size, bold, italic, superscript
2. Where are the rulers in Word?
a. On the left and top
3. What is the first line indent?
a. Automatically indents first line of paragraph, when making new paragraph, first line indent automatically occurs for following paragraphs
4. What is a hanging indent?
a. Opposite of first line indent (keeps everything to the right, except first line)
b. Purpose for this: Bibliography, Vocabulary
5. The wavy Lines
a. Red: Misspelled Words
b. Blue : Misused Words
c. Green: Grammatical Errors
6. What does the insertion point represent?
a. Where you will insert text when typing continues
7. AutoFormat, Bulleted Lists, Numbered Lists
a. AutoFormat: Keeps on numbered list, Ex: continues the outline format (1. , 2. , Ext.)
8. Format Painter, Single and Double Click
a. Single Click: Does it once
b. Double Click: Keeps it on for continued use
9. Spacing
a. Typically, spacing on word is 1.15 NOT 1
10. Tab Stops
a. Located on upper left corner (when ruler is in use)
b. Left
c. Center
d. Right
e. Decimal

11. Drives
a. H: Home
b. X: Student Files
c. I: J: K: USB
12. Alignment
a. Center
b. Left
c. Right
d. Justified: Lined up on both left and right sides
i. Used For Legal documents, magazines, newspapers
13. 5 Different Autos
a. AutoFormat
i. Keeps up with patterns (Ex: Number lists, Bullets, Outlines)
b. AutoCorrect
i. Corrects common errors (Spelling errors, Capitalization)
c. Auto Spell Check
i. Checks for misspelled words, underlines in red
d. AutoComplete
i. Completes words commonly used such as months of year, days of week
e. Auto Grammar Check
i. Checks for grammatical errors, underlines in green
EXCEL
1. Formula Bar
a. Shows contents in selected cell
2. Default Orientation
a. Portrait
3. When beginning a formula
a. Start with equal sign
4. What are the operators?
a. Minus sign, division, addition sign, asterisk for multiplication
b. May have more than one operator
5. Is a function required for addition, subtraction, multiplication, division
a. NO
b. Use function when necessary, such as max, min,
6. For rounding, what is needed to know
a. What cell you want to round
b. How many decimal places
7. Is it true that, pie charts will represent your data the same way as scattered charts or bar charts
a. FALSE
8. Columns go up and down
9. Rows go side to side
10. When you have texts in a cell, and it is too big to be seen, what symbol shows up?
a. Pound/Number sign (#)
11. What alignment is used for excel with numbers
a. Right aligned
12. When text is wrapped in a cell, what changes?
a. The row height
13. Order of Operations is a sequence for calculating.
14. Inner most parentheses are evaluated first.
15. The sum function: =sum(F15:F19)
16. Relative Cell References - Changes as you copy.
17. Absolute Cell References – Don’t change, stay fixed.
18. Average Function: = average(B9:B17)
ACCESS
19. Database organized collection of information.
20. Definition of Primary Key
21. Definition of a Query
22. Difference between Row selector and Field selector
23. Field Name and Field Value
24. What field is automatically made when you make a new table? Answer: ID field
25. Data Types – Determines what type of data goes into that field.
a. Text
b. Number
c. Date/Time
d. Memo
26. How do you turn off a filter? Answer: Toggle Filter
27. Which window do you go to build or change a query? Answer: Query Design Window
28. Access is more powerful than excel because you can make reports for multiple tables; better grouping, sorting and summarizing capabilities.