WorksheetsMicrosoft Office Final Exam
Total questions: 100
Worksheet time: 50mins
Name
Class
Date
1.
1. Records anything that has been changed in a document by an editor
a)
Text Effects
b)
Status Bar
c)
Page Break
d)
Track Changes
2.
2. Change the size of
a)
Select
b)
Column
c)
Resize
d)
Crop
3.
3. Displays your presentation in a large window on your computer screen
a)
Page break view
b)
Reading view
c)
Slideshow
d)
Outline view
4.
4. Located at the bottom of the PowerPoint window, shows messages about what you are doing and seeing in PowerPoint
a)
Status bar
b)
Insert function
c)
Quick access toolbar
d)
Formula bar
5.
5. Highlight an entire column
a)
Select Column
b)
Select Row
c)
Footer
d)
Cell
6.
6. Used to manually end a page and begin a new one.
a)
Page break
b)
Outline view
c)
Track changes
d)
Hanging indent
7.
7. Professional quality diagram that visually illustrates text
a)
Filter
b)
Chart
c)
WordArt
d)
SmartArt
8.
8. Drops letter down
a)
Footnote
b)
Landscape
c)
Footer
d)
Subscript
9.
9. A column letter above the grid that identifies each column
a)
Line spacing
b)
Row heading
c)
Column heading
d)
Cell reference
10.
10. Displays an outline of the presentation and the slide pane at the same time
a)
Normal view
b)
Reading view
c)
Outline view
d)
Slide sorter view
11.
11. The horizontal or vertical position of text on a page or within a table
a)
Orientation
b)
Alignment
c)
Line Spacing
d)
Hanging Indent
12.
12. Where cut or copied text/images are placed until they are pasted somewhere
a)
Clipboard
b)
Formatting
c)
Alignment
d)
Select
13.
13. Used when changing a file name or its location
a)
Save as
b)
Zoom slider
c)
Theme fonts
d)
Active cell
14.
14. Removing unwanted parts of an image
a)
Select
b)
Crop
c)
Resize
d)
Landscape
15.
15. Print orientation where text prints along the width of the paper. It is taller than it is wide
a)
Alignment
b)
Portrait
c)
Justified
d)
Landscape
16.
16. On the status bar, allows you to open the Comments pane
a)
Word wrap
b)
Footer
c)
Comments button
d)
Show/hide
17.
17. Boxes with letters along top of worksheet
a)
Text color
b)
Column headings
c)
Row headings
d)
Formula bar
18.
18. Statements in a formula that can be evaluated as true or false, and then return an appropriate value if true, and another value if false.
a)
Formatting
b)
Clipboard
c)
Cell format
d)
Conditions
19.
19. To arrange data in alphabetical or numerical order.
a)
Filter
b)
Sort
c)
Cell
d)
Row
20.
20. y axis/vertical axis
a)
X-axis
b)
Value axis
c)
Column
d)
Category axis
21.
21. A graphic representation of values used to identify trends and contrasts in data
a)
Diagram
b)
SmartArt
c)
Sort
d)
Chart
22.
22. The position in which text is placed within a cell
a)
Cell margins
b)
Cell alignment
c)
Cell value
d)
Cell reference
23.
23. The tool used to remove the space that Word automatically adds when you hit enter and allow you better control of your line spacing
a)
Format Painter
b)
Word Processing
c)
Add/Remove Space Before/After Paragraph
d)
Find And Replace
24.
24. Placing a new, blank row or column in the spreadsheet.
a)
Active cell
b)
Sheet tab control
c)
Insert row/column
d)
Cell reference
25.
25. A number at the far-left side of a row that can be clicked to select the entire row of cells
a)
Column heading
b)
Insertion point
c)
Row heading
d)
Formula bar
26.
26. Appears vertically in a worksheet and is identified by letters at the top of the worksheet window
a)
Column
b)
Row
c)
Cell
d)
AutoSum
27.
27. Selected cell with a thick green border around it
a)
Cell alignment
b)
Formula bar
c)
Cell reference
d)
Active cell
28.
28. Any of the bars across the top of Word, where we find all of our tabs, groups, and commands
a)
Status Bar
b)
Header
c)
Tab
d)
Ribbon
29.
29. Occurs when you get to the end of a line and as you continue typing the text automatically moves to the next line
a)
Wrap Text
b)
Word Wrap
c)
Word Processing
d)
Embedded Object
30.
30. A pale or semitransparent graphics object positioned behind text in a document.
a)
Watermark
b)
WordArt
c)
SmartArt
d)
Clipboard
31.
31. Highlight an entire row
a)
Fill Color
b)
Select Column
c)
End Of Row
d)
Select Row
32.
32. x axis/horizontal axis
a)
Category axis
b)
Legend
c)
Value axis
d)
X-axis
33.
33. A set of decorative text styles or text effects that you can apply to and text object
a)
WordArt
b)
Formatting
c)
Chart
d)
SmartArt
34.
34. Button that will reveal your non-printing characters on your screen (tabs, spaces, enters)
a)
Show/Hide
b)
Line Spacing
c)
Display/cover
d)
Visible/hide
35.
35. Contains basic text formatting commands such as bold, italics, and appears when you select text
a)
Status bar
b)
Quick access toolbar
c)
Slide pane
d)
Mini toolbar
36.
36. Part of the presentation except that the object's data source can be opened for editing purposes
a)
Source object
b)
Isolated object
c)
Embedded object
d)
Linked object
37.
37. An explanation or reference to additional material that prints at the end of a document.
a)
Endnote
b)
Footnote
c)
Caption
d)
Footer
38.
38. Print orientation where text prints along the length of the paper. It is wider than it is tall
a)
WordArt
b)
Portrait
c)
Alignment
d)
Landscape
39.
39. A toolbar button that displays functions by category that will assist you in writing the formula
a)
Parking Function
b)
Insert Row/column
c)
Insert Function
d)
Hold Function
40.
40. Displays the location of the different page breaks within the worksheet
a)
Reading View
b)
Split
c)
Slide Pane
d)
Page Break Preview
41.
41. Combines multiple shapes together
a)
Combining
b)
Merging
c)
Mixing
d)
Splitting
42.
42. An excel file with one or more worksheets
a)
Column
b)
Worksheet
c)
Workbook
d)
Autosum
43.
43. Raises letter up
a)
Superscript
b)
Footnote
c)
Footer
d)
Formatting
44.
44. A visual representation of data to help readers better understand relationships among data
a)
WordArt
b)
Chart
c)
Diagram
d)
Caption
45.
45. Allows you to type information above the top margin of each page of a document, often repeats on every page and includes titles, dates, or names.
a)
Header
b)
Footer
c)
Ribbon
d)
Footnote
46.
46. The workspace made up of columns and rows where you enter data to create an electronic spreadsheet
a)
Alignment
b)
Workbook
c)
Column
d)
Worksheet
47.
47. Allows you to type information below the bottom margin of each page of a document, often repeats on every page and includes page numbers
a)
Header
b)
Footer
c)
Footnote
d)
Endnote
48.
48. Each column and row of data
a)
Cell reference
b)
Formula bar
c)
Data series
d)
Chart
49.
49. Appears horizontally in a worksheet and is identified by numbers on the left side of the worksheet window
a)
Sort
b)
Cell
c)
Row
d)
Column
50.
50. When a word is on a line all by itself. Or a paragraph line is on the top or bottom of a page all by itself.
a)
Page Break
b)
Widow/Orphan
c)
Hanging Indent
d)
Word Wrap
51.
51. Appears directly below the toolbar in the worksheet; displays a formula when the cell of a worksheet contains a calculated value.
a)
Status Bar
b)
Thumbnails Pane
c)
Formula Bar
d)
Active Cell
52.
52. Blinking vertical line, indicates where your text appears
a)
Line spacing
b)
Word processing
c)
Tab
d)
Insertion point
53.
53. A condition that data must meet to be included in a selection - a way of limiting data in a list
a)
Ribbon
b)
Filter
c)
Footer
d)
Column
54.
54. The distance between lines of text
a)
Fill Color
b)
Line Spacing
c)
Alignment
d)
Insertion Point
55.
55. Button that will allow you to apply the same formatting features to several different sets of words
a)
Text Effects
b)
Format Painter
c)
Wrap Text
d)
Theme Fonts
56.
56. A numbered label, such as "Figure 1", that you can add to a figure, a table, an equation, or another object.
a)
Diagram
b)
Footer
c)
Caption
d)
Watermark
57.
57. Takes two or more cells and combines them into one.
a)
Split cells
b)
Merge (tables)
c)
Active cell
d)
Merge cells
58.
58. Boxes with numbers along left side of a worksheet
a)
Row headings
b)
Active cell
c)
Column headings
d)
Footnote
59.
59. Color that the text appears in a cell
a)
Text height
b)
Fill color
c)
Text location
d)
Text color
60.
60. The tool used to add shadows, outlines, reflections, and glows to your text.
a)
Wrap Text
b)
Theme Fonts
c)
Format Painter
d)
Text Effects
61.
61. Highlighted worksheet cell that is ready for data entry
a)
Cell Reference
b)
Active Cell
c)
Cell Alignment
d)
Formula Bar
62.
62. The column letter and the row number. Example: B12
a)
Active Cell
b)
Formula Bar
c)
Cell Reference
d)
Cell Value
63.
63. A function that automatically adds selected cells
- can sum a large range of data by simply selecting a tool button
a)
Autorun
b)
Column
c)
Workbook
d)
AutoSum
64.
64. Used to zoom the slide in and out quickly
a)
Slide thumbnails
b)
Status bar
c)
Zoom slider
d)
Slide layout
65.
65. Allows someone to change a cell's appearance; alignment, font, border, patterns, etc. as well as its numerical type; number, text, currency, percentage, etc.
a)
Security format
b)
Cell reference
c)
Cell format
d)
Cell style
66.
66. Displays the current slide in your presentation
a)
Slide Pane
b)
Slide Layout
c)
Slide Thumbnails
d)
Slide Show
67.
67. Allows you to quickly navigate through the slides in your presentation
a)
Reading Pane
b)
Thumbnails Pane
c)
Slide Pane
d)
Normal Pane
68.
68. To choose or highlight a row, column, cell or range
a)
Select
b)
Header
c)
Resize
d)
Chart
69.
69. The creation, input, editing, and formatting of documents and other text using software.
a)
Word Processing
b)
Text Effects
c)
Format Painter
d)
Insertion Point
70.
70. Combines two cells together
a)
Line spacing
b)
Split
c)
Merge (tables)
d)
Ascending sort
71.
71. A line that indicates a boundary of a cell or range
a)
Column
b)
Border
c)
Footer
d)
Filter
72.
72. The background of the cell
a)
Fill color
b)
Text color
c)
Cell value
d)
Outline view
73.
73. Changing text, layout, and design of a document
a)
Worksheet
b)
Merging
c)
Formatting
d)
WordArt
74.
74. Sorting from Z-A
a)
Merge (tables)
b)
Superscript
c)
Descending sort
d)
Hanging indent
75.
75. A note at the bottom of the page used to cite references or give more information.
a)
Footnote
b)
Caption
c)
Footer
d)
Endnote
76.
76. Hide a portion of a picture
a)
Cropping
b)
Scaling
c)
Formatting
d)
Masking
77.
77. A computer program you use to organize and present info to others
a)
Proof Devices
b)
Slide Layout
c)
Presentation Software
d)
Spreadsheet Software
78.
78. Displays the slides of your presentation as small images
a)
Slide thumbnails
b)
Slide show
c)
Slide pane
d)
View buttons
79.
79. Describes the direction of the page or the paper you will print on (landscape or portrait)
a)
Formatting
b)
Alignment
c)
Wordart
d)
Orientation
80.
80. To closely read text, examining it for errors in conventions, mechanics, spelling, and/or grammar
a)
Footnote
b)
Print
c)
Justified
d)
Proofread
81.
81. Provides access to common commands such as save, undo, redo, and start from beginning
a)
Mini Toolbar
b)
Formula Bar
c)
Status Bar
d)
Quick Access Toolbar
82.
82. A set of fonts for titles and other text
a)
Text effects
b)
Theme colors
c)
Theme fonts
d)
Text color
83.
83. Cell reference that points to a specific cell and does not change when copied ($B$4)
a)
Mixed Reference
b)
Relative Reference
c)
Cell Reference
d)
Absolute Reference
84.
84. Parameters added to a function that help in evaluating data, or performing calculations
a)
Arguments
b)
Worksheet
c)
Orientation
d)
Variables
85.
85. First line of a paragraph is NOT indented, all other lines are indented
a)
Page Break
b)
Hanging Indent
c)
Format Painter
d)
Left Indent
86.
86. Allows the user to select specific rows or columns that remain visible when scrolling in the worksheet
a)
Wrap Text
b)
Formula Bar
c)
Freeze Panes
d)
Split
87.
87. The way text is arranged in relation to a picture or image in a document
a)
Fill Color
b)
Merge Cells
c)
Freeze Panes
d)
Wrap Text
88.
88. Displays information about the current document
a)
Track Changes
b)
Formula Bar
c)
Quick Access Toolbar
d)
Status Bar
89.
89. Describes the data in a series
a)
Sort
b)
Column
c)
Chart
d)
Legend
90.
90. Evenly spaced horizontal and vertical lines to align objects
a)
Ribbon
b)
Header
c)
Gridlines
d)
Footer
91.
91. Contains text and object placeholders that are arranged in a specific way on the slide
a)
Zoom slider
b)
Slide layout
c)
Slide pane
d)
Slide show
92.
92. Sorting from A-Z
a)
Merge (tables)
b)
Hanging indent
c)
Superscript
d)
Ascending sort
93.
93. Displays your presentation on the whole computer screen
a)
Slide sorter
b)
Slide show
c)
Slide pane
d)
Slide layout
94.
94. Feature that locates specific text and then replaces it with desired text. Can be used to change the formatting of text also.
a)
Track Changes
b)
Tab
c)
Sort
d)
Find and Replace
95.
95. Used to indent a line of text; can be used to set up columns and lists in a document
a)
Find And Replace
b)
Tab
c)
Ribbon
d)
Cell
96.
96. The intersection of a row and a column
a)
Row
b)
Column
c)
Cell
d)
Worksheet
97.
97. Separates one cell into two
a)
Split
b)
Merge (tables)
c)
Filter
d)
Freeze Panes
98.
98. Alignment where text is on both the left and the right margins
a)
Clipboard
b)
Portrait
c)
Alignment
d)
Justified
99.
99. What is typed into a cell, contained within
a)
Cell alignment
b)
Cell reference
c)
Active cell
d)
Cell value
100.
100. First line of a paragraph IS indented, all other lines are not indented
a)
Line Spacing
b)
Text Effects
c)
First Line Indent
d)
Right Indent
100 %
