Computer Knowledge Practice Question and Answer

Q:

You can access social media from a computer using the following:

1278 0

  • 1
    Documents, Excel, PPT etc.
    Correct
    Wrong
  • 2
    YouTube, Google Play, Outlook etc.
    Correct
    Wrong
  • 3
    Facebook, Instagram, Twitter etc.
    Correct
    Wrong
  • 4
    SSO, PRSY, One Pure
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Facebook, Instagram, Twitter etc."
Explanation :

1. Social media is a technology through which we can share our ideas and information with people.

2. Social media is internet based and it provides instant electronic communication facility to the users. Users connect to social media through a web browser or application from a computer, laptop, tablet or smartphone.

3. Examples of social media –

1. Facebook

2. YouTube

3. Instagram

4. LinkedIn

5. Twitter

6. Whatsapp

7. Pinterest

8. Snapchat

9. Telegram

Q:

There is a table in MS Excel which contains numbers from 0 to 10. If you want to add numbers greater than 5 in that table, then which of the following formula will be suitable?

1278 0

  • 1
    =SUM(A2:A8)
    Correct
    Wrong
  • 2
    =SUM(A2:A8,”
    Correct
    Wrong
  • 3
    =SUMIF(A2:A8,”>0″)
    Correct
    Wrong
  • 4
    =SUMIF(A2:A8, “
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "=SUMIF(A2:A8,”>0″)"
Explanation :

There is a table in MS Excel which contains numbers from 0 to 10. If you have to add numbers greater than 5 in that table, then the formula =SUMIF (A2:A8,”>0″) is suitable.

Q:

Match the following-

(a) Ctrl + Shift + C

(b) Ctrl + Z

(c) Ctrl + L

(d) Ctrl + H

(i) To replace             (ii) The alignment of the text

(iii) Font change       (iv) Undo

(v) Format painter   (vi) For pasting

a) b) c) d)

1277 0

  • 1
    (v) (iii) (ii) (i)
    Correct
    Wrong
  • 2
    (v) (iv) (ii) (i)
    Correct
    Wrong
  • 3
    (vi) (iv) (ii) (i)
    Correct
    Wrong
  • 4
    (iii) (ii) (i) (v)
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "(vi) (iv) (ii) (i)"
Explanation :

All are matched-

(a) Ctrl + Shift + C    (vi) For pasting

(b) Ctrl + Z                 (iv) Undo

(c) Ctrl + L                 (ii) The alignment of the text

(d) Ctrl + H                (i) To replace

Q:

Microsoft’s Messenger allows users to–

1277 0

  • 1
    to bypass a browser to surf the Web
    Correct
    Wrong
  • 2
    create a blog
    Correct
    Wrong
  • 3
    communicate via direct live communication
    Correct
    Wrong
  • 4
    identify and eliminate spam
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "communicate via direct live communication"

Q:

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

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

Who among the following provides hard copy from computer?

1274 0

  • 1
    E-mail
    Correct
    Wrong
  • 2
    Printer
    Correct
    Wrong
  • 3
    Fax
    Correct
    Wrong
  • 4
    Software
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "Printer"

Q:

The primary purpose of a computer is to process _______ and convert it into information.

1273 0

  • 1
    Electricity
    Correct
    Wrong
  • 2
    Data
    Correct
    Wrong
  • 3
    Raw material
    Correct
    Wrong
  • 4
    Water
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 2. "Data"
Explanation :

1. The primary purpose of a computer is to process data and convert it into information. Data is defined as unprocessed information, which is then processed or structured to provide meaningful results. Information is defined as data that can be used for a specific purpose.

2. Computers process data in the following ways-

- Input: Computers receive data through input devices, such as a keyboard, mouse, or camera.

- Processing: Computers process data through processors. The processor operates on data according to a set of instructions.

- Output: Computers display data through output devices, such as monitors, printers, or speakers.

Q:

Which shortcut key is used to insert a new slide in the current presentation?

1267 0

  • 1
    Ctrl + N
    Correct
    Wrong
  • 2
    Ctrl + M
    Correct
    Wrong
  • 3
    Ctrl + S
    Correct
    Wrong
  • 4
    none of the above
    Correct
    Wrong
  • Show AnswerHide Answer
  • Workspace

Answer : 3. "Ctrl + S"

      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