Top 150+ Solved Computer Applications for Economic Analysis MCQ Questions Answer
Q. The operator to estimate standard deviation is
a. =covar ()
b. =var ()
c. = stdev ()
d. =median ()
Q. In Excel spread sheet, the currently active cell is indicated by
a. cell pointer
b. formula bar
c. toolbar
d. none of above
Q. While estimating descriptive statistic using analysis toolpak, we need to check
a. summary statistics
b. correlation
c. anova
d. covariance
Q. Which among the following is used as model selection criteria for trend lines?
a. correlation coefficient
b. constant
c. slope
d. r2
Q. Which among the following is not a descriptive statistics?
a. mean
b. regression
c. median
d. variance
Q. Which trend line you will choose if line plot is roughly a straight line?
a. linear
b. exponential
c. cubic
d. quadratic
Q. Which tab provides the option to set chart and axis titles?
a. insert
b. layout
c. view
d. design
Q. ________is used to study the relationship between variables.
a. pie chart
b. line chart
c. column chart
d. scatter plot
Q. In line chart years are shown on
a. vertical axis
b. horizontal axis
c. title
d. none of the above
Q. _______ refers to displaying only the rows that meet certain conditions and the remainingrows are hidden
a. filtering
b. sorting
c. numbering
d. formatting
Q. ______is used to display values in ascending or descending order.
a. filtering
b. sorting
c. numbering
d. formatting