Microsoft Office Questions Practice Question and Answer

Q:

What should be used if a company wants to include its company name and logo at the bottom of each page of the brochure?

867 0

  • 1
    Header
    Correct
    Wrong
  • 2
    Macro
    Correct
    Wrong
  • 3
    Footer
    Correct
    Wrong
  • 4
    None of these
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Footer"
Explanation :

1. If a company wants to include its company name and logo at the bottom of each page of the brochure, the footer is to be used.

2. Inserting a header or footer in MS Word is a simple process that can be completed in just a few steps.

- Open the document in MS Word in which you want to insert a header or footer.

- Click on the “Insert” tab at the top of the MS Word window which is to the right of the Home tab. You can also open the insert tab by pressing the MS Word shortcut key “Alt+N”.

- In the “Header & Footer” group, click the “header” or “footer” button, depending on what you want to insert into your document.

- A menu will appear with various header and footer options. Select the desired option and then click “OK”.

- Header or Footer will now be inserted into your document. You can type directly into it or add images and other content as desired. When you're finished, click outside the header or footer area to return to the document.

Q:

M.S. What method is used to close a PowerPoint 2010 file? Choose the most suitable option.

865 0

  • 1
    Click on the File tab and then click on the Close option.
    Correct
    Wrong
  • 2
    You can click on the close button appearing on the top right side of the window can do.
    Correct
    Wrong
  • 3
    The keyboard shortcut Ctrl + W can be used.
    Correct
    Wrong
  • 4
    All of the Above
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

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

The following method is used to close the file of MS PowerPoint 2010.

- Click on the File tab and then click on the Close option.

- You can click on the close button appearing on the top right side of the window.

- The keyboard shortcut Ctrl + W can be used.

Q:

Can you save the MS Office document in PDF file format?

856 0

  • 1
    Select 'Save as type: PDF' in the File tab Save as
    Correct
    Wrong
  • 2
    Use Voice over IP
    Correct
    Wrong
  • 3
    By writing an e-mail
    Correct
    Wrong
  • 4
    Using print preview
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "Select 'Save as type: PDF' in the File tab Save as"
Explanation :

To save MS-Office documents in PDF file format, you can follow the following steps-

1. Open your MS-Office document.

2. Click on the File tab.

3. Click on Save As.

4. Select PDF from the Save As Type drop-down list.

4. In the File Name box, enter a name for your document.

5. Click on Save.

Q:

What is the shortcut key to insert a hyperlink in the document?

853 0

  • 1
    Ctrl + H
    Correct
    Wrong
  • 2
    Ctrl + L
    Correct
    Wrong
  • 3
    Ctrl + K
    Correct
    Wrong
  • 4
    Ctrl +B
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Ctrl + K"
Explanation :

1. Ctrl + K shortcut is used to insert hyperlink in the document.

2. The web page address, e-mail address, and any other link text or image are parts of a hyperlink.

3. To create a hyperlink field, the link label parameter can be taken from the text dimension of your data source or any expression that returns the value of text.

4. Hyperlink function works with the protocols below:

- http:

-https:

-mailto:

-ftp:

Q:

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

848 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 of the following is a feature in Microsoft Excel that is used to perform calculations on data in a spreadsheet?

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

In Word, when you indent a paragraph, you:

835 0

  • 1
    Moves the text up one line.
    Correct
    Wrong
  • 2
    Change the margin on the page.
    Correct
    Wrong
  • 3
    Advances the text with respect to the margin.
    Correct
    Wrong
  • 4
    Moves the text down one line.
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Advances the text with respect to the margin."
Explanation :

1. In Word, when you indent a paragraph, you move the text relative to the margin.

2. Move all or some characters of the paragraph to a certain distance from the left or right margin.

Q:

M.S. In 2010 ______ function will display the remainder after dividing a number by the divisor.

834 0

  • 1
    Round ()
    Correct
    Wrong
  • 2
    Fact ()
    Correct
    Wrong
  • 3
    MOD ()
    Correct
    Wrong
  • 4
    DIV ()
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "MOD ()"
Explanation :

The MOD() function in MS 2010 will display the remainder after dividing a number by the divisor.

      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