Microsoft Office Questions Practice Question and Answer
8 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: What is the shortcut key to create a new slide in MS PowerPoint 2010?
337 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: Which keys combination is used to insert duplicate slide in a PowerPoint presentation?
397 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: 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 default chart type in Microsoft excel?
1100 163bfea5574eba5069d5bea6a
63bfea5574eba5069d5bea6a- 1pie chartfalse
- 2line chartfalse
- 3surface chartfalse
- 4column charttrue
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "column chart"
Explanation :
In Microsoft Excel, the default chart type for most data is the "Column Chart." When you create a new chart in Excel without specifying a specific type, it usually starts with a column chart where data points are represented as vertical bars. Of course, you can change the chart type later based on your preferences and the type of data you want to visualize.
Q: What is Microsoft Word?
579 063e60417dfb7d089e5739012
63e60417dfb7d089e5739012- 1Operating Systemfalse
- 2word processing programtrue
- 3Microsoft Windowsfalse
- 4None of the abovefalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 2. "word processing program"
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: What is the shortcut key for pasting copied cell(s) or range in MS Excel?
443 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