Computer Knowledge Practice Question and Answer
8 Q: You can access social media from a computer using the following:
1278 064a53edeaa4c004ce31c8ca0
64a53edeaa4c004ce31c8ca0- 1Documents, Excel, PPT etc.false
- 2YouTube, Google Play, Outlook etc.false
- 3Facebook, Instagram, Twitter etc.true
- 4SSO, PRSY, One Purefalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
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 064b8f3ca23047f4c71cd1a38
64b8f3ca23047f4c71cd1a38- 1=SUM(A2:A8)false
- 2=SUM(A2:A8,”false
- 3=SUMIF(A2:A8,”>0″)true
- 4=SUMIF(A2:A8, “false
- Show AnswerHide Answer
- Workspace
- SingleChoice
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 064b91051568e7ff594bde4a7
64b91051568e7ff594bde4a7- 1(v) (iii) (ii) (i)false
- 2(v) (iv) (ii) (i)false
- 3(vi) (iv) (ii) (i)true
- 4(iii) (ii) (i) (v)false
- Show AnswerHide Answer
- Workspace
- SingleChoice
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 06041f94a72ea7a6938381034
6041f94a72ea7a6938381034- 1to bypass a browser to surf the Webfalse
- 2create a blogfalse
- 3communicate via direct live communicationtrue
- 4identify and eliminate spamfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
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 06493ff534e0960e054758dd0
6493ff534e0960e054758dd0- 1Chartsfalse
- 2Filtersfalse
- 3Formulastrue
- 4Tablesfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
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 061a89d365e08c72fe67ed05c
61a89d365e08c72fe67ed05c- 1E-mailfalse
- 2Printertrue
- 3Faxfalse
- 4Softwarefalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 2. "Printer"
Q: The primary purpose of a computer is to process _______ and convert it into information.
1273 064a533f8b394764d11b170e7
64a533f8b394764d11b170e7- 1Electricityfalse
- 2Datatrue
- 3Raw materialfalse
- 4Waterfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
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 061ce9f878067f406dfec0fbe
61ce9f878067f406dfec0fbe- 1Ctrl + Nfalse
- 2Ctrl + Mfalse
- 3Ctrl + Strue
- 4none of the abovefalse
- Show AnswerHide Answer
- Workspace
- SingleChoice

