Computer GK Practice Question and Answer
8 Q: Which of the following application software is closely related to Database Management System?
494 0649424ecdad6f2e01f5b372b
649424ecdad6f2e01f5b372b- 1M.S. Wordfalse
- 2M.S. accesstrue
- 3M.S. Excelfalse
- 4M.S. powerpointfalse
- Show Answer
- Workspace
- SingleChoice
Answer : 2. "M.S. access"
Explanation :
1. Application software is closely related to database management systems M.S. Excel related.
2. It is system software for creating and managing databases.
3. It is software designed to store, retrieve, define, and manage data in a database.
Q: _______ is a tool in MS Excel 2010 that works backwards for the purpose of calculating an unknown value.
493 064a564728c254a4ceacebec7
64a564728c254a4ceacebec7- 1Boolean operatorfalse
- 2mail mergefalse
- 3Goal Seektrue
- 4bookmarkfalse
- Show Answer
- Workspace
- SingleChoice
Answer : 3. "Goal Seek"
Explanation :
1. In MS Excel 2010, "Goal Seek" is a tool that works backwards with the aim of calculating an unknown value.
2. This tool allows you to set a desired result in one cell and then adjust the values in other cells to achieve that result.
Q: Which keys combination is used to insert duplicate slide in a PowerPoint presentation?
492 064943fd41a612ce001e3d00f
64943fd41a612ce001e3d00f- 1Ctrl + Xfalse
- 2Ctrl + Nfalse
- 3Ctrl + Mfalse
- 4Ctrl + Dtrue
- Show Answer
- Workspace
- SingleChoice
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: Which option is used for formatting the contents of a cell in Ms-excel?
491 064ba3d1aa2d4dcaf043b9c4f
64ba3d1aa2d4dcaf043b9c4f- 1Clipboard group notapfalse
- 2Font groupfalse
- 3Alignment groupfalse
- 4Texttrue
- Show Answer
- Workspace
- SingleChoice
Answer : 4. "Text"
Explanation :
1. In MS Excel, the text option is used for formatting the cell's content.
2. Under the formatting of text, alignment of the font in the cell, style of font, the colour of font, bold, italics, underline, fill colour, border colour, the format of numbers, format of date, format of decimal digits, wrap text ( Wrapping text), Shrink to fit, Orientation (vertically and horizontally), etc.
3. Use the following steps for formatting the text-
1. Select the cells or range that need to be formatted.
2. Select the Cell option from the Format menu on the menu bar.
3. You will get different tabs for different formats.
4. Click on the Font tab and do the formatting as required.
5. Finally click on the OK button.
Q: What is the shortcut key to cut selected cells or range in MS Excel 2010?
491 064940a11c7d7c7e067177886
64940a11c7d7c7e067177886- 1Ctrl + Cfalse
- 2Ctrl + Xtrue
- 3Ctrl + Vfalse
- 4Ctrl + Afalse
- Show Answer
- Workspace
- SingleChoice
Answer : 2. "Ctrl + X"
Explanation :
1. To cut a cell or range in Excel: Ctrl + X can be used to cut a selected cell or range in MS Excel. This copies the data to the clipboard and clears the original cells or range.
2. To cut text: Ctrl + X can be used to cut selected text in any text editor or word processor. This copies the text to the clipboard and frees up the original space.
3. To cut an image or object: Ctrl + X can be used to cut a selected image or object in any graphics program. This copies the image or object to the clipboard and frees up the original space.
Q: Given the following e-mail fields, which e-mail addresses will 'D' be able to see when he receives the message?
To... A@test.com
Cc... B@test.com; C@test.com
Bcc... D@test.com; E@test.com
490 064a56233b394764d11b2234b
64a56233b394764d11b2234bTo... A@test.com
Cc... B@test.com; C@test.com
Bcc... D@test.com; E@test.com
- 1A@test.comfalse
- 2A@lest.com; B@test.com; C@test.com.true
- 3A@test.com: E@test.comfalse
- 4A@test.com; E@test.com: B@test.com: C@test.comfalse
- Show Answer
- Workspace
- SingleChoice
Answer : 2. "A@lest.com; B@test.com; C@test.com."
Explanation :
The following e-mail fields are given, when 'D' receives the message he will see the following e-mail addresses-
A@lest.com; b@test.com; C@test.com.
Q: What is the use of a Mobile Wallet?
489 064b914b12d3130f5753f077a
64b914b12d3130f5753f077a- 1Dialling numbers and watching videosfalse
- 2Callingfalse
- 3Exchange of moneytrue
- 4None of the abovefalse
- Show Answer
- Workspace
- SingleChoice
Answer : 3. "Exchange of money"
Explanation :
The mobile wallet can be used for the following functions:
1. Payment: Using a mobile wallet, you can make payments both online and offline. You can pay using your mobile wallet at any store, restaurant, or other business that accepts mobile wallets.
2. Money Transfer: Using a mobile wallet, you can transfer funds from your bank account to another person's bank account. You can send money to your friends, family, or any other person using a mobile wallet.
3. Recharge and bill payments: Using a mobile wallet, you can pay your mobile phone, data pack, electricity bill, water bill, and other bills.
4. Point of Sale (POS) Transactions: Using mobile wallets, you can make payments through POS machines. For POS transactions, you simply need to open your mobile wallet app and tap your phone on the POS machine to make a payment.
Q: Which of the following will not advance the slide in the slide show view?
487 064a52a46aa4c004ce31c6099
64a52a46aa4c004ce31c6099- 1Esc keytrue
- 2Enter keyfalse
- 3Spacebarfalse
- 4Mouse buttonfalse
- Show Answer
- Workspace
- SingleChoice
Answer : 1. "Esc key"
Explanation :
1. The Esc key will not advance the slide in the slideshow view.
2. There is a button on the left side of the keyboard which is called “ESC Key”. This key is right next to the Functions Keys.
3. It is mostly used to cancel a command. As-
- An open Dialog Box can also be closed with the Escape key without using the mouse.
- A website being loaded in a browser can be cancelled by using the Escape key. That is, the website is not allowed to load.
- It is also used in many games to cancel Kari.
- The videos shown on the full screen of the media player can be opened in normal mode by using the Escape key.
- It is also used to cancel a wrong entry in an input field.
- Open Start Menu or PullDown Menu can be closed quickly by Esc key.