Microsoft office Practice Question and Answer

Q:

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

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

Q:

In MS Excel 2010, the address from the top left and bottom is:

338 0

  • 1
    A1
    Correct
    Wrong
  • 2
    www.ymou.ac.in
    Correct
    Wrong
  • 3
    AZ
    Correct
    Wrong
  • 4
    1A
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "A1"
Explanation :

1. In MS Excel 2010, the address of the topmost cell is Al.

2. Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X.

3. Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data, and integrating information from different programs.

Q:

Match the following:
 (I) MS Word 2010                (P) Slides
 (II) MS Excel 2010.              (Q) Sheet
 (III) MS PowerPoint 2010   (R) document
 Choose the correct match from the following:

2571 0

  • 1
    (I)–(R), (II)–(P), (III)–(Q)
    Correct
    Wrong
  • 2
    (I)–(P), (II)–(R). (III)–(Q)
    Correct
    Wrong
  • 3
    (I)–(R), (II)–(Q), (III)–(P)
    Correct
    Wrong
  • 4
    (I)–(R), (II)–(P), (III)–(Q)
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "(I)–(R), (II)–(Q), (III)–(P)"
Explanation :

All matches are correct-

(I) MS Word 2010                – Documents

(II) MS Excel 2010.              - Sheet

(III) MS PowerPoint 2010    – Slides

Q:

What is the correct example of a cell address in MS Excel 2010?

1102 0

  • 1
    114 AZ
    Correct
    Wrong
  • 2
    AZ145
    Correct
    Wrong
  • 3
    A12AZ
    Correct
    Wrong
  • 4
    11AZ12
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "AZ145"
Explanation :

The correct example of cell address in MS Excel 2010 is AZ145.

Q:

_______ are animation-like effects that occur when you move from one slide to another during an MS PowerPoint 2010 slide show.

589 0

  • 1
    Control effect
    Correct
    Wrong
  • 2
    Bar graph
    Correct
    Wrong
  • 3
    Leide transition
    Correct
    Wrong
  • 4
    Slide background
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Leide transition"
Explanation :

1. Slide transitions are animation-like effects that occur when you move from one slide to another during an MSPowerPoint 2010 slide show.

2. Slide transitions apply whole-slide and can be used to make slide shows more vibrant and attractive.

Q:

Which application software enables you to create efficient slide show presentation stations?

387 0

  • 1
    MS Excel
    Correct
    Wrong
  • 2
    MS Outlook
    Correct
    Wrong
  • 3
    MS PowerPoint
    Correct
    Wrong
  • 4
    MS Paint
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "MS PowerPoint"
Explanation :

1. Microsoft PowerPoint: This is the most popular slide show presentation software. It is easy to use and has many features that allow you to create engaging and informative slideshows.

2. Google Slides: It is a free online slideshow presentation software. It offers similar features to PowerPoint and can be used in any web browser.

3. LibreOffice Presentation: It is a free and open-source slideshow presentation software. It offers features similar to PowerPoint and Slides.

4. Adobe Presentation: It is a professional slide show presentation software. It has more advanced features than PowerPoint and Slides.

Q:

In Word, when you indent a paragraph, you:

351 0

  • 1
    Moves the text up one line.
    Correct
    Wrong
  • 2
    Change the margin on the page.
    Correct
    Wrong
  • 3
    Advances the text with respect to the margin.
    Correct
    Wrong
  • 4
    Moves the text down one line.
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Advances the text with respect to the margin."
Explanation :

1. In Word, when you indent a paragraph, you move the text relative to the margin.

2. Move all or some characters of the paragraph to a certain distance from the left or right margin.

Q:

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

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

      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