Microsoft Office Questions Practice Question and Answer
8 Q: If you want to repeat row/column on all pages during printing in MS Excel 2010, you can use:
777 0649412efab3c5fffc2ccc486
649412efab3c5fffc2ccc486- 1page orientationfalse
- 2page sizefalse
- 3print titlestrue
- 4Scale to fitfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 3. "print titles"
Explanation :
1. If you want to repeat the row/column on all pages while printing in MS Excel 2010 then you can use Print Titles.
Q: To monitor all the changes in the document, M.S. What features does Word 2010 use?
761 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 a tool in MS Excel 2010 that works backwards for the purpose of calculating an unknown value.
758 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: In MS Excel 2010, the address from the top left and bottom is:
743 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: 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?
741 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.
Q: You can switch the page between portrait and landscape layout in MS Word, 2010. using the following:
728 064a51fb265d2524cbf0b9761
64a51fb265d2524cbf0b9761- 1Orientation shortcuttrue
- 2Margin Shortcutfalse
- 3Size shortcutfalse
- 4Column shortcutfalse
- Show AnswerHide 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: Which keys combination is used to insert duplicate slide in a PowerPoint presentation?
728 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: What is the shortcut key to cut selected cells or range in MS Excel 2010?
713 064940a11c7d7c7e067177886
64940a11c7d7c7e067177886- 1Ctrl + Cfalse
- 2Ctrl + Xtrue
- 3Ctrl + Vfalse
- 4Ctrl + Afalse
- Show AnswerHide 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.

