Microsoft office Practice Question and Answer

Q:

The horizontal lines displayed in the plot area of a chart in MS Excel 2010 are called.

894 0

  • 1
    Chart title
    Correct
    Wrong
  • 2
    data point
    Correct
    Wrong
  • 3
    Legend
    Correct
    Wrong
  • 4
    Gridline
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "Gridline"
Explanation :

1. The horizontal lines displayed in the plot area of a chart in MS Excel 2010 are called gridlines.

2. Types of Grid Lines in MS Excel 2010 –

- Main grid lines: These show the key values of the data ranges. They have usually displayed every 5 or 10 values.

Secondary grid lines: These show the intervals between data ranges. They usually appear after every 1 or 2 values.

Q:

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

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

What is the shortcut key to cut selected cells or range in MS Excel 2010?

404 0

  • 1
    Ctrl + C
    Correct
    Wrong
  • 2
    Ctrl + X
    Correct
    Wrong
  • 3
    Ctrl + V
    Correct
    Wrong
  • 4
    Ctrl + A
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "Ctrl + X"
Explanation :

1. To cut a cell or range in Excel: Ctrl + X can be used to cut a selected cell or range in MS Excel. This copies the data to the clipboard and clears the original cells or range.

2. To cut text: Ctrl + X can be used to cut selected text in any text editor or word processor. This copies the text to the clipboard and frees up the original space.

3. To cut an image or object: Ctrl + X can be used to cut a selected image or object in any graphics program. This copies the image or object to the clipboard and frees up the original space.

Q:

What is the use of Animation Pane in MS Power Point 2010?

625 0

  • 1
    You can check spelling and grammar
    Correct
    Wrong
  • 2
    You can see a list of animation applied to the slide
    Correct
    Wrong
  • 3
    You can print the slides
    Correct
    Wrong
  • 4
    none of these
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "You can see a list of animation applied to the slide"
Explanation :

1. Using the Animation pane in MS PowerPoint 2010 you can see a list of animations applied to the slide.

2. The Animation Pane is a tool that displays a list of animated objects on your slide.

Q:

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

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

What is the shortcut key to start a slide show from a current slide in ms PowerPoint 2010?

419 0

  • 1
    F5
    Correct
    Wrong
  • 2
    F6
    Correct
    Wrong
  • 3
    F7
    Correct
    Wrong
  • 4
    F8
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "F5"
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:

Which of the following is a feature in Microsoft Excel that is used to perform calculations on data in a spreadsheet?

454 0

  • 1
    Charts
    Correct
    Wrong
  • 2
    Filters
    Correct
    Wrong
  • 3
    Formulas
    Correct
    Wrong
  • 4
    Tables
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Formulas"
Explanation :

1. Which of the following formulas is a feature in Microsoft Excel that is used to perform calculations on data in a spreadsheet?

2. A formula is a special type of formula used to add, subtract, multiply, and divide numbers, text, and other data.

3. LANPAR, the first electronic spreadsheet on mainframe and time-sharing computers, was developed in the year 1969.

Q:

The bottom bar of MS Excel application window is called-

645 0

  • 1
    Formatting Tool Bar
    Correct
    Wrong
  • 2
    Formula Bar
    Correct
    Wrong
  • 3
    Status bar
    Correct
    Wrong
  • 4
    Title bar
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Status bar"

      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