Microsoft office Practice Question and Answer

Q:

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

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

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

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

Match the following-

(a) Ctrl + Shift + C

(b) Ctrl + Z

(c) Ctrl + L

(d) Ctrl + H

(i) To replace             (ii) The alignment of the text

(iii) Font change       (iv) Undo

(v) Format painter   (vi) For pasting

a) b) c) d)

1246 0

  • 1
    (v) (iii) (ii) (i)
    Correct
    Wrong
  • 2
    (v) (iv) (ii) (i)
    Correct
    Wrong
  • 3
    (vi) (iv) (ii) (i)
    Correct
    Wrong
  • 4
    (iii) (ii) (i) (v)
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "(vi) (iv) (ii) (i)"
Explanation :

All are matched-

(a) Ctrl + Shift + C    (vi) For pasting

(b) Ctrl + Z                 (iv) Undo

(c) Ctrl + L                 (ii) The alignment of the text

(d) Ctrl + H                (i) To replace

Q:

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

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

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?

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

Animation like effect when you M.S. Moving from slide to slide during a slide show in PowerPoint 2010.

1219 0

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

Answer : 3. "slide transition"
Explanation :

1. Animation like effect when you use MS. Transition from one slide to another during a slide show in PowerPoint 2010.

2. First of all, select the slides in which the transition effect is to be added.

3. Click on the Slide Transition option in the Slide Show menu available in the menu bar, which opens the Slide Transition dialogue box.

5. The desired speed of the transition effect is set using the Slow, Medium or Fast option button.

Q:

Which command is used to open the word pad?

1213 0

  • 1
    Win key + r
    Correct
    Wrong
  • 2
    Winkey + p
    Correct
    Wrong
  • 3
    Winkey + w
    Correct
    Wrong
  • 4
    None of these
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "None of these"
Explanation :

1. WordPad is a word processor software included with Windows 95 and later, up to Windows 11.

2. WordPad does not have to be installed in the system.

3. WordPad comes inbuilt installed with the Windows operating system.

Q:

What is the shortcut key for starting a slide show from the beginning in MS PowerPoint?

1206 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. The shortcut key to start the slide show from the beginning in MS PowerPoint is F5. Pressing this key will start the presentation and slide show starting from the first slide.

2. If you want to start the slideshow from the current slide, you can use the Shift+F5 key combination. Pressing this key will start the presentation and start the slide show from the current slide.

      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