Microsoft Office Questions Practice Question and Answer
8 Q: _______ is a tool in MS Excel 2010 that works backwards for the purpose of calculating an unknown value.
584 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?
573 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: ______ in MM Word lets us send the same letter to different persons.
571 064b8f1252d3130f5753e4cab
64b8f1252d3130f5753e4cab- 1Mail Joinfalse
- 2Mail Pastefalse
- 3Mail Insertfalse
- 4Mail Mergetrue
- Show Answer
- Workspace
- SingleChoice
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: You can switch the page between portrait and landscape layout in MS Word, 2010. using the following:
566 064a51fb265d2524cbf0b9761
64a51fb265d2524cbf0b9761- 1Orientation shortcuttrue
- 2Margin Shortcutfalse
- 3Size shortcutfalse
- 4Column shortcutfalse
- Show Answer
- Workspace
- SingleChoice
Answer : 1. "Orientation shortcut"
Explanation :
1. You can switch pages between portrait and landscape layouts in MS Word, 2010 using the orientation shortcut.
2. The two most common types of orientation are portrait and landscape.
Q: _______ is the horizontal bar at the bottom in MS Word 2010, which has various options like page number, word count etc.
563 0649421f2dad6f2e01f5b3313
649421f2dad6f2e01f5b3313- 1Title barfalse
- 2status bartrue
- 3Board Barfalse
- 4Heading barfalse
- Show Answer
- Workspace
- SingleChoice
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: To monitor all the changes in the document, M.S. What features does Word 2010 use?
558 064b91c9e2d3130f5753f3563
64b91c9e2d3130f5753f3563- 1Edit Documentsfalse
- 2Monitor Changesfalse
- 3Track changestrue
- 4Let's playfalse
- Show Answer
- Workspace
- SingleChoice
Answer : 3. "Track changes"
Explanation :
1. MS to monitor all changes in the document. Track Changes features are used in Word 2010.
2. Track Changes is a way for Microsoft Word to keep track of changes you make to your text.
3. Track shift is also known as redline or redline. This is because some industries have historically drawn a vertical red line in the margin to indicate that some text has changed. Q: What is the shortcut key to cut selected cells or range in MS Excel 2010?
555 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: Which of the following happens if the computer crashes when a restore point is set? Can we restore back?
547 064b8f2a588d5e4f52ddefc00
64b8f2a588d5e4f52ddefc00- 1Restoring Windows Registryfalse
- 2Restoring system files, and installed applications.false
- 3Restoring Windows Registry, System Files, Restoring Installed Applications Both the options are correct.true
- 4All of the above are wrong.false
- Show Answer
- Workspace
- SingleChoice
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