COMMON APPLICATION & MS OFFICE

1. Microsoft PowerPoint to add a header or footer to your handout, you can use.
(a) The title master (c) The handout master
(b) The slide master (d) All of above
Ans: [b]
2. Tabs stop position cannot be the following alignment?
(a) Decimal Alignment (c) Center Alignment
(b) Bar Alignment (d) Justify Alignment
Ans: [d]
3. Which feature is used to replace straight quotes with smart quotes as you type?
(a) Auto Correct as you type (c) Auto Change as you type
(b) Auto Ignore as you type (d) Auto Format as you type
Ans: [d]
4. What is place to the left of horizontal scroll bar?
(a) Indicators (c) Split buttons
(b) Tab stop buttons (d) View buttons
Ans: [d]
5. Communication using a modulated carrier to apply a data signal to a transmission medium in
analog form is

(a) Broad band networking (c) Base band networking

(b) Local area network (d) Modem
Ans: [a]
6. The Handout Master contains placeholders for all of the following except
(a) slide number (c) footer
(b) title (d) header
Ans: [c]
7. Which one is the most suitable reason to use Macro in MS Office (Word, Excel, PPT, etc) ?
(a) To Record Sound (c) To Record Mouse Move
(b) To automate repetative tasks (d) To Record Keystroke
Ans: (c)
8. How to use Format Painter multiple times?
(a) By Click on Lock Format Painter Icon (c) By Double Click on the Format Painter Icon
(b) Format Painter cannot be use multiple times (d) None of the above
Ans: [c]
9. What is gutter margin?
(a) Margin that is added to right margin when printing
(b) Margin that is added to the left margin when printing
(c) Margin that is added to the outside of the page when printing
(d) margin that is added to the binding side of page when printing
Ans: [d]
10. _________________ are identified by their addresses, we give them names (field names / variable
names) using words
(a) Memory Addresses (c) Data variables
(b) Memory variables (d) Memory Locations
Ans: [d]
11. Which of the following is a digital notebook application that automatically saves and
synchronizes your notes as you work?
(a) Notepad ++ (c) None of the mentioned options
(b) OneNote (d) Notepad
Ans: [b]
12. The given icon is used for which of the following AI assistant?
(a) Google assistant (c) Siri
(b) Alexa (d) Cortana
Ans: [d]
13. In the given worksheet, if you want to total the marks obtained in different subjects, then which
of the following formula should you use in the yellow highlighted cell?

(a) =Sum(B2:C6) (c) =Sum(A2:C6)

(b) =Sum(C2:C6) (d) =Sum(C1:C7)
Ans: [b]
14. Which of the following actions can not be performed in MS Excel?
(a) Changing the font colour (c) Changing the uppercase to lowercase
(b) Filtering data (d) Sorting data
Ans: [a]
15. Which of the following should you use for creating a multilevel sheet?

(a) 1 (c) 3
(b) 7 (d) 2
Ans: [c]
16. Which of the following features of MS Excel is used to limit the type of data that can be entered
in a cell?
(a) Conditional Formatting (c) Flash Fill
(b) Data Validation (d) Goal Seek
Ans: [b]
17. In Paint application, by which of the following angles can you not rotate an image by default?
(a) 180 degree (c) 90 degree left
(b) 90 degree right (d) 45 degree
Ans: [d]
18. Which of the following should you use to increase the indent?

(a) 4 (c) 8
(b) 6 (d) 5
Ans: [c]
19. in which of the following Microsoft Office applications can you convert the text as shown in the
figure A into figure B, just with a click?
Figure - A
LOREM IPSUM IS SIMPLY DUMMY TEXT OF THE PRINTING AND TYPESETTING INDUSTRY.
LOREM IPSUM HAS BEEN THE INDUSTRY’S STANDARD DUMMY TEXT EVER SINCE THE 1500S,
WHEN AN UNKNOWN PRINTER TOOK A GALLERY OF TYPE AND SCRAMBLED IT TO MAKE A TYPE
SPECIMEN BOOK, IT HAS SURVIVED NOT ONLY FIVE CENTURIES, BUT ALSO THE LEAP INTO
ELCTRONIC TYPESETTING REMAINING ESSENTIALLY UNCHANGED.
lorem ipsum is simply dummy text of the printing and typesetting industry. lorem ipsum has been
the industry’s standard dummy text ever since the 1500s, when an unknown printer took a gallery
of type and scrambled it to make a type specimen book, it has survived not only five centuries, but
also the leap into elctronic typesetting remaining essentially unchanged.
Figure – B

(a) MS Word (c) MS PowerPoint

(b) MS Access (d) MS Excel
Ans: [a]
20. Which of the following will you use if you want to write anything on the slide while you are
running your presentation in MS Power Point?
(a) Highlighter (c) Laser Pointer
(b) Pen Pointer (d) Arrow
Ans: [a]
21. Jacob wants to write the thesis of his research work for submission to a journal, which of the
following applications should he use if he wants to add Table of Content, Bibliography etc. to the
document?
(a) MS Access (c) MS Excel
(b) Notepad (d) MS Word
Ans: [d]
22. In Notepad application, which of the following type of formatting is not possible?
(a) Italic (c) None of the mentioned options

(b) Underline (d) Bold

Ans: [c]
23. In Gmail, which of the following options is used to postpone emails and temporarily remove
them from your inbox until you need them?
(a) Important (c) Snooze
(b) SPAM (d) Star
Ans: [c]
24. The given icon represents which of the following?

(a) Search engine (c) Operating system

(b) None of the mentioned options (d) Browser
Ans: [d]
26. In MS Excel, by default a fraction is always treated as –
(a) Ratio (c) Text
(b) Decimal (d) Date
Ans: [c]
27. Which of the following actions can be performed by using Microsoft OneNote application?
1. Take handwritten notes or draw your ideas.
2. Use highlighting and tags for easy follow-up.
3. Access your notebooks from any device.
(a) 1 and 3 (c) All 1, 2 and 3
(b) 2 and 3 (d) 1 and 2
Ans: [c]
28. In Google meet, which of the following actions can you not perform?
(a) Record a video meeting (c) Mute all the participants at the same time
(b) Switch on the camera of other participants (d) Sending an invite to multiple participants
Ans: [b]

29. In the given data sheet if you have to find the average marks scored by the student in all the
subjects, then which of the following formula should you write in the cell highlighted in yellow
colour?
(a) =Sum(C2:C6)/Count(D2:D6) (c) =Sum(C2:C6)/Count(C2:C6)
(b) =Sum(D2:D6)/Count(D2:D6) (d) =Sum(D2:D6)/Count(D2:D6)
Ans: [b]
30. If you have to separate the first name and the last name from a list of full names given (as per
the image), then which of the following options can be used to serve the purpose?

(a) Filter (c) Flash Fill

(b) Sort (d) Slicer
Ans: [c]
31. Google search engine can be used for searching the results based on –
1. Voice command
2. Images
3. Phrases
(a) All 1, 2 and 3 (c) 2 and 3
(b) 1 and 3 (d) 1 and 2
Ans: [a]
32. Which of the following applications can be used for virtual meetings?
(a) Facebook (c) Whatsapp
(b) Google drive (d) Google classroom
Ans: [d]
33. Which of the following application can be used for remotely sharing screen of your
laptop/desktop?
1. Whatsapp Web
2. Skype
3. Googl Meet
(a) 1 and 2 (c) 1 and 3
(b) 2 and 3 (d) All 1, 2 and 3
Ans: [d]