Microsoft office Practice Question and Answer

Q:

The bottom bar of MS Excel application window is called-

644 0

  • 1
    Formatting Tool Bar
    Correct
    Wrong
  • 2
    Formula Bar
    Correct
    Wrong
  • 3
    Status bar
    Correct
    Wrong
  • 4
    Title bar
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Status bar"

Q:

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

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

Following is the control groups in Animation Tab of Microsoft PowerPoint 2010:

612 0

  • 1
    Preview
    Correct
    Wrong
  • 2
    Animation
    Correct
    Wrong
  • 3
    Timing
    Correct
    Wrong
  • 4
    All of these
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "All of these"
Explanation :

1. The Animation tab of Microsoft PowerPoint 2010 contains a group of controls-

- Preview

- Animation

- Time

Q:

By using which tab can you add page numbers in an MS-Word 2019 document? 

633 1

  • 1
    edit
    Correct
    Wrong
  • 2
    format
    Correct
    Wrong
  • 3
    insert
    Correct
    Wrong
  • 4
    Home
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "insert "
Explanation :

In Microsoft Word 2019, you can add page numbers to your document by using the "Insert" tab. The "Insert" tab contains various options, including the "Page Number" option, which allows you to insert page numbers at different locations in your document.

Q:

what is the key combination to open the 'Save As' dialog box in MS PowerPoint? 

599 1

  • 1
    F12.
    Correct
    Wrong
  • 2
    Alt+F then D
    Correct
    Wrong
  • 3
    Alt+F then E
    Correct
    Wrong
  • 4
    Alt+F then O
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "F12."
Explanation :

In MS PowerPoint, the key combination to open the 'Save As' dialog box is F12. Pressing F12 opens the 'Save As' dialog box directly, allowing you to save the current presentation with a new name or in a different location.

Q:

In Microsoft Excel, a single file or document is called?

616 0

  • 1
    workbook
    Correct
    Wrong
  • 2
    worksheet
    Correct
    Wrong
  • 3
    Sheet
    Correct
    Wrong
  • 4
    None of these
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "workbook"

Q:

The number of rows in Excel 2003 is ______.

650 0

  • 1
    65535
    Correct
    Wrong
  • 2
    65536
    Correct
    Wrong
  • 3
    65534
    Correct
    Wrong
  • 4
    65533
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "65536"
Explanation :

In Excel 2003, the number of rows is 65,536. Each worksheet in Excel 2003 consists of 65,536 rows and 256 columns.

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