Microsoft Office Questions Practice Question and Answer

Q:

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

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

494 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?

493 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?

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

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

Q:

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

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

When the Tab key is pressed, how many space characters are inserted?

455 0

  • 1
    1
    Correct
    Wrong
  • 2
    2
    Correct
    Wrong
  • 3
    3
    Correct
    Wrong
  • 4
    4
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "4"
Explanation :

1. When the Tab key is pressed, 4 space characters are inserted.

2. The following are the tasks performed by the keyboard-

- With its help, alpha-numerical data is easily input into the computer.

- In the absence of a mouse, many of the tasks done by the mouse can be done.

- Through this, commands are given to the computer.

- By using the combination of buttons (shortcut keys) present in it, many operations can be performed, which saves a lot of time.

- Apart from this, tasks like playing games, controlling music etc. can be done.

Q:

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

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

      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