![Mcqmate logo](https://mcqmate.com/images/logos/logo-black.png)
![Mcqmate logo](https://mcqmate.com/images/logos/logo-white.png)
McqMate
101. |
You can auto fit the width of column by |
A. | double clicking on the column name on column header |
B. | double click on the cell pointer in worksheet |
C. | double clicking on column right border on column header |
D. | double clicking on the column left border of column header |
Answer» C. double clicking on column right border on column header |
102. |
Long text can be broken down into many lines within a cell. You can do this through |
A. | wrap text in format >> cells |
B. | justify in edit >> cells |
C. | text wrapping in format >> cells, layout tab |
D. | all of above |
Answer» A. wrap text in format >> cells |
103. |
MS Excel provides the default value for step in Fill Series dialog box |
A. | 0 |
B. | 1 |
C. | 5 |
D. | 10 |
Answer» B. 1 |
104. |
Ctrl + D shortcut key in Excel will |
A. | open the font dialog box |
B. | apply double underline for the active cell |
C. | fill down in the selection |
D. | none of above |
Answer» C. fill down in the selection |
105. |
The short cut key Ctrl + R is used in Excel to |
A. | right align the content of cell |
B. | remove the cell contents of selected cells |
C. | fill the selection with active cells to the right |
D. | none of above |
Answer» C. fill the selection with active cells to the right |
106. |
The command Edit >> Fill Across Worksheet is active only when |
A. | one sheet is selected |
B. | when many sheets are selected |
C. | when no sheet is selected |
D. | none of above |
Answer» B. when many sheets are selected |
107. |
Which of the following series type is not valid for Fill Series dialog box? |
A. | linear |
B. | growth |
C. | auto fill |
D. | time |
Answer» D. time |
108. |
Which of the following you can paste selectively using Paste Special command? |
A. | validation |
B. | formats |
C. | formulas |
D. | all of above |
Answer» D. all of above |
109. |
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? |
A. | square |
B. | percentage |
C. | goal seek |
D. | divide |
Answer» D. divide |
110. |
Edit >> Delete command |
A. | deletes the content of a cell |
B. | deletes formats of cell |
C. | deletes the comment of cell |
D. | deletes selected cells |
Answer» D. deletes selected cells |
111. |
To remove the content of selected cells you must issue ______ command |
A. | edit >> delete |
B. | edit >> clear >> contents |
C. | edit >> clear >> all |
D. | data >> delete |
Answer» B. edit >> clear >> contents |
112. |
The Delete key of keyboard is assigned to which command in Excel? |
A. | edit >> clear >> contents |
B. | edit >> clear >> all |
C. | edit >> delete |
D. | all of above |
Answer» A. edit >> clear >> contents |
113. |
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must |
A. | from edit menu choose clear and then formats |
B. | from edit menu choose delete |
C. | click on remove formatting tool on standard toolbar |
D. | double click the format painter and then press esc key in keyboard |
Answer» A. from edit menu choose clear and then formats |
114. |
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? |
A. | right click on sheet tab of third sheet and choose delete from the context menu |
B. | click on sheet 3 and from edit menu choose delete |
C. | both of above |
D. | none of above |
Answer» A. right click on sheet tab of third sheet and choose delete from the context menu |
115. |
Which of the following action removes a sheet from workbook? |
A. | select the sheet, then choose edit >> delete sheet |
B. | select the sheet then choose format >> sheet >> hide |
C. | both of above |
D. | none of above |
Answer» A. select the sheet, then choose edit >> delete sheet |
116. |
While finding and replacing some data in Excel, which of the following statement is valid? |
A. | you can find and replace within the sheet or workbook |
B. | excel does not have option to match case for find |
C. | both are valid |
D. | none are valid |
Answer» A. you can find and replace within the sheet or workbook |
117. |
Which of the following is not true about Find and Replace in Excel |
A. | you can search for bold and replace with italics |
B. | you can decide whether to look for the whole word or not |
C. | you can search in formula too |
D. | you can search by rows or columns or sheets |
Answer» D. you can search by rows or columns or sheets |
118. |
You can move a sheet from one workbook into new book by |
A. | from edit menu choose move or copy sheet, mark the create a copy and click ok |
B. | from edit menu choose move of copy then choose (move to end) and click ok |
C. | from edit menu choose move or copy then select (new book) from to book list and click ok |
D. | none of above |
Answer» C. from edit menu choose move or copy then select (new book) from to book list and click ok |
119. |
What is the short cut key to replace a data with another in sheet? |
A. | ctrl + r |
B. | ctrl + shift + r |
C. | ctrl + h |
D. | ctrl + f |
Answer» C. ctrl + h |
120. |
To start Microsoft PowerPoint application |
A. | click on start >> programs >> all programs >> microsoft powerpoint |
B. | hit ctrl + r then type ppoint.exe and enter |
C. | click start >> run then type power point then press enter |
D. | all of above |
Answer» D. all of above |
121. |
Which tab is not available on left panel when you open a presentation? |
A. | outline |
B. | slides |
C. | notes |
D. | all of above are available |
Answer» C. notes |
122. |
Which of the following statements is not true? |
A. | you can type text directly into a powerpoint slide but typing in text box is more convenient. |
B. | from insert menu choose picture and then from file to insert your images into slides. |
C. | you can display a powerpoint presentation in normal, slide sorter or slide show view. |
D. | you can show or hide task pane from view >> toolbars |
Answer» A. you can type text directly into a powerpoint slide but typing in text box is more convenient. |
123. |
Which of the following section does not exist in a slide layout? |
A. | titles |
B. | lists |
C. | charts |
D. | animations |
Answer» D. animations |
124. |
PowerPoint presentations are widely used as |
A. | note outlines for teachers |
B. | project presentations by students |
C. | communication of planning |
D. | all of above |
Answer» D. all of above |
125. |
_______ controls all the main slide control tasks for your presentation. |
A. | task pane |
B. | task bar |
C. | control panel |
D. | none of above |
Answer» A. task pane |
126. |
Which of the following cannot be toggled from View >> Toolbars? |
A. | control toolbox |
B. | slides |
C. | revisions |
D. | reviewing |
Answer» B. slides |
127. |
Which of the following pane is not available in Task Pane? |
A. | getting started |
B. | clip art |
C. | word art |
D. | search results |
Answer» C. word art |
128. |
Which of the following pane is NOT available in Task Pane? |
A. | slide design |
B. | master slide |
C. | slide layout |
D. | slide transition |
Answer» B. master slide |
129. |
A new presentation can be created from |
A. | blank presentation |
B. | from existing presentation |
C. | from design template |
D. | all of above |
Answer» D. all of above |
130. |
In slide layout panel how many layouts are available for text layout by default? |
A. | 4 |
B. | 7 |
C. | 12 |
D. | none of above |
Answer» A. 4 |
131. |
Which of the following statement is false? |
A. | if you choose to select from one of the pre-made slide layouts, you can change the positioning |
B. | if you choose to select from the pre-made slide layouts, you cannot delete the objects in the layout. |
C. | blank slide is at the top of the ‘content layouts’ area in the slide layout panel. |
D. | all of above are false statements |
Answer» B. if you choose to select from the pre-made slide layouts, you cannot delete the objects in the layout. |
132. |
What lets you to create new presentation by selecting ready-made font color and graphics effects? |
A. | presentation template |
B. | master slide |
C. | design template |
D. | animation scheme |
Answer» C. design template |
133. |
Which command will you use in PowerPoint if you need to change the color of different objects without changing content? |
A. | design template |
B. | colour scheme |
C. | font colour |
D. | object colour |
Answer» B. colour scheme |
134. |
What PowerPoint feature will you use to apply motion effects to different objects of a slide? |
A. | slide transition |
B. | slide design |
C. | animation objects |
D. | animation scheme |
Answer» D. animation scheme |
135. |
What feature will you use to apply motion effects in between a slide exits and another enters? |
A. | slide transition |
B. | slide design |
C. | animation objects |
D. | animation scheme |
Answer» A. slide transition |
136. |
The selected design template can be applied |
A. | to current slide only |
B. | to all the slides |
C. | to all the new presentation you create |
D. | all of above |
Answer» D. all of above |
137. |
The difference between Slide Design and Auto Content Wizard is |
A. | both are same |
B. | auto content wizard is just the wizard version of slide design |
C. | slide design does not provide sample content but auto content wizard provides sample content too! |
D. | slide design asks your choice in steps but auto content wizard does not let |
Answer» C. slide design does not provide sample content but auto content wizard provides sample content too! |
138. |
In which menu can you find features like Slide Design, Slide Layout etc.? |
A. | insert menu |
B. | format menu |
C. | tools menu |
D. | slide show menu |
Answer» B. format menu |
139. |
Which menu provides you options like Animation Scheme, custom Animation, Slide Transition? |
A. | insert menu |
B. | format menu |
C. | tools menu |
D. | slide show menu |
Answer» D. slide show menu |
140. |
What is the extension of power point file? |
A. | .pmt |
B. | .pnt |
C. | .ppt |
D. | |
Answer» C. .ppt |
141. |
How many steps are there between Start and Finish in AutoContent Wizard? |
A. | 3 |
B. | 4 |
C. | 5 |
D. | 6 |
Answer» A. 3 |
142. |
Which short cut key inserts a new slide in current presentation? |
A. | ctrl+n |
B. | ctrl+m |
C. | ctrl+s |
D. | all of above |
Answer» B. ctrl+m |
143. |
What happens if you select first and second slide and then click on New Slide button on toolbar? |
A. | a new slide is inserted as first slide in presentation |
B. | a new slide is inserted as second slide in presentation |
C. | a new slide is inserted as third slide in presentation |
D. | none of above |
Answer» C. a new slide is inserted as third slide in presentation |
144. |
Which of the following method can insert a new slide in current presentation? |
A. | right click on the slide panel and choose new slide |
B. | from insert menu choose new slide |
C. | click on new slide button on toolbar |
D. | all of above |
Answer» D. all of above |
145. |
Which of the following is not a part of Slide Design |
A. | design template |
B. | colour scheme |
C. | animation scheme |
D. | slide layout |
Answer» D. slide layout |
146. |
What is the best way to create another copy of a slide? |
A. | click the slide then press ctrl+a and paste in new slide |
B. | from insert menu choose duplicate slide |
C. | redo everything on a new slide that you had done on previous slide |
D. | none of above |
Answer» B. from insert menu choose duplicate slide |
147. |
From which menu you can access Picture, Test Box, and Chart etc? |
A. | file |
B. | edit |
C. | insert |
D. | view |
Answer» C. insert |
148. |
If you want to insert some slides from other presentation into current one choose |
A. | from insert menu choose slides from files |
B. | from insert menu choose slides from presentation |
C. | from insert menu choose slides |
D. | none of above |
Answer» A. from insert menu choose slides from files |
149. |
What are the three options available in Insert >> Picture menu? |
A. | clipart, pictures, shapes |
B. | clipart, from file, shapes |
C. | clipart, from files, autoshapes |
D. | clipart, pictures, autoshapes |
Answer» C. clipart, from files, autoshapes |
150. |
To insert slide numbers |
A. | insert a text box and select insert >> page number |
B. | insert a textbox and select insert >> number >> page number |
C. | choose insert >> slide number |
D. | insert a new text box and select insert >> slide number |
Answer» D. insert a new text box and select insert >> slide number |
151. |
In a PowerPoint presentation |
A. | sound clips can be inserted but not movie clips |
B. | movie clips can be inserted but not sound clips |
C. | both cannot be inserted |
D. | both can be inserted |
Answer» D. both can be inserted |
152. |
To insert a hyperlink in a slide |
A. | choose insert >> hyperlink |
B. | press ctrl + k |
C. | hyperlinks can’t be inserted in slides |
D. | both a & b |
Answer» D. both a & b |
153. |
List Box and Text box |
A. | are some other than that in a list box the bullets are enabled |
B. | are different. list boxes are used to present lists and can’t be created with text boxes. |
C. | both of above |
D. | none of above |
Answer» A. are some other than that in a list box the bullets are enabled |
154. |
Which of the following statement is true |
A. | you can insert text boxes from drawing toolbar in powerpoint |
B. | you cannot insert text boxes from drawing toolbar in powerpoint |
C. | text boxes are provides when you choose a layout and can’t be inserted afterwards |
D. | none of above |
Answer» A. you can insert text boxes from drawing toolbar in powerpoint |
155. |
When you delete a text box object from a slide in PowerPoint Presentation |
A. | the object is deleted but text box and the text inside is left on the slide |
B. | the text box is deleted and the text is pasted on the slide |
C. | the text box and text both are deleted |
D. | none of above |
Answer» B. the text box is deleted and the text is pasted on the slide |
156. |
Which of the following font effect is not available in PowerPoint Font dialog box? |
A. | underline |
B. | shadow |
C. | emboss |
D. | strikethrough |
Answer» D. strikethrough |
157. |
What happens if you edited an image inserted in Power Point? |
A. | the original file that was inserted is not changed |
B. | the original file that was inserted is changed |
C. | the original file is changed when you save presentation |
D. | none of above |
Answer» A. the original file that was inserted is not changed |
158. |
If you select Insert >> Picture >> From File |
A. | you can insert pictures and clipart |
B. | you can insert clipart only |
C. | you can insert pictures only |
D. | none of above |
Answer» C. you can insert pictures only |
159. |
The effect applied to display when slides changes in slide show view is |
A. | slide animation |
B. | custom animation |
C. | custom transition |
D. | slide transition |
Answer» D. slide transition |
160. |
To start slide show of a presentation |
A. | hit f5 key |
B. | from slide show menu choose view show option |
C. | from slide show menu choose rehearse timing |
D. | both a & b |
Answer» D. both a & b |
161. |
Which file format can be added to a PowerPoint show? |
A. | .jpg |
B. | .giv |
C. | .wav |
D. | all of the above |
Answer» D. all of the above |
162. |
In Microsoft PowerPoint two kind of sound effects files that can be added to the presentation are |
A. | .wav files and .mid files |
B. | .wav files and .gif files |
C. | .wav files and .jpg files |
D. | .jpg files and .gif files |
Answer» A. .wav files and .mid files |
163. |
What is a motion path? |
A. | a type of animation entrance effect |
B. | a method of advancing slides |
C. | a method of moving items on a slide |
D. | all of the above |
Answer» C. a method of moving items on a slide |
164. |
What is a slide-title master pair? |
A. | the title area and text area of a specific slide |
B. | a slide master and title master merged into a single slide |
C. | a slide master and title master for a specific design template |
D. | all of above |
Answer» C. a slide master and title master for a specific design template |
165. |
Which of the following should you use if you want all the slide in the presentation to have the same “look”? |
A. | the slide layout option |
B. | add a slide option |
C. | outline view |
D. | a presentation design template |
Answer» D. a presentation design template |
166. |
In the context of animations, what is a trigger? |
A. | an action button that advances to the next slide |
B. | an item on the slide that performs an action when clicked |
C. | the name of a motion path |
D. | all of above |
Answer» B. an item on the slide that performs an action when clicked |
167. |
If you have a PowerPoint show you created and want to send using email to another person you can add the show to your email message as a (an) |
A. | inclusion |
B. | attachment |
C. | reply |
D. | forward |
Answer» B. attachment |
168. |
In order to edit a chart, you can |
A. | triple click the chart object |
B. | click and drag the chart object |
C. | double click the chart object |
D. | click the chart object |
Answer» C. double click the chart object |
169. |
To exit the PowerPoint |
A. | click the application minimize button |
B. | click the document close button |
C. | double click the applications control menu icon |
D. | double click the document control menu icon |
Answer» C. double click the applications control menu icon |
170. |
special effects used to introduce slides in a presentation are called |
A. | effects |
B. | custom animations |
C. | transitions |
D. | present animations |
Answer» C. transitions |
171. |
What is the term used when you press and hold the left mouse key and more the mouse around the slide? |
A. | highlighting |
B. | dragging |
C. | selecting |
D. | moving |
Answer» B. dragging |
172. |
Which of the following toolbars provide different options in various master views? |
A. | common tasks toolbar |
B. | drawing toolbar |
C. | formatting toolbar |
D. | standard toolbar |
Answer» A. common tasks toolbar |
173. |
In Ms Excel -------------- are text entries |
A. | labels |
B. | tupple |
C. | attributes |
D. | character |
Answer» A. labels |
174. |
Which of the following is not a financial function in Excel? |
A. | pv |
B. | count |
C. | pmt |
D. | rate |
Answer» B. count |
175. |
Which of the following is not a database function in excel? |
A. | dmax |
B. | dmin |
C. | dcount |
D. | ddb |
Answer» D. ddb |
176. |
In Excel, we can use --------- function to calculate EMI of loan. |
A. | ipmt |
B. | pmt |
C. | goal seek |
D. | correl |
Answer» B. pmt |
177. |
Which of the following is not a statistical function in excel? |
A. | average |
B. | correl |
C. | stdev |
D. | sum |
Answer» D. sum |
178. |
Which of the following coming under “What-If –Analysis” in excel? |
A. | goal seek |
B. | scenario manager |
C. | data table |
D. | all the above |
Answer» D. all the above |
179. |
---------- is a method to find a specific value of cell by adjusting the value of another cell. |
A. | goal seek |
B. | scenario manager |
C. | data table |
D. | macro |
Answer» A. goal seek |
180. |
Which of the following is not a logical function in excel? |
A. | and |
B. | false |
C. | or |
D. | none of these |
Answer» D. none of these |
181. |
By default an excel work book displays--------- work sheets |
A. | 1 |
B. | 2 |
C. | 3 |
D. | 5 |
Answer» C. 3 |
182. |
“Auto fill” is a unique feature of: |
A. | ms word |
B. | ms excel |
C. | ms powerpoint |
D. | all of these |
Answer» B. ms excel |
183. |
Which of the following is not a basic mathematical function in Excel? |
A. | addition |
B. | division |
C. | exponential |
D. | none of these |
Answer» D. none of these |
184. |
In Excel row’s heading is known as |
A. | field |
B. | tupple |
C. | domain |
D. | attributes |
Answer» B. tupple |
185. |
In email, addresses separate the user name from the ISP using the __________ symbol. |
A. | & |
B. | @ |
C. | % |
D. | $ |
Answer» B. @ |
186. |
The mail server as defined in the text uses the __________ protocol. |
A. | http |
B. | ftp |
C. | pop |
D. | smtp |
Answer» C. pop |
187. |
News servers utilize __________ to distribute documents to readers. |
A. | nntp |
B. | news |
C. | http |
D. | ftp |
Answer» A. nntp |
188. |
To search FTP archives for a file, you should use the __________ tool. |
A. | gopher |
B. | jughead |
C. | archie |
D. | jalopy |
Answer» B. jughead |
189. |
__________ is often referred to as “the CB of the Internet.” |
A. | irc |
B. | ftp |
C. | |
D. | http |
Answer» A. irc |
190. |
Discussion groups may have a __________ who monitors the postings and enforces the site’s rules. |
A. | judge |
B. | sysop |
C. | narrator |
D. | censor |
Answer» B. sysop |
191. |
A message with replies on a newsgroup is often called a __________. |
A. | post |
B. | list |
C. | thread |
D. | comment |
Answer» C. thread |
192. |
Internet is governed by_____________. |
A. | microsoft corporation. |
B. | adobe. |
C. | dish net. |
D. | none of these. |
Answer» D. none of these. |
193. |
Which of the following is not a web browser? |
A. | internet browser |
B. | netscape communicator. |
C. | netscape navigator |
D. | adobe pagemaker. |
Answer» D. adobe pagemaker. |
194. |
HTML means_______. |
A. | hyper text mark-up language. |
B. | hyper testing mark-up language. |
C. | hardware text mark-up language. |
D. | hyper testing mapping language. |
Answer» A. hyper text mark-up language. |
195. |
URL stands for____________. |
A. | uniform resource locator. |
B. | uniform resource ladder. |
C. | uniform resource locator. |
D. | uniform reserved locator. |
Answer» C. uniform resource locator. |
196. |
WWW means_______________. |
A. | world wide wan. |
B. | world wide web. |
C. | world wan web. |
D. | world wan web. |
Answer» B. world wide web. |
197. |
WWW uses the following protocol? |
A. | http. |
B. | ftp |
C. | wwwc |
D. | smtp. |
Answer» A. http. |
198. |
FTP is acronym of____________. |
A. | file transfer protocol |
B. | file transmission protocol. |
C. | free transfer protocol. |
D. | file terminal protocol. |
Answer» A. file transfer protocol |
199. |
Website is a collection of__________. |
A. | audio files. |
B. | video files. |
C. | image files. |
D. | html files. |
Answer» D. html files. |
200. |
When you open Internet, the first page is referred to as_________. |
A. | master page. |
B. | home page. |
C. | first page. |
D. | title page. |
Answer» B. home page. |
Done Reading?