Microsoft office Practice Question and Answer

Q:

What is Microsoft Word?

579 0

  • 1
    Operating System
    Correct
    Wrong
  • 2
    word processing program
    Correct
    Wrong
  • 3
    Microsoft Windows
    Correct
    Wrong
  • 4
    None of the above
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "word processing program"

Q:

The extension of MS Excel's workbook or file is-

536 0

  • 1
    .DOC
    Correct
    Wrong
  • 2
    .XLX
    Correct
    Wrong
  • 3
    .XLC
    Correct
    Wrong
  • 4
    .XLSX
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. ".XLSX"

Q:

What is the shortcut key for opening a new document or window?

529 0

  • 1
    Ctrl + O
    Correct
    Wrong
  • 2
    Ctrl + S
    Correct
    Wrong
  • 3
    Ctrl + N
    Correct
    Wrong
  • 4
    Ctrl + P
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Ctrl + N"
Explanation :

1. In Microsoft Word, Excel, and PowerPoint, the shortcut key to open a new document or window is Ctrl+N. Pressing this key will open a new document or window.

2. If you want to open a specific type of document, you can select a specific document type following the Ctrl+N key combination. For example, if you want to open a new Word document, you can select Word Document followed by the Ctrl+N key combination.

3. Here are some other shortcut keys that can be used to open a new document or window-

- Ctrl+O: Open an existing document

- Ctrl+S: Save the current document

- Ctrl+P: Print the current document

- Ctrl+X: Cut selected content

- Ctrl+C: Copy selected content

- Ctrl+V: Paste selected content

- Ctrl+Z: Cancel previous action

- Ctrl+Y: Redo the previous action

Q:

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

519 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.

508 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 open File Explorer or File Manager?

499 0

  • 1
    Ctrl + N
    Correct
    Wrong
  • 2
    Ctrl + O
    Correct
    Wrong
  • 3
    Ctrl + E
    Correct
    Wrong
  • 4
    Ctrl + F
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "Ctrl + O"
Explanation :

1. The shortcut key to open File Explorer or File Manager is Ctrl + O.

2. In Microsoft Excel and all other spreadsheet programs, pressing Ctrl+O brings up the Open window, allowing you to load an existing spreadsheet stored on your computer.

3. In Microsoft Word and other word processors, pressing Ctrl+O brings up the Open window, allowing you to load an existing document stored on your computer.

Q:

M.S. Which chart cannot be created in Excel?

491 0

  • 1
    7d
    Correct
    Wrong
  • 2
    Pie
    Correct
    Wrong
  • 3
    Area
    Correct
    Wrong
  • 4
    Stock
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "7d"
Explanation :

1. M.S. The following charts can be created in Excel.

- Column - Chart

- line chart

- Pie chart

- Donut chart

- Bar chart

- Area Chart

- XY (Scatter) chart

- Bubble chart

- Stock Chart

- Surface Chart

- Radar chart

- Combo chart

Q:

Following are the elements of a chart in MS Excel 2010:

481 0

  • 1
    Chart Title, Legend, Data Labels
    Correct
    Wrong
  • 2
    Data Points, Data Series, Gridlines
    Correct
    Wrong
  • 3
    Value Axis, Category Axis
    Correct
    Wrong
  • 4
    All of these
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "Data Points, Data Series, Gridlines"
Explanation :

The elements of a chart in MS Excel 2010 include the following:-

1. Title: The title of the chart, which describes the topic or purpose of the chart.

2. Axis: Lines used to measure data on a chart.

3. Data Series: A group of data points on a chart.

4. Chart Area: The outer area of the chart, including the title, axes, and data series.

5. Legend: Labels used to identify data series on a chart.

6. Gridlines: Lines used to measure data on a chart.

7. Data Labels: Labels used to display the values of data points on a chart.

8. Data Table: A table used to display data from data series below the chart.

      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