Microsoft office Practice Question and Answer
8 Q: The horizontal lines displayed in the plot area of a chart in MS Excel 2010 are called.
894 064941e591a612ce001e32bd9
64941e591a612ce001e32bd9- 1Chart titlefalse
- 2data pointfalse
- 3Legendfalse
- 4Gridlinetrue
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "Gridline"
Explanation :
1. The horizontal lines displayed in the plot area of a chart in MS Excel 2010 are called gridlines.
2. Types of Grid Lines in MS Excel 2010 –
- Main grid lines: These show the key values of the data ranges. They have usually displayed every 5 or 10 values.
Secondary grid lines: These show the intervals between data ranges. They usually appear after every 1 or 2 values.
Q: If you want to repeat row/column on all pages during printing in MS Excel 2010, you can use:
415 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: What is the shortcut key to cut selected cells or range in MS Excel 2010?
404 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.
Q: What is the use of Animation Pane in MS Power Point 2010?
625 064940486cae316dfef720209
64940486cae316dfef720209- 1You can check spelling and grammarfalse
- 2You can see a list of animation applied to the slidetrue
- 3You can print the slidesfalse
- 4none of thesefalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 2. "You can see a list of animation applied to the slide"
Explanation :
1. Using the Animation pane in MS PowerPoint 2010 you can see a list of animations applied to the slide.
2. The Animation Pane is a tool that displays a list of animated objects on your slide.
Q: What is the shortcut key to create a new slide in MS PowerPoint 2010?
341 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: What is the shortcut key to start a slide show from a current slide in ms PowerPoint 2010?
419 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.
Q: Which of the following is a feature in Microsoft Excel that is used to perform calculations on data in a spreadsheet?
454 06493ff534e0960e054758dd0
6493ff534e0960e054758dd0- 1Chartsfalse
- 2Filtersfalse
- 3Formulastrue
- 4Tablesfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 3. "Formulas"
Explanation :
1. Which of the following formulas is a feature in Microsoft Excel that is used to perform calculations on data in a spreadsheet?
2. A formula is a special type of formula used to add, subtract, multiply, and divide numbers, text, and other data.
3. LANPAR, the first electronic spreadsheet on mainframe and time-sharing computers, was developed in the year 1969.
Q: The bottom bar of MS Excel application window is called-
645 063ecd1d9aa2a114c951eec3f
63ecd1d9aa2a114c951eec3f- 1Formatting Tool Barfalse
- 2Formula Barfalse
- 3Status bartrue
- 4Title barfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice