Computer Applications For Economic Analysis Set 5
On This Page
This set of Computer Applications for Economic Analysis Multiple Choice Questions & Answers (MCQs) focuses on Computer Applications For Economic Analysis Set 5
Q1 | An excel workbook is a collection of
- workbooks
- worksheets
- charts
- none of above
Q2 | Excel Probably considers the cell entry January 1, 2000 to be a
- label
- value
- formula
- text string
Q3 | You can enter which type of data into worksheet cells?
- labels, values, and formulas
- labels and values but not formulas
- values and formulas but not labels
- formulas only.
Q4 | If you want to show the sector wise contribution to GDP, which chart you will prefer
- pie chart
- line chart
- column chart
- area chart
Q5 | The operator to estimate variance is
- 0
- 0
- 0
- 0
Q6 | The operator to estimate mean is
- 0
- 0
- 0
- 0
Q7 | The operator to estimate standard deviation is
- 0
- 0
- 0
- 0
Q8 | In Excel spread sheet, the currently active cell is indicated by
- cell pointer
- formula bar
- toolbar
- none of above
Q9 | While estimating descriptive statistic using analysis toolpak, we need to check
- summary statistics
- correlation
- anova
- covariance
Q10 | Quadratic trend line is polynomial of order ___
- 1
- 2
- 3
- 4
Q11 | Cubic trend line is polynomial of order ___
- 1
- 2
- 3
- 4
Q12 | Which among the following is used as model selection criteria for trend lines?
- correlation coefficient
- constant
- slope
- r2
Q13 | Which among the following is not a descriptive statistics?
- mean
- regression
- median
- variance
Q14 | Which trend line you will choose if line plot is roughly a straight line?
- linear
- exponential
- cubic
- quadratic
Q15 | Which tab provides the option to set chart and axis titles?
- insert
- layout
- view
- design
Q16 | Which tab provides various styles of inserted chart?
- insert
- layout
- view
- design
Q17 | Which of the following formula is not entered correctly?
- 15
- 45
- 2+4
- 5
Q18 | ________is used to study the relationship between variables.
- pie chart
- line chart
- column chart
- scatter plot
Q19 | In line chart years are shown on
- vertical axis
- horizontal axis
- title
- none of the above
Q20 | _______ refers to displaying only the rows that meet certain conditions and the remainingrows are hidden
- filtering
- sorting
- numbering
- formatting
Q21 | ______is used to display values in ascending or descending order.
- filtering
- sorting
- numbering
- formatting
Q22 | Formulas built-in into a spreadsheet are called _______
- formulas
- conditions
- functions
- labels
Q23 | The intersection of a raw and column is known as _____
- cell
- chart
- formula
- value
Q24 | Which of the following is a programme used to create presentations?
- word
- excel
- powerpoint
- access
Q25 | ______ helps to preview the slides in thumbnail form?
- title bar
- status bar
- menu bar
- slide sorter view