Microsoft Office Questions Practice Question and Answer

Q:

_______ is the horizontal bar at the bottom in MS Word 2010, which has various options like page number, word count etc.

352 0

  • 1
    Title bar
    Correct
    Wrong
  • 2
    status bar
    Correct
    Wrong
  • 3
    Board Bar
    Correct
    Wrong
  • 4
    Heading bar
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "status bar"
Explanation :

1. Status Bar is the horizontal bar at the bottom in MS Word 2010, which has many options like page number, word count, etc.

2. A status bar is located at the bottom of an Internet browser window or application window.

3. It displays the current status of the web page or application being displayed.

4. The status bar is the area at the bottom of the Word window that indicates information about the current document.

5. A status bar is located at the bottom of Internet browser windows and many application windows and displays the current status of the Web page or application being displayed.

Q:

In Word, when you indent a paragraph, you:

347 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:

Which option is used for formatting the contents of a cell in Ms-excel?

347 0

  • 1
    Clipboard group notap
    Correct
    Wrong
  • 2
    Font group
    Correct
    Wrong
  • 3
    Alignment group
    Correct
    Wrong
  • 4
    Text
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "Text"
Explanation :

1. In MS Excel, the text option is used for formatting the cell's content.

2. Under the formatting of text, alignment of the font in the cell, style of font, the colour of font, bold, italics, underline, fill colour, border colour, the format of numbers, format of date, format of decimal digits, wrap text ( Wrapping text), Shrink to fit, Orientation (vertically and horizontally), etc.

3. Use the following steps for formatting the text-

1. Select the cells or range that need to be formatted.

2. Select the Cell option from the Format menu on the menu bar.

3. You will get different tabs for different formats.

4. Click on the Font tab and do the formatting as required.

5. Finally click on the OK button.

Q:

To monitor all the changes in the document, M.S. What features does Word 2010 use?

344 0

  • 1
    Edit Documents
    Correct
    Wrong
  • 2
    Monitor Changes
    Correct
    Wrong
  • 3
    Track changes
    Correct
    Wrong
  • 4
    Let's play
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Track changes"
Explanation :

1. MS to monitor all changes in the document. Track Changes features are used in Word 2010.

2. Track Changes is a way for Microsoft Word to keep track of changes you make to your text.

3. Track shift is also known as redline or redline. This is because some industries have historically drawn a vertical red line in the margin to indicate that some text has changed.

Q:

What is the shortcut key to create a new slide in MS PowerPoint 2010?

336 0

  • 1
    Ctrl + M
    Correct
    Wrong
  • 2
    Ctrl + N
    Correct
    Wrong
  • 3
    Ctrl + S
    Correct
    Wrong
  • 4
    Ctrl + P
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "Ctrl + M"
Explanation :

1. F5 is used to start a presentation from the beginning.

2. We can see how your slideshow looks in full screen.

3. To start the slide show from the current slide, press Shift+F5.

4. The shortcut key to create a new slide in MS PowerPoint 2010 is Ctrl + M.

Q:

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

332 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:

Which of the following happens if the computer crashes when a restore point is set? Can we restore back?

331 0

  • 1
    Restoring Windows Registry
    Correct
    Wrong
  • 2
    Restoring system files, and installed applications.
    Correct
    Wrong
  • 3
    Restoring Windows Registry, System Files, Restoring Installed Applications Both the options are correct.
    Correct
    Wrong
  • 4
    All of the above are wrong.
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Restoring Windows Registry, System Files, Restoring Installed Applications Both the options are correct."
Explanation :

You can restore the following if your computer crashes.

1. Restoring the Windows Registry

2. Restoring installed applications

Q:

There is a table in MS Excel which contains numbers from 0 to 10. If you want to add numbers greater than 5 in that table, then which of the following formula will be suitable?

331 0

  • 1
    =SUM(A2:A8)
    Correct
    Wrong
  • 2
    =SUM(A2:A8,”
    Correct
    Wrong
  • 3
    =SUMIF(A2:A8,”>0″)
    Correct
    Wrong
  • 4
    =SUMIF(A2:A8, “
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "=SUMIF(A2:A8,”>0″)"
Explanation :

There is a table in MS Excel which contains numbers from 0 to 10. If you have to add numbers greater than 5 in that table, then the formula =SUMIF (A2:A8,”>0″) is suitable.

      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