Microsoft office Practice Question and Answer

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.

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

If you want to repeat row/column on all pages during printing in MS Excel 2010, you can use:

717 0

  • 1
    page orientation
    Correct
    Wrong
  • 2
    page size
    Correct
    Wrong
  • 3
    print titles
    Correct
    Wrong
  • 4
    Scale to fit
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "print titles"
Explanation :

1. If you want to repeat the row/column on all pages while printing in MS Excel 2010 then you can use Print Titles.

Q:

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

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

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

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

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?

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

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

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

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

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

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

      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