Microsoft office Practice Question and Answer
8 Q: The bottom bar of MS Excel application window is called-
644 063ecd1d9aa2a114c951eec3f
63ecd1d9aa2a114c951eec3f- 1Formatting Tool Barfalse
- 2Formula Barfalse
- 3Status bartrue
- 4Title barfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 3. "Status bar"
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: Following is the control groups in Animation Tab of Microsoft PowerPoint 2010:
612 0649435abdad6f2e01f5b840a
649435abdad6f2e01f5b840a- 1Previewfalse
- 2Animationfalse
- 3Timingfalse
- 4All of thesetrue
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "All of these"
Explanation :
1. The Animation tab of Microsoft PowerPoint 2010 contains a group of controls-
- Preview
- Animation
- Time
Q: By using which tab can you add page numbers in an MS-Word 2019 document?
633 163ac0ff5fb04114b2d3b656e
63ac0ff5fb04114b2d3b656e- 1editfalse
- 2formatfalse
- 3inserttrue
- 4Homefalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 3. "insert "
Explanation :
In Microsoft Word 2019, you can add page numbers to your document by using the "Insert" tab. The "Insert" tab contains various options, including the "Page Number" option, which allows you to insert page numbers at different locations in your document.
Q: what is the key combination to open the 'Save As' dialog box in MS PowerPoint?
599 163ac18f54edf0d56992fd856
63ac18f54edf0d56992fd856- 1F12.true
- 2Alt+F then Dfalse
- 3Alt+F then Efalse
- 4Alt+F then Ofalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 1. "F12."
Explanation :
In MS PowerPoint, the key combination to open the 'Save As' dialog box is F12. Pressing F12 opens the 'Save As' dialog box directly, allowing you to save the current presentation with a new name or in a different location.
Q: In Microsoft Excel, a single file or document is called?
616 063bff0cab90600403be5d14f
63bff0cab90600403be5d14f- 1workbooktrue
- 2worksheetfalse
- 3Sheetfalse
- 4None of thesefalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 1. "workbook"
Q: The number of rows in Excel 2003 is ______.
650 063ecd224e6cd351b75fdc8a1
63ecd224e6cd351b75fdc8a1- 165535false
- 265536true
- 365534false
- 465533false
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 2. "65536"
Explanation :
In Excel 2003, the number of rows is 65,536. Each worksheet in Excel 2003 consists of 65,536 rows and 256 columns.
Q: Following are the elements of a chart in MS Excel 2010:
481 0649438a9ab3c5fffc2cd2d6e
649438a9ab3c5fffc2cd2d6e- 1Chart Title, Legend, Data Labelsfalse
- 2Data Points, Data Series, Gridlinestrue
- 3Value Axis, Category Axisfalse
- 4All of thesefalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 2. "Data Points, Data Series, Gridlines"
Explanation :
The elements of a chart in MS Excel 2010 include the following:-
1. Title: The title of the chart, which describes the topic or purpose of the chart.
2. Axis: Lines used to measure data on a chart.
3. Data Series: A group of data points on a chart.
4. Chart Area: The outer area of the chart, including the title, axes, and data series.
5. Legend: Labels used to identify data series on a chart.
6. Gridlines: Lines used to measure data on a chart.
7. Data Labels: Labels used to display the values of data points on a chart.
8. Data Table: A table used to display data from data series below the chart.