McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Bachelor of Arts in Economics (BA Economics) .
| 101. |
An excel workbook is a collection of |
| A. | workbooks |
| B. | worksheets |
| C. | charts |
| D. | none of above |
| Answer» B. worksheets | |
| 102. |
Excel Probably considers the cell entry January 1, 2000 to be a |
| A. | label |
| B. | value |
| C. | formula |
| D. | text string |
| Answer» B. value | |
| 103. |
You can enter which type of data into worksheet cells? |
| A. | labels, values, and formulas |
| B. | labels and values but not formulas |
| C. | values and formulas but not labels |
| D. | formulas only. |
| Answer» A. labels, values, and formulas | |
| 104. |
If you want to show the sector wise contribution to GDP, which chart you will prefer |
| A. | pie chart |
| B. | line chart |
| C. | column chart |
| D. | area chart |
| Answer» A. pie chart | |
| 105. |
The operator to estimate variance is |
| A. | =covar () |
| B. | =var () |
| C. | =stdev () |
| D. | =kurt () |
| Answer» B. =var () | |
| 106. |
The operator to estimate mean is |
| A. | =covar () |
| B. | = mode () |
| C. | =average () |
| D. | =median () |
| Answer» C. =average () | |
| 107. |
The operator to estimate standard deviation is |
| A. | =covar () |
| B. | =var () |
| C. | = stdev () |
| D. | =median () |
| Answer» C. = stdev () | |
| 108. |
In Excel spread sheet, the currently active cell is indicated by |
| A. | cell pointer |
| B. | formula bar |
| C. | toolbar |
| D. | none of above |
| Answer» A. cell pointer | |
| 109. |
While estimating descriptive statistic using analysis toolpak, we need to check |
| A. | summary statistics |
| B. | correlation |
| C. | anova |
| D. | covariance |
| Answer» A. summary statistics | |
| 110. |
Quadratic trend line is polynomial of order ___ |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» B. 2 | |
| 111. |
Cubic trend line is polynomial of order ___ |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» C. 3 | |
| 112. |
Which among the following is used as model selection criteria for trend lines? |
| A. | correlation coefficient |
| B. | constant |
| C. | slope |
| D. | r2 |
| Answer» D. r2 | |
| 113. |
Which among the following is not a descriptive statistics? |
| A. | mean |
| B. | regression |
| C. | median |
| D. | variance |
| Answer» B. regression | |
| 114. |
Which trend line you will choose if line plot is roughly a straight line? |
| A. | linear |
| B. | exponential |
| C. | cubic |
| D. | quadratic |
| Answer» A. linear | |
| 115. |
Which tab provides the option to set chart and axis titles? |
| A. | insert |
| B. | layout |
| C. | view |
| D. | design |
| Answer» B. layout | |
| 116. |
Which tab provides various styles of inserted chart? |
| A. | insert |
| B. | layout |
| C. | view |
| D. | design |
| Answer» D. design | |
| 117. |
Which of the following formula is not entered correctly? |
| A. | =10+5 |
| B. | =5*9 |
| C. | 2+4 |
| D. | =10/2 |
| Answer» C. 2+4 | |
| 118. |
________is used to study the relationship between variables. |
| A. | pie chart |
| B. | line chart |
| C. | column chart |
| D. | scatter plot |
| Answer» D. scatter plot | |
| 119. |
In line chart years are shown on |
| A. | vertical axis |
| B. | horizontal axis |
| C. | title |
| D. | none of the above |
| Answer» B. horizontal axis | |
| 120. |
_______ refers to displaying only the rows that meet certain conditions and the remaining rows are hidden |
| A. | filtering |
| B. | sorting |
| C. | numbering |
| D. | formatting |
| Answer» A. filtering | |
| 121. |
______is used to display values in ascending or descending order. |
| A. | filtering |
| B. | sorting |
| C. | numbering |
| D. | formatting |
| Answer» B. sorting | |
| 122. |
Formulas built-in into a spreadsheet are called _______ |
| A. | formulas |
| B. | conditions |
| C. | functions |
| D. | labels |
| Answer» C. functions | |
| 123. |
The intersection of a raw and column is known as _____ |
| A. | cell |
| B. | chart |
| C. | formula |
| D. | value |
| Answer» A. cell | |
| 124. |
Which of the following is a programme used to create presentations? |
| A. | word |
| B. | excel |
| C. | powerpoint |
| D. | access |
| Answer» C. powerpoint | |
| 125. |
______ helps to preview the slides in thumbnail form? |
| A. | title bar |
| B. | status bar |
| C. | menu bar |
| D. | slide sorter view |
| Answer» D. slide sorter view | |
| 126. |
_________ are already created presentation on different topics. |
| A. | templates |
| B. | images |
| C. | video |
| D. | design |
| Answer» A. templates | |
| 127. |
The Background style of a power point presentation is known as |
| A. | animation |
| B. | theme |
| C. | transition |
| D. | effects |
| Answer» B. theme | |
| 128. |
The title slide consists of |
| A. | title place holder |
| B. | subtitle place holder |
| C. | both title and subtitle place holders |
| D. | none o the above |
| Answer» C. both title and subtitle place holders | |
| 129. |
Which of the following is not an option to format the theme of the presentation? |
| A. | colours |
| B. | fonts |
| C. | effects |
| D. | table |
| Answer» D. table | |
| 130. |
Which of the following is not an option of transition? |
| A. | wipes |
| B. | push and cover |
| C. | random |
| D. | oriel |
| Answer» D. oriel | |
| 131. |
Which key on the keyboard can be used to view the slide show? |
| A. | f1 |
| B. | f2 |
| C. | f5 |
| D. | f10 |
| Answer» C. f5 | |
| 132. |
Which tab is not available on left panel when you open a presentation? |
| A. | outline |
| B. | slides |
| C. | notes |
| D. | all of above |
| Answer» C. notes | |
| 133. |
The arrangement of elements such as title and subtitle text, pictures, tables etc. is called |
| A. | layout |
| B. | presentation |
| C. | design |
| D. | scheme |
| Answer» A. layout | |
| 134. |
After choosing a predefined template, which option has to be chosen to change the background colour? |
| A. | design template |
| B. | colour scheme |
| C. | animation scheme |
| D. | colour effects |
| Answer» D. colour effects | |
| 135. |
Fly in is predefined _____________ |
| A. | design template |
| B. | colour scheme |
| C. | animation scheme |
| D. | none of these |
| Answer» B. colour scheme | |
| 136. |
Animation schemes can be applied to ___________in the presentation |
| A. | all slides |
| B. | selected slides |
| C. | current slide |
| D. | all of the above |
| Answer» C. current slide | |
| 137. |
To insert new slide in the presentation, we can choose |
| A. | ctrl+m |
| B. | ctrl+n |
| C. | ctrl+o |
| D. | ctrl+f |
| Answer» D. ctrl+f | |
| 138. |
In normal view, this tab displays the content of each slide |
| A. | slides |
| B. | view |
| C. | sort |
| D. | outline |
| Answer» B. view | |
| 139. |
Which is the menu to create text box on a slide |
| A. | view->text box |
| B. | tools->text box |
| C. | insert->text box |
| D. | format->text box |
| Answer» D. format->text box | |
| 140. |
A new presentation can be created from |
| A. | blank presentation |
| B. | from existing presentation |
| C. | from design template |
| D. | all of above |
| Answer» C. from design template | |
| 141. |
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. | text box |
| Answer» D. text box | |
| 142. |
What PowerPoint feature will you use to apply motion effects in between slide exits and another enters? |
| A. | slide transition |
| B. | slide design |
| C. | animation objects |
| D. | text box |
| Answer» C. animation objects | |
| 143. |
The selected design template can be applied to |
| A. | to the current slide only |
| B. | to all the slides |
| C. | to all the new presentations you create |
| D. | all of the above |
| Answer» A. to the current slide only | |
| 144. |
From which menu you can access picture, chart, smart card and movie |
| A. | home |
| B. | insert |
| C. | design |
| D. | view |
| Answer» B. insert | |
| 145. |
To insert a hyperlink in a slide |
| A. | insert>>hyperlink |
| B. | ctrl+k |
| C. | view>>hyperlink |
| D. | both a & b |
| Answer» D. both a & b | |
| 146. |
Which of the following font effect is not available PowerPoint font dialog box? |
| A. | underline |
| B. | shadow |
| C. | emboss |
| D. | strikethrough |
| Answer» C. emboss | |
| 147. |
The default Page set up orientation of slide in PowerPoint is |
| A. | vertical |
| B. | landscape |
| C. | portrait |
| D. | none of above |
| Answer» B. landscape | |
| 148. |
Objects on the slide that hold text are called |
| A. | placeholders |
| B. | object holders |
| C. | auto layouts |
| D. | text holders |
| Answer» A. placeholders | |
| 149. |
Which command brings you to the first slide in your presentation? |
| A. | next slide button |
| B. | page up |
| C. | ctrl+home |
| D. | ctrl+end |
| Answer» C. ctrl+home | |
| 150. |
Which of the following can you use to add times to the slides in a presentation? |
| A. | slide show menu |
| B. | rehearse timings button |
| C. | slide transition button |
| D. | all of the above |
| Answer» B. rehearse timings button | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.