MS-Office Pre-Assessment Test

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 ________.

A: theme
B: font
C: number format

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