Name: 
 

Info Pro 1 Final Exam Study Guide



Matching
 
 
Excel
a.
Cell
g.
Formula Bar
b.
Cell Reference
h.
Function
c.
Edit
i.
Chart and Graph
d.
Fill handle
j.
Gridlines
e.
Format
k.
Range
f.
Formula
l.
Value
 

 1. 

Create this to turn worksheet data into a picture, where you can make a comparison or trend visible at a glance
 

 2. 

A number entered on the worksheet.
 

 3. 

The intersection of a column and row on a worksheet
 

 4. 

You do this to change the contents of a cell.
 

 5. 

The identification of a cell in a worksheet by the column letter and row number.
 

 6. 

A group of cells in an area of a worksheet identified by the starting and ending cell reference.
 

 7. 

Solid lines that mark off the rows and columns in  speadsheet.
 

 8. 

The small square located in the lower-right corner of the active cell used to copy formulas or continue a pattern.
 

 9. 

An instruction Excel uses to calculate a number.
 

 10. 

Use this command to change the appearance of cell data.
 

 11. 

A built-in formula that preforms calculations of special operations.
 

 12. 

Displays the data in the active cell.
 
 


WORD
a.
Alignment
g.
Show/Hide
b.
Drag and Drop
h.
Spell Check
c.
Footer
i.
Tab
d.
Format
j.
Table
e.
Indent
k.
Text box
f.
Justify
l.
Merge fields
 

 13. 

The command to change the appearance of a document, including font, color, margins, borders and shading.
 

 14. 

Position of text at the left, center, right, or justified.
 

 15. 

Using the mouse to move a selection without adding the selection to the clipboard .
 

 16. 

Text or graphic that prints in the bottom margin of each page in a document
 

 17. 

The distance between the beginning of a line of text and the page margins
 

 18. 

A form of paragraph alignment in which both the left and right edges of a paragraph are flush with the margins
 

 19. 

Controls the display of special characters such as tab characters or paragraph marks
 

 20. 

Software tool that indicates misspelled words and grammar errors
 

 21. 

A setting that positions text at a specific horizontal position in a document. This can be left, center, right, or decimal types to name a few.
 

 22. 

A tool that organizes text and data into rows and columns.
 

 23. 

Containers that allow you to format and position selected text and/or graphics separately from the rest of the document.
 

 24. 

In the main document, tells Word where to print information from the data source during Mail Merge.
 
 


PowerPoint
a.
Animate
d.
Sizing handle
b.
Design template
e.
Slide Sorter View
c.
Placeholder
f.
Transition
 

 25. 

Any of eight small black boxes located on a placeholder’s border, used to resize the placeholder.
 

 26. 

A preformatted slide design that contains colors and graphics to make your presentation consistent and attractive.
 

 27. 

The method by which one slide moves off the screen and another moves on the screen.
 

 28. 

A method of viewing multiple slides in the presentation at one time so you can easily move them.
 

 29. 

To apply movement to text or an object. For example, text might fly onto the screen form the left or drop in from above.
 

 30. 

An empty box that contains preset text formats to make entering text easier.
 



 
Check Your Work     Reset Help