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