General Introduction Practice Question and Answer

Q:

What is the use of Paste With Live Preview in MS Excel 2010?

1245 0

  • 1
    It avoids repeated hits and trails and you can easily re-use the content preview.
    Correct
    Wrong
  • 2
    It can repair all files and folders.
    Correct
    Wrong
  • 3
    It is useful for computing unknown values.
    Correct
    Wrong
  • 4
    No such preview is available in MS Excel 2010.
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "It avoids repeated hits and trails and you can easily re-use the content preview."

Q:

These are types of LCD projectors.

1209 0

  • 1
    Flat Panel and Laser
    Correct
    Wrong
  • 2
    Normal and Roof Mounted
    Correct
    Wrong
  • 3
    Mesh Model and Curved
    Correct
    Wrong
  • 4
    none of these
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Mesh Model and Curved"
Explanation :

1. LCD panel types include normal and roof-mounted.

2. Liquid Crystal Display flats are thinner and lighter making them more useful and easier for users than CRTs. It consumes less power than CRT.

Q:

Suppose a directory has sub directories and some files, what happens whenever you move that directory from one place to another?

1194 0

  • 1
    Only the files inside the directory are transferred
    Correct
    Wrong
  • 2
    Only the sub directories inside the directory are moved.
    Correct
    Wrong
  • 3
    Directories are moved but source files are not transferred.
    Correct
    Wrong
  • 4
    The files and sub directories inside the directory are moved.
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 4. "The files and sub directories inside the directory are moved."

Q:

How to represent the cell range A9 to A99 in Excel -

1146 1

  • 1
    (A9,A99)
    Correct
    Wrong
  • 2
    (A9TOA99)
    Correct
    Wrong
  • 3
    (A9:A99)
    Correct
    Wrong
  • 4
    (A9-A99)
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "(A9:A99)"

Q:

From which tab you can insert picture, text box, chart etc.

1094 0

  • 1
    File
    Correct
    Wrong
  • 2
    Edit
    Correct
    Wrong
  • 3
    Insert
    Correct
    Wrong
  • 4
    View
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Insert"

Q:

Which of the following is not application software?

1090 0

  • 1
    Windows XP
    Correct
    Wrong
  • 2
    VLC Media Player
    Correct
    Wrong
  • 3
    Adobe Reader
    Correct
    Wrong
  • 4
    Photoshop
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "Windows XP"
Explanation :

1. The application software among these is not Windows XP.

2. List of Application Software-

- VLC MEDIA PLAYER

-  Adobe Reader

- Photoshop

Q:

Which of the following formula is written incorrectly for Excel -

1087 0

  • 1
    =97+45
    Correct
    Wrong
  • 2
    =C8*B1
    Correct
    Wrong
  • 3
    97+45
    Correct
    Wrong
  • 4
    =C9+16
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "97+45"

Q:

Suppose there are some numerical values in cells B1, B2 and B3 in MS-Excel. What is the correct formula to find the minimum of the values in these cells?

1071 0

  • 1
    =MIN(B1,MIN(B2,B3))
    Correct
    Wrong
  • 2
    =MIN(B1,MAX(B2,B3))
    Correct
    Wrong
  • 3
    =MAX(B1, MIN(B2,B3))
    Correct
    Wrong
  • 4
    =MAX(B1,MAX(B2,B3))
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "=MIN(B1,MIN(B2,B3))"

      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