Microsoft office Practice Question and Answer

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:

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?

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

Q:

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

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

 ______ is a small picture that represents a program, folder or program function and is displayed in the user's user interface when it is double-clicked.

326 0

  • 1
    Taskbar
    Correct
    Wrong
  • 2
    Icons
    Correct
    Wrong
  • 3
    Command
    Correct
    Wrong
  • 4
    System tray
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "Icons"
Explanation :

1. Icons are small pictures that represent a program, folder, or program function and are displayed in the user's user interface when they are double-clicked.

Q:

______ in MM Word lets us send the same letter to different persons.

322 0

  • 1
    Mail Join
    Correct
    Wrong
  • 2
    Mail Paste
    Correct
    Wrong
  • 3
    Mail Insert
    Correct
    Wrong
  • 4
    Mail Merge
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "Mail Merge"
Explanation :

1. Mail Merge is a facility in MS Word using multiple or different letters, invitation cards, and personal letters that can be sent to many people in a minimum time.

2. This feature is more useful in a situation when a user has to deliver a letter or invitation card to thousands of people.

3. We can understand mail merge with an example. Suppose we have to send a letter or card to 1000 different people with their names and addresses, in that case, we will have to copy and paste that letter 1000 times for all those people, and then a lot of time will be wasted. A database will be created which will contain the names, addresses and other information of all the recipients. This database file is in MS Excel or MS Access.

Q:

Which of the following would you use to have the same display for all the slides in the presentation station?

280 0

  • 1
    Add Slide Option
    Correct
    Wrong
  • 2
    Outline View
    Correct
    Wrong
  • 3
    Slide Layout Option
    Correct
    Wrong
  • 4
    Presentation Design Template
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "Presentation Design Template"
Explanation :

1. A presentation design template is used to ensure a uniform display of all the slides present in the presentation.

2. A presentation design template is a ready-made theme that includes text, images, shapes, and colours. Using templates, you can create a uniform look and feel for all slides.

      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