Microsoft office Practice Question and Answer

Q:

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

665 0

  • 1
    Clipboard group notap
    Correct
    Wrong
  • 2
    Font group
    Correct
    Wrong
  • 3
    Alignment group
    Correct
    Wrong
  • 4
    Text
    Correct
    Wrong
  • Show 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:

Which is used to delete any file or folder in Windows permanently?

657 0

  • 1
    Shift + Delete + Enter
    Correct
    Wrong
  • 2
    Ctrl + Shift + Delete
    Correct
    Wrong
  • 3
    Shift + Delete + Space Bar
    Correct
    Wrong
  • 4
    Ctrl+ Shift + D
    Correct
    Wrong
  • Show Answer
  • Workspace

Answer : 1. "Shift + Delete + Enter"
Explanation :

1. To permanently delete any file or folder in Windows, Shift + Delete + Enter is used.

Q:

What is the shortcut key for redo of last undo action in MS Word 2010?

655 0

  • 1
    Ctrl + Z
    Correct
    Wrong
  • 2
    Curl + Y
    Correct
    Wrong
  • 3
    Ctrl + P
    Correct
    Wrong
  • 4
    Ctrl + E
    Correct
    Wrong
  • Show Answer
  • Workspace

Answer : 2. "Curl + Y"
Explanation :

1. The shortcut key to redo the last undo action in MS Word 2010 is Curl + Y.

2. This shortcut key can be used to redo any undo action, such as deleting text, copying text, or formatting text.

3. For example, if you deleted some text, you can return it again by pressing Ctrl + Y.

Q:

Can it be kept in a cell of Microsoft Excel?

654 0

  • 1
    Number
    Correct
    Wrong
  • 2
    Text
    Correct
    Wrong
  • 3
    Formula
    Correct
    Wrong
  • 4
    All of the above
    Correct
    Wrong
  • Show Answer
  • Workspace

Answer : 4. "All of the above "
Explanation :

Can be placed in a cell of Microsoft Excel.

- Number

- Text

- Formula

Q:

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

633 0

  • 1
    MS Excel
    Correct
    Wrong
  • 2
    MS Outlook
    Correct
    Wrong
  • 3
    MS PowerPoint
    Correct
    Wrong
  • 4
    MS Paint
    Correct
    Wrong
  • Show 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:

Using which keys opens the option of 'Find and Replace'?

633 0

  • 1
    Ctrl + F
    Correct
    Wrong
  • 2
    Ctrl + X
    Correct
    Wrong
  • 3
    Ctrl + R
    Correct
    Wrong
  • 4
    Ctrl + H
    Correct
    Wrong
  • Show Answer
  • Workspace

Answer : 1. "Ctrl + F"
Explanation :

1. Using Ctrl + F opens the option of ‘Find and Replace’.

2. In Word, the shortcut key Ctrl + F is used to open the Find box.

3. Ctrl + F is used to find a document.

Q:

 In MS-Excel 2010, the address of the topmost cell is:

628 0

  • 1
    Al
    Correct
    Wrong
  • 2
    www.vmou.ac.in
    Correct
    Wrong
  • 3
    AZ
    Correct
    Wrong
  • 4
    1A
    Correct
    Wrong
  • Show Answer
  • Workspace

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

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

619 0

  • 1
    page orientation
    Correct
    Wrong
  • 2
    page size
    Correct
    Wrong
  • 3
    print titles
    Correct
    Wrong
  • 4
    Scale to fit
    Correct
    Wrong
  • Show 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.

  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