Microsoft office Practice Question and Answer

Q:

 In MS-Excel 2010, the address of the topmost cell is:

408 0

  • 1
    Al
    Correct
    Wrong
  • 2
    www.vmou.ac.in
    Correct
    Wrong
  • 3
    AZ
    Correct
    Wrong
  • 4
    1A
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "Al"
Explanation :

1. In MS Excel 2010, the address of the topmost cell is Al.

2. Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X.

3. Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data, and integrating information from different programs.

Q:

Times New Roman is a:

440 0

  • 1
    Font
    Correct
    Wrong
  • 2
    Page layout
    Correct
    Wrong
  • 3
    Printing
    Correct
    Wrong
  • 4
    None of the above
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "Font"
Explanation :

1. Times New Roman is a serif font.

2. Monotype sold the font as "Times New Roman" and Linotype marketed its version as "Times Roman".

3. General typography style in which the vertical lines of characters are straight and not at an angle. This is in contrast to italic, which uses slanted lines.

Q:

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

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

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

444 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

Q:

What is the shortcut key for starting a slide show from the beginning in MS PowerPoint?

424 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. The shortcut key to start the slide show from the beginning in MS PowerPoint is F5. Pressing this key will start the presentation and slide show starting from the first slide.

2. If you want to start the slideshow from the current slide, you can use the Shift+F5 key combination. Pressing this key will start the presentation and start the slide show from the current slide.

Q:

Which of the following alignment option in MS Word 2010 aligns each line of the paragraph between left and right margins and produces straight edges on both left and right edges?

416 0

  • 1
    Center
    Correct
    Wrong
  • 2
    Justify
    Correct
    Wrong
  • 3
    Left
    Correct
    Wrong
  • 4
    Right
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "Justify"
Explanation :

1. The Justify Alignment option in MS Word 2010 aligns each line of the paragraph between the left and right margins and produces straight edges on the left and right margins.

2. Using justify alignment, both sides of each line are aligned with the margins. This creates a uniform text width with uniform spacing.

Q:

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

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

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

483 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