Computer Knowledge Practice Question and Answer

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?

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

What is the full form of USB?

461 0

  • 1
    Universal sequence bus
    Correct
    Wrong
  • 2
    Union sequence bus
    Correct
    Wrong
  • 3
    Universal Serial Bus
    Correct
    Wrong
  • 4
    Universal Serial Book
    Correct
    Wrong
  • Show Answer
  • Workspace

Answer : 3. "Universal Serial Bus"
Explanation :

1. The full form of USB is Universal Serial Bus.

2. USB is a wired device with the help of which you can connect any other device like mobile with laptop, mobile with computer etc.

3. Apart from this, you can also insert a memory card inside the laptop with its help because it is a port in which we can insert things like Pendrive, Card Reader, Data Cable etc.

Q:

_______ is the horizontal bar at the bottom in MS Word 2010, which has various options like page number, word count etc.

459 0

  • 1
    Title bar
    Correct
    Wrong
  • 2
    status bar
    Correct
    Wrong
  • 3
    Board Bar
    Correct
    Wrong
  • 4
    Heading bar
    Correct
    Wrong
  • Show Answer
  • Workspace

Answer : 2. "status bar"
Explanation :

1. Status Bar is the horizontal bar at the bottom in MS Word 2010, which has many options like page number, word count, etc.

2. A status bar is located at the bottom of an Internet browser window or application window.

3. It displays the current status of the web page or application being displayed.

4. The status bar is the area at the bottom of the Word window that indicates information about the current document.

5. A status bar is located at the bottom of Internet browser windows and many application windows and displays the current status of the Web page or application being displayed.

Q:

In MS Excel 2010, the address from the top left and bottom is:

458 0

  • 1
    A1
    Correct
    Wrong
  • 2
    www.ymou.ac.in
    Correct
    Wrong
  • 3
    AZ
    Correct
    Wrong
  • 4
    1A
    Correct
    Wrong
  • Show Answer
  • Workspace

Answer : 1. "A1"
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:

______ in MM Word lets us send the same letter to different persons.

456 0

  • 1
    Mail Join
    Correct
    Wrong
  • 2
    Mail Paste
    Correct
    Wrong
  • 3
    Mail Insert
    Correct
    Wrong
  • 4
    Mail Merge
    Correct
    Wrong
  • Show Answer
  • Workspace

Answer : 4. "Mail Merge"
Explanation :

1. Mail Merge is a facility in MS Word using multiple or different letters, invitation cards, and personal letters that can be sent to many people in a minimum time.

2. This feature is more useful in a situation when a user has to deliver a letter or invitation card to thousands of people.

3. We can understand mail merge with an example. Suppose we have to send a letter or card to 1000 different people with their names and addresses, in that case, we will have to copy and paste that letter 1000 times for all those people, and then a lot of time will be wasted. A database will be created which will contain the names, addresses and other information of all the recipients. This database file is in MS Excel or MS Access.

Q:

Which of the following happens if the computer crashes when a restore point is set? Can we restore back?

456 0

  • 1
    Restoring Windows Registry
    Correct
    Wrong
  • 2
    Restoring system files, and installed applications.
    Correct
    Wrong
  • 3
    Restoring Windows Registry, System Files, Restoring Installed Applications Both the options are correct.
    Correct
    Wrong
  • 4
    All of the above are wrong.
    Correct
    Wrong
  • Show Answer
  • Workspace

Answer : 3. "Restoring Windows Registry, System Files, Restoring Installed Applications Both the options are correct."
Explanation :

You can restore the following if your computer crashes.

1. Restoring the Windows Registry

2. Restoring installed applications

Q:

What is an example of consumer-to-consumer (c2c) in e-commerce?

453 0

  • 1
    www.ebay.in
    Correct
    Wrong
  • 2
    www.Amazon.In
    Correct
    Wrong
  • 3
    india. Alibaba.Com
    Correct
    Wrong
  • 4
    None of the above
    Correct
    Wrong
  • Show Answer
  • Workspace

Answer : 1. "www.ebay.in"
Explanation :

1. We live in an eCommerce-centric world where all types of business models are growing at a rapid pace.

2. This model involves electronic transactions between two customers. Typically, they transact through a third party that provides a platform to those two customers. Websites selling second-hand items are examples of the C2C eCommerce model.

Q:

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

447 0

  • 1
    Ctrl + M
    Correct
    Wrong
  • 2
    Ctrl + N
    Correct
    Wrong
  • 3
    Ctrl + S
    Correct
    Wrong
  • 4
    Ctrl + P
    Correct
    Wrong
  • Show 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.

  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