Microsoft Office Questions Practice Question and Answer
8 Q: _______ is the horizontal bar at the bottom in MS Word 2010, which has various options like page number, word count etc.
352 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: In Word, when you indent a paragraph, you:
347 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: Which option is used for formatting the contents of a cell in Ms-excel?
347 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: To monitor all the changes in the document, M.S. What features does Word 2010 use?
344 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: What is the shortcut key to create a new slide in MS PowerPoint 2010?
336 06494022213e8bde03234f588
6494022213e8bde03234f588- 1Ctrl + Mtrue
- 2Ctrl + Nfalse
- 3Ctrl + Sfalse
- 4Ctrl + Pfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
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.
Q: In MS Excel 2010, the address from the top left and bottom is:
332 064a563ef65d2524cbf0cc838
64a563ef65d2524cbf0cc838- 1A1true
- 2www.ymou.ac.infalse
- 3AZfalse
- 41Afalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
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: Which of the following happens if the computer crashes when a restore point is set? Can we restore back?
331 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
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?
331 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.