Microsoft Office Questions Practice Question and Answer

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:

What is the shortcut key to create a new slide in MS PowerPoint 2010?

337 0

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

Answer : 1. "Ctrl + M"
Explanation :

1. F5 is used to start a presentation from the beginning.

2. We can see how your slideshow looks in full screen.

3. To start the slide show from the current slide, press Shift+F5.

4. The shortcut key to create a new slide in MS PowerPoint 2010 is Ctrl + M.

Q:

Which keys combination is used to insert duplicate slide in a PowerPoint presentation?

397 0

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

Answer : 4. "Ctrl + D"
Explanation :

1. In Microsoft PowerPoint, the Ctrl + D shortcut key inserts a duplicate of the selected slide.

2. Ctrl+D is a keyboard shortcut used in many computer programs to perform various tasks. In a web browser, pressing Ctrl+D adds the current webpage to your bookmarks or favourites list.

3. In Microsoft Excel and Google Sheets, pressing Ctrl+D fills a cell and overwrites it with the contents of the cell in a column above it.

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 default chart type in Microsoft excel?

1100 1

  • 1
    pie chart
    Correct
    Wrong
  • 2
    line chart
    Correct
    Wrong
  • 3
    surface chart
    Correct
    Wrong
  • 4
    column chart
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "column chart"
Explanation :

In Microsoft Excel, the default chart type for most data is the "Column Chart." When you create a new chart in Excel without specifying a specific type, it usually starts with a column chart where data points are represented as vertical bars. Of course, you can change the chart type later based on your preferences and the type of data you want to visualize.

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:

What is the shortcut key to start a slide show from a current slide in ms PowerPoint 2010?

419 0

  • 1
    F5
    Correct
    Wrong
  • 2
    F6
    Correct
    Wrong
  • 3
    F7
    Correct
    Wrong
  • 4
    F8
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "F5"
Explanation :

1. F5 is used to start a presentation from the beginning.

2. We can see how your slideshow looks in full screen.

3. To start the slide show from the current slide, press Shift+F5.

4. The shortcut key to create a new slide in MS PowerPoint 2010 is Ctrl + M.

Q:

What is the shortcut key for pasting copied cell(s) or range in MS Excel?

443 0

  • 1
    Ctrl + C
    Correct
    Wrong
  • 2
    Ctrl + X
    Correct
    Wrong
  • 3
    Ctrl + V
    Correct
    Wrong
  • 4
    Ctrl + A
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Ctrl + V"
Explanation :

1. The shortcut key to paste the copied cell or range in MS Excel is Ctrl+V. Pressing this key will paste the copied data into the current cell or range.

2. If you want to paste the copied data at a new location, you can click on that location using the mouse or paste it using the Ctrl+V key combination.

3. Here are some other shortcut keys that can be used to paste data in MS Excel.

- Ctrl+C: Copy

- Ctrl+X: Cut

- Ctrl+V: Paste

- Ctrl+Shift+V: Paste Special

- Alt+E, S, V: Paste option

      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