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?