Microsoft office Practice Question and Answer
8 Q: _______ is a tool in MS Excel 2010 that works backwards for the purpose of calculating an unknown value.
452 064a564728c254a4ceacebec7
64a564728c254a4ceacebec7- 1Boolean operatorfalse
- 2mail mergefalse
- 3Goal Seektrue
- 4bookmarkfalse
- Show AnswerHide 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?
448 064943fd41a612ce001e3d00f
64943fd41a612ce001e3d00f- 1Ctrl + Xfalse
- 2Ctrl + Nfalse
- 3Ctrl + Mfalse
- 4Ctrl + Dtrue
- Show AnswerHide 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: Using which keys opens the option of 'Find and Replace'?
436 064b91e54a2d4dcaf043896c3
64b91e54a2d4dcaf043896c3- 1Ctrl + Ftrue
- 2Ctrl + Xfalse
- 3Ctrl + Rfalse
- 4Ctrl + Hfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 1. "Ctrl + F"
Explanation :
1. Using Ctrl + F opens the option of ‘Find and Replace’.
2. In Word, the shortcut key Ctrl + F is used to open the Find box.
3. Ctrl + F is used to find a document.
Q: Which option is used for formatting the contents of a cell in Ms-excel?
429 064ba3d1aa2d4dcaf043b9c4f
64ba3d1aa2d4dcaf043b9c4f- 1Clipboard group notapfalse
- 2Font groupfalse
- 3Alignment groupfalse
- 4Texttrue
- Show AnswerHide 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: In Word, when you indent a paragraph, you:
424 064a52d358ecb104cc62581d6
64a52d358ecb104cc62581d6- 1Moves the text up one line.false
- 2Change the margin on the page.false
- 3Advances the text with respect to the margin.true
- 4Moves the text down one line.false
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 3. "Advances the text with respect to the margin."
Explanation :
1. In Word, when you indent a paragraph, you move the text relative to the margin.
2. Move all or some characters of the paragraph to a certain distance from the left or right margin.
Q: To monitor all the changes in the document, M.S. What features does Word 2010 use?
417 064b91c9e2d3130f5753f3563
64b91c9e2d3130f5753f3563- 1Edit Documentsfalse
- 2Monitor Changesfalse
- 3Track changestrue
- 4Let's playfalse
- Show AnswerHide 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: _______ is the horizontal bar at the bottom in MS Word 2010, which has various options like page number, word count etc.
414 0649421f2dad6f2e01f5b3313
649421f2dad6f2e01f5b3313- 1Title barfalse
- 2status bartrue
- 3Board Barfalse
- 4Heading barfalse
- Show AnswerHide 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: Which of the following happens if the computer crashes when a restore point is set? Can we restore back?
405 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 AnswerHide 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