Microsoft office Practice Question and Answer
8 Q: Which option is used for formatting the contents of a cell in Ms-excel?
1328 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: What is the shortcut key for pasting copied cell(s) or range in MS Excel?
1318 06495390fcae316dfef75a9df
6495390fcae316dfef75a9df- 1Ctrl + Cfalse
- 2Ctrl + Xfalse
- 3Ctrl + Vtrue
- 4Ctrl + Afalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 3. "Ctrl + V"
Explanation :
1. The shortcut key to paste the copied cell or range in MS Excel is Ctrl+V. Pressing this key will paste the copied data into the current cell or range.
2. If you want to paste the copied data at a new location, you can click on that location using the mouse or paste it using the Ctrl+V key combination.
3. Here are some other shortcut keys that can be used to paste data in MS Excel.
- Ctrl+C: Copy
- Ctrl+X: Cut
- Ctrl+V: Paste
- Ctrl+Shift+V: Paste Special
- Alt+E, S, V: Paste option
Q: M.S. In 2010 ______ function will display the remainder after dividing a number by the divisor.
1296 064ba6355c3da05b2213e8359
64ba6355c3da05b2213e8359- 1Round ()false
- 2Fact ()false
- 3MOD ()true
- 4DIV ()false
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 3. "MOD ()"
Explanation :
The MOD() function in MS 2010 will display the remainder after dividing a number by the divisor.
Q: Can you save the MS Office document in PDF file format?
1291 064a594eb9a74b54cff59c042
64a594eb9a74b54cff59c042- 1Select 'Save as type: PDF' in the File tab Save astrue
- 2Use Voice over IPfalse
- 3By writing an e-mailfalse
- 4Using print previewfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 1. "Select 'Save as type: PDF' in the File tab Save as"
Explanation :
To save MS-Office documents in PDF file format, you can follow the following steps-
1. Open your MS-Office document.
2. Click on the File tab.
3. Click on Save As.
4. Select PDF from the Save As Type drop-down list.
4. In the File Name box, enter a name for your document.
5. Click on Save.
Q: In Word, when you indent a paragraph, you:
1284 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: Times New Roman is a:
1255 064a51ad0b394764d11b0c292
64a51ad0b394764d11b0c292- 1Fonttrue
- 2Page layoutfalse
- 3Printingfalse
- 4None of the abovefalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 1. "Font"
Explanation :
1. Times New Roman is a serif font.
2. Monotype sold the font as "Times New Roman" and Linotype marketed its version as "Times Roman".
3. General typography style in which the vertical lines of characters are straight and not at an angle. This is in contrast to italic, which uses slanted lines.
Q: _______ is a tool in MS Excel 2010 that works backwards for the purpose of calculating an unknown value.
1255 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: What is the shortcut key to start a slide show from a current slide in ms PowerPoint 2010?
1250 06494014913e8bde03234eb3e
6494014913e8bde03234eb3e- 1F5true
- 2F6false
- 3F7false
- 4F8false
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 1. "F5"
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.

