Microsoft Office Questions Practice Question and Answer
8 Q: What is the use of the Shift + F3 shortcut key in MS Excel 2010?
1084 064942018187426e04966df1c
64942018187426e04966df1c- 1To insert an imagefalse
- 2To open a new sheetfalse
- 3To save the current sheetfalse
- 4To include the functiontrue
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "To include the function"
Explanation :
1. What is the Shift + F3 shortcut key used in MS Excel 2010 to insert the insert function?
2. In the Function window, you can see all the functions available in Excel.
Q: Which things are used together to add duplicate slides in the presentation of PowerPoint?
1073 064ba776ce2108a7239398525
64ba776ce2108a7239398525- 1Ctrl + Xfalse
- 2Ctrl + Nfalse
- 3Ctrl + Mtrue
- 4Ctrl + Zfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 3. "Ctrl + M"
Explanation :
1. In MS PowerPoint, CTRL+M is a shortcut key used to insert a blank slide after the currently selected slide.
2. MS PowerPoint is a presentation program used to display data with the use of pictures, graphs, etc. in the form of slides.
3. It was created by Robert Gaskins and Dennis Austin.
Q: When the Tab key is pressed, how many space characters are inserted?
1045 064b930272dc867f593041ec1
64b930272dc867f593041ec1- 11false
- 22false
- 33false
- 44true
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "4"
Explanation :
1. When the Tab key is pressed, 4 space characters are inserted.
2. The following are the tasks performed by the keyboard-
- With its help, alpha-numerical data is easily input into the computer.
- In the absence of a mouse, many of the tasks done by the mouse can be done.
- Through this, commands are given to the computer.
- By using the combination of buttons (shortcut keys) present in it, many operations can be performed, which saves a lot of time.
- Apart from this, tasks like playing games, controlling music etc. can be done.
Q: What is the shortcut key for pasting copied cell(s) or range in MS Excel?
1045 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: What are the options available in the Quick Access Toolbar?
1029 064b92b54a2d4dcaf0438c104
64b92b54a2d4dcaf0438c104- 1ctrl + sfalse
- 2ctrl + zfalse
- 3ctrl + yfalse
- 4All of the abovetrue
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "All of the above "
Explanation :
The option is available in the Quick Access Toolbar.
- ctrl + s
- ctrl + z
- ctrl + y
Q: Mainly the following happens in Ms-outlook 2010?
1010 064ba4b762dc867f59306ea7e
64ba4b762dc867f59306ea7e- 1Calendarfalse
- 2Task Managerfalse
- 3Contact Managerfalse
- 4All of the abovetrue
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "All of the above "
Explanation :
Ms-outlook 2010 mainly consists of the following.
- Calendar
- Task Manager
- Contact Manager
- All of the above
- Note taking
- A magazine
- Web browsing
Q: What should be used if a company wants to include its company name and logo at the bottom of each page of the brochure?
1005 064a565b88ecb104cc6265e2f
64a565b88ecb104cc6265e2f- 1Headerfalse
- 2Macrofalse
- 3Footertrue
- 4None of thesefalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 3. "Footer"
Explanation :
1. If a company wants to include its company name and logo at the bottom of each page of the brochure, the footer is to be used.
2. Inserting a header or footer in MS Word is a simple process that can be completed in just a few steps.
- Open the document in MS Word in which you want to insert a header or footer.
- Click on the “Insert” tab at the top of the MS Word window which is to the right of the Home tab. You can also open the insert tab by pressing the MS Word shortcut key “Alt+N”.
- In the “Header & Footer” group, click the “header” or “footer” button, depending on what you want to insert into your document.
- A menu will appear with various header and footer options. Select the desired option and then click “OK”.
- Header or Footer will now be inserted into your document. You can type directly into it or add images and other content as desired. When you're finished, click outside the header or footer area to return to the document.
Q: What is the example of cell address in ms excel 2010?
1004 064941f8513e8bde0323597a0
64941f8513e8bde0323597a0- 11145AZfalse
- 2AZ145true
- 3A12AZfalse
- 411AZ12false
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 2. "AZ145"
Explanation :
1. Example of cell address in MS Excel 2010 is AZ145.

