Microsoft Office Questions Practice Question and Answer

Q:

Which things are used together to add duplicate slides in the presentation of PowerPoint?

1375 0

  • 1
    Ctrl + X
    Correct
    Wrong
  • 2
    Ctrl + N
    Correct
    Wrong
  • 3
    Ctrl + M
    Correct
    Wrong
  • 4
    Ctrl + Z
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Ctrl + M"
Explanation :

1. In MS PowerPoint, CTRL+M is a shortcut key used to insert a blank slide after the currently selected slide.

2. MS PowerPoint is a presentation program used to display data with the use of pictures, graphs, etc. in the form of slides.

3. It was created by Robert Gaskins and Dennis Austin.

Q:

What is the use of the Shift + F3 shortcut key in MS Excel 2010?

1372 0

  • 1
    To insert an image
    Correct
    Wrong
  • 2
    To open a new sheet
    Correct
    Wrong
  • 3
    To save the current sheet
    Correct
    Wrong
  • 4
    To include the function
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "To include the function"
Explanation :

1. What is the Shift + F3 shortcut key used in MS Excel 2010 to insert the insert function?

2. In the Function window, you can see all the functions available in Excel.

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?

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

Information is organized into horizontal and vertical columns for easy reading using ______?

1335 0

  • 1
    Mail
    Correct
    Wrong
  • 2
    Sheet
    Correct
    Wrong
  • 3
    Box
    Correct
    Wrong
  • 4
    Table
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "Table"
Explanation :

1. Information is organized into horizontal and vertical columns using tables for easy reading.

2. In MS Excel 2010, the horizontal bar is located at the bottom right of the screen.

Q:

In MS Access 2010, a user can either create a _______ view or a new table in a _______ view.

1333 0

  • 1
    Design, Datasheet
    Correct
    Wrong
  • 2
    Formula, print
    Correct
    Wrong
  • 3
    text, number
    Correct
    Wrong
  • 4
    bookmark, hyperlink
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "Design, Datasheet"
Explanation :

1. In MS Access 2010, the user can create a new table in either Design View or Datasheet View.

2. Access 2010 is a database application design and deployment tool that you can use to keep track of important information. You can keep your data on your computer, or you can publish it to the Web - so that other people can access your database with a Web browser.

Q:

M.S. Which data types cannot be changed by the user in Access 2010? Choose the most appropriate option.

1324 0

  • 1
    Auto Text
    Correct
    Wrong
  • 2
    Date/Time
    Correct
    Wrong
  • 3
    Auto Number
    Correct
    Wrong
  • 4
    All of the Above
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

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

In MS Access 2010, data types cannot be entered or changed by the user.

- Auto Text

- Date/Time

- Auto Number

Q:

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

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

What are the options available in the Quick Access Toolbar?

1318 0

  • 1
    ctrl + s
    Correct
    Wrong
  • 2
    ctrl + z
    Correct
    Wrong
  • 3
    ctrl + y
    Correct
    Wrong
  • 4
    All of the above
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

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

The option is available in the Quick Access Toolbar.

- ctrl + s

- ctrl + z

- ctrl + y

      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