Microsoft Office Questions Practice Question and Answer
8 Q: What is the use of the Shift + F3 shortcut key in MS Excel 2010?
1460 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?
1435 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: Information is organized into horizontal and vertical columns for easy reading using ______?
1416 064b91ab0e2108a72393503f3
64b91ab0e2108a72393503f3- 1Mailfalse
- 2Sheetfalse
- 3Boxfalse
- 4Tabletrue
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "Table"
Explanation :
1. Information is organized into horizontal and vertical columns using tables for easy reading.
2. In MS Excel 2010, the horizontal bar is located at the bottom right of the screen.
Q: What is the example of cell address in ms excel 2010?
1414 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.
Q: Can it be kept in a cell of Microsoft Excel?
1407 064b9327c23047f4c71ce4b3b
64b9327c23047f4c71ce4b3b- 1Numberfalse
- 2Textfalse
- 3Formulafalse
- 4All of the abovetrue
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "All of the above "
Explanation :
Can be placed in a cell of Microsoft Excel.
- Number
- Text
- Formula
Q: In MS Access 2010, a user can either create a _______ view or a new table in a _______ view.
1402 064941eeac7d7c7e06717d1d1
64941eeac7d7c7e06717d1d1- 1Design, Datasheettrue
- 2Formula, printfalse
- 3text, numberfalse
- 4bookmark, hyperlinkfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 1. "Design, Datasheet"
Explanation :
1. In MS Access 2010, the user can create a new table in either Design View or Datasheet View.
2. Access 2010 is a database application design and deployment tool that you can use to keep track of important information. You can keep your data on your computer, or you can publish it to the Web - so that other people can access your database with a Web browser.
Q: What is the shortcut key to insert a hyperlink in the document?
1402 064ba62ed2dc867f593074d8e
64ba62ed2dc867f593074d8e- 1Ctrl + Hfalse
- 2Ctrl + Lfalse
- 3Ctrl + Ktrue
- 4Ctrl +Bfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 3. "Ctrl + K"
Explanation :
1. Ctrl + K shortcut is used to insert hyperlink in the document.
2. The web page address, e-mail address, and any other link text or image are parts of a hyperlink.
3. To create a hyperlink field, the link label parameter can be taken from the text dimension of your data source or any expression that returns the value of text.
4. Hyperlink function works with the protocols below:
- http:
-https:
-mailto:
-ftp:
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?
1401 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.

