Microsoft office Practice Question and Answer
6 Q: In MS Excel 2010, the address from the top left and bottom is:
338 064a563ef65d2524cbf0cc838
64a563ef65d2524cbf0cc838- 1A1true
- 2www.ymou.ac.infalse
- 3AZfalse
- 41Afalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 1. "A1"
Explanation :
1. In MS Excel 2010, the address of the topmost cell is Al.
2. Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X.
3. Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data, and integrating information from different programs.
Q: There is a table in MS Excel which contains numbers from 0 to 10. If you want to add numbers greater than 5 in that table, then which of the following formula will be suitable?
338 064b8f3ca23047f4c71cd1a38
64b8f3ca23047f4c71cd1a38- 1=SUM(A2:A8)false
- 2=SUM(A2:A8,”false
- 3=SUMIF(A2:A8,”>0″)true
- 4=SUMIF(A2:A8, “false
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 3. "=SUMIF(A2:A8,”>0″)"
Explanation :
There is a table in MS Excel which contains numbers from 0 to 10. If you have to add numbers greater than 5 in that table, then the formula =SUMIF (A2:A8,”>0″) is suitable.
Q: Which of the following happens if the computer crashes when a restore point is set? Can we restore back?
336 064b8f2a588d5e4f52ddefc00
64b8f2a588d5e4f52ddefc00- 1Restoring Windows Registryfalse
- 2Restoring system files, and installed applications.false
- 3Restoring Windows Registry, System Files, Restoring Installed Applications Both the options are correct.true
- 4All of the above are wrong.false
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 3. "Restoring Windows Registry, System Files, Restoring Installed Applications Both the options are correct."
Explanation :
You can restore the following if your computer crashes.
1. Restoring the Windows Registry
2. Restoring installed applications
Q: ______ is a small picture that represents a program, folder or program function and is displayed in the user's user interface when it is double-clicked.
326 064b915b523047f4c71cde258
64b915b523047f4c71cde258- 1Taskbarfalse
- 2Iconstrue
- 3Commandfalse
- 4System trayfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 2. "Icons"
Explanation :
1. Icons are small pictures that represent a program, folder, or program function and are displayed in the user's user interface when they are double-clicked.
Q: ______ in MM Word lets us send the same letter to different persons.
322 064b8f1252d3130f5753e4cab
64b8f1252d3130f5753e4cab- 1Mail Joinfalse
- 2Mail Pastefalse
- 3Mail Insertfalse
- 4Mail Mergetrue
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "Mail Merge"
Explanation :
1. Mail Merge is a facility in MS Word using multiple or different letters, invitation cards, and personal letters that can be sent to many people in a minimum time.
2. This feature is more useful in a situation when a user has to deliver a letter or invitation card to thousands of people.
3. We can understand mail merge with an example. Suppose we have to send a letter or card to 1000 different people with their names and addresses, in that case, we will have to copy and paste that letter 1000 times for all those people, and then a lot of time will be wasted. A database will be created which will contain the names, addresses and other information of all the recipients. This database file is in MS Excel or MS Access.
Q: Which of the following would you use to have the same display for all the slides in the presentation station?
280 064b8ef1b568e7ff594bcd989
64b8ef1b568e7ff594bcd989- 1Add Slide Optionfalse
- 2Outline Viewfalse
- 3Slide Layout Optionfalse
- 4Presentation Design Templatetrue
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "Presentation Design Template"
Explanation :
1. A presentation design template is used to ensure a uniform display of all the slides present in the presentation.
2. A presentation design template is a ready-made theme that includes text, images, shapes, and colours. Using templates, you can create a uniform look and feel for all slides.