MS-Office
Pre-Assessment Test
1. When you create a formula, you'll always
start by typing the ________ sign.
A: + (plus)
B: = (equal)
C: / (slash)
D: ^ (caret)
2. Which toolbar contains most of the commands
that you'll need in Excel 2013?
A: The Ribbon
B: The Taskbar
C: The Ruler
D: The Menu bar
3. A pre-designed workbook that you can use to
create a new project quickly is called a(n) ……
A: Cookie cutter
B: Pin
C: Template
D: Autofill
4. To continue a series of dates, you can
click and drag the ________.
A: row
B: column
C: fill handle
D: AutoDate
5. If you want to display a date in a certain
way (such as Friday, March 1, 2013), you can adjust the ________.
6. According to the order of operations, which
operation is performed first in the following equation: =D1/5+1*D3/(D3-D2)
A: D1/5
B: 5+1
C: 1*D3
D: D3-D2
7. What answer would Excel give if you typed
=3+6*2 into a cell?
A: 18
B: 12
C: 20
D: 15
8. When making an absolute cell reference,
you'll need to include at least one ________.
A: % (percent sign)
B: ! (exclamation point)
C: $ (dollar sign)
D: & (ampersand)
9. Which function would you use to add the
values of several cells?
A: SUM
B: AVERAGE
C: MIN
D: MAX
10. Freezing panes allows you to
_________________.
A: lock row(s) or column(s) in place
B: prevent others from editing your workbook
C: make an absolute reference
D: hide row(s) or column(s)
11. If you want to put your data into
alphabetical order by last name, you could use the __________ command.
A: Border
B: Sort
C: Alphabetize
D: AutoSUM
12. The Subtotal command will
automatically__________your data.
A: color code
B: group, outline and summarize
C: alphabetize
D: sort and filter
13. When reading a chart, you should refer to
the __________ to see which color is used to represent each data series.
A: legend
B: title
C: horizontal axis
D: vertical axis
14. To combine several adjacent cells into one large cell, you
will need to ________.
A: AutoFit
B: merge cells
C: insert columns
D: wrap text
15. If you wanted to filter data to exclude a certain word or
phrase, you could use a(n)____________.
A: Advanced date filter
B: Advanced number filter
C: Super filter
D: Advanced text filter
16. What does #### mean? (Pick one
answer.)
A.
The column is not wide enough to display the
content of the cell.
B.
The cell reference is not valid.
C.
You have misspelled a function name or used a
name that Excel doesn’t recognize.
17. If you've misspelled a company's name many times throughout a
document, what is the quickest way to fix all of the mistakes?
A. AutoRecover
B. Find and Replace
C. Cut and Paste
D. Drag and Drop
18. What is the default font in Word 2013?
A. Arial
B. Calibri
C. Times New Roman
D. Verdana
19. Which keyboard shortcut takes you to the Print pane?
A. Shift+P
B. Ctrl+Print scrn
C. Alt+P
D. Ctrl+P
20. If your text is single-spaced and you'd like to double-space
it, which line spacing option should you use?
A. 1.0
B. 1.5
C. 2.0
D. 2.5
21. You can customize the look of bullets in a list with all of
the following, EXCEPT:
A. Colors
B. Charts
C. Pictures
D. Symbols
22. True or False: In a hyperlink, the address and the display
text must be the same.
A. True
B. False
23. If you need to edit a header, you can open it by ________.
A. Double-clicking the header
B. Hovering the mouse over the header and then pressing Enter
C. Pressing Ctrl+H
D. Inserting a Page break
24. You can move a picture freely around in your document after
you've modified the ________ setting.
A. Corrections
B. Text Wrapping
C. Artistic Effects
D. None of the above
25. In a table, if you want to modify a cell's text alignment, the
alignment options are located on the ________ tab.
A. Page Layout
B. Insert
C. Design
D. Layout
26. The ________ wavy line indicates a spelling error.
A. Red
B. Blue
C. Black
D. Purple
27. When using Track Changes, any text you delete will be
________.
A. Removed
B. Bolded
C. Underlined
D. Crossed out
28. You can use ________ to remove personal information from a
document.
A. Spell Check
B. Mark as final
C. Themes
D. The Document Inspector
29. A(n) ________ is a pre-defined combination of font, color, and
size that can be applied to any text in your document.
A. Artistic effect
B. Style
C. Template
D. Accent
30. A (n) ________ is a set of colors, fonts, and effects that
determine the overall look of your document.
A. Style
B. Theme
C. Accent
D. Quick Style
31. Mail Merge allows you to ________.
A. Merge two letters together
B. Calculate postage price
C. Produce multiple letters using information stored in a spreadsheet
D. Learn step-by-step how to write an email
32. You can insert text into _______ and text boxes.
A. data fields
B. forms
C. placeholders
D. none of the above
33. The _________ view is where you create and edit your slides.
A. Slide Show
B. Slide Sorter
C. Notes Page
D. Normal
34. True or False: You can apply an effect to WordArt, but not to
a shape.
A. True
B. False
35. When you insert a table, PowerPoint automatically applies a
________ to the table that blends with the color scheme of the theme.
A. WordArt Style
B. Table Style
C. Grid
D. none of the above
36. A PowerPoint chart is updated automatically whenever the
_____________ changes.
A. Legend
B. Chart Title
C. Excel source data
D. none of the above
37. Click _________ in the Animations group to open the Custom
Animation task pane.
A. Add Effect
B. Custom Animation
C. Insert Animation
D. none of the above
38. The ________stores information about the theme and allows you
to easily make changes to all slides or a specific slide layout.
A. Design Template
B. Master Theme
C. Theme Style
D. Slide Master
39. You must _______ the object or objects before you can align,
group, rotate, or order them.
A. Expand
B. Arrange
C. Select
D. none of the above
40. A __________ is the movement you see when one slide changes to
another in slide show view.
A. Style
B. Dissolve
C. Bevel Effect
D. Transition Effect
Author
Md Nizamul Islam
MBA (London), MOC Specialist
