Microsoft Office Questions Practice Question and Answer

Q:

You can switch the page between portrait and landscape layout in MS Word, 2010. using the following:

382 0

  • 1
    Orientation shortcut
    Correct
    Wrong
  • 2
    Margin Shortcut
    Correct
    Wrong
  • 3
    Size shortcut
    Correct
    Wrong
  • 4
    Column shortcut
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "Orientation shortcut"
Explanation :

1. You can switch pages between portrait and landscape layouts in MS Word, 2010 using the orientation shortcut.

2. The two most common types of orientation are portrait and landscape.

Q:

Match the following-

(a) Ctrl + Shift + C

(b) Ctrl + Z

(c) Ctrl + L

(d) Ctrl + H

(i) To replace             (ii) The alignment of the text

(iii) Font change       (iv) Undo

(v) Format painter   (vi) For pasting

a) b) c) d)

378 0

  • 1
    (v) (iii) (ii) (i)
    Correct
    Wrong
  • 2
    (v) (iv) (ii) (i)
    Correct
    Wrong
  • 3
    (vi) (iv) (ii) (i)
    Correct
    Wrong
  • 4
    (iii) (ii) (i) (v)
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "(vi) (iv) (ii) (i)"
Explanation :

All are matched-

(a) Ctrl + Shift + C    (vi) For pasting

(b) Ctrl + Z                 (iv) Undo

(c) Ctrl + L                 (ii) The alignment of the text

(d) Ctrl + H                (i) To replace

Q:

What is the shortcut key to insert a hyperlink in the document?

375 0

  • 1
    Ctrl + H
    Correct
    Wrong
  • 2
    Ctrl + L
    Correct
    Wrong
  • 3
    Ctrl + K
    Correct
    Wrong
  • 4
    Ctrl +B
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Ctrl + K"
Explanation :

1. Ctrl + K shortcut is used to insert hyperlink in the document.

2. The web page address, e-mail address, and any other link text or image are parts of a hyperlink.

3. To create a hyperlink field, the link label parameter can be taken from the text dimension of your data source or any expression that returns the value of text.

4. Hyperlink function works with the protocols below:

- http:

-https:

-mailto:

-ftp:

Q:

M.S. In 2010 ______ function will display the remainder after dividing a number by the divisor.

371 0

  • 1
    Round ()
    Correct
    Wrong
  • 2
    Fact ()
    Correct
    Wrong
  • 3
    MOD ()
    Correct
    Wrong
  • 4
    DIV ()
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "MOD ()"
Explanation :

The MOD() function in MS 2010 will display the remainder after dividing a number by the divisor.

Q:

Can it be kept in a cell of Microsoft Excel?

370 0

  • 1
    Number
    Correct
    Wrong
  • 2
    Text
    Correct
    Wrong
  • 3
    Formula
    Correct
    Wrong
  • 4
    All of the above
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "All of the above "
Explanation :

Can be placed in a cell of Microsoft Excel.

- Number

- Text

- Formula

Q:

Which is used to delete any file or folder in Windows permanently?

366 0

  • 1
    Shift + Delete + Enter
    Correct
    Wrong
  • 2
    Ctrl + Shift + Delete
    Correct
    Wrong
  • 3
    Shift + Delete + Space Bar
    Correct
    Wrong
  • 4
    Ctrl+ Shift + D
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "Shift + Delete + Enter"
Explanation :

1. To permanently delete any file or folder in Windows, Shift + Delete + Enter is used.

Q:

Using which keys opens the option of 'Find and Replace'?

357 0

  • 1
    Ctrl + F
    Correct
    Wrong
  • 2
    Ctrl + X
    Correct
    Wrong
  • 3
    Ctrl + R
    Correct
    Wrong
  • 4
    Ctrl + H
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "Ctrl + F"
Explanation :

1. Using Ctrl + F opens the option of ‘Find and Replace’.

2. In Word, the shortcut key Ctrl + F is used to open the Find box.

3. Ctrl + F is used to find a document.

Q:

_______ is a tool in MS Excel 2010 that works backwards for the purpose of calculating an unknown value.

354 0

  • 1
    Boolean operator
    Correct
    Wrong
  • 2
    mail merge
    Correct
    Wrong
  • 3
    Goal Seek
    Correct
    Wrong
  • 4
    bookmark
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Goal Seek"
Explanation :

1. In MS Excel 2010, "Goal Seek" is a tool that works backwards with the aim of calculating an unknown value.

2. This tool allows you to set a desired result in one cell and then adjust the values in other cells to achieve that result.

      Report Error

    Please Enter Message
    Error Reported Successfully

      Report Error

    Please Enter Message
    Error Reported Successfully

      Report Error

    Please Enter Message
    Error Reported Successfully

      Report Error

    Please Enter Message
    Error Reported Successfully

      Report Error

    Please Enter Message
    Error Reported Successfully

      Report Error

    Please Enter Message
    Error Reported Successfully

      Report Error

    Please Enter Message
    Error Reported Successfully

      Report Error

    Please Enter Message
    Error Reported Successfully