Top 150+ Solved Computer Applications for Economic Analysis MCQ Questions Answer

From 91 to 105 of 166

Q. Which of the following is forecasting tool?

a. moving average

b. variance

c. linear trend line

d. cubic trend line

  • b. variance

Q. The function library is available under _______tab.

a. formula

b. insert

c. data

d. review

  • a. formula

Q. __________ means the structure or order of the elements of a formula

a. operator

b. cell

c. formula syntax

d. operand

  • c. formula syntax

Q. Which of the following methods cannot be used to enter data in a cell?

a. pressing an arrow key

b. pressing an tab key

c. pressing escape key

d. clicking on the formula bar

  • c. pressing escape key

Q. You can activate a cell by

a. pressing tab key

b. clicking the cell

c. pressing an arrow key

d. all of above

  • d. all of above

Q. Which of the following is not a basic step in creating a worksheet?

a. save workbook

b. modify the worksheet

c. enter text and the data

d. copy the worksheet

  • d. copy the worksheet

Q. Which area in an excel allows entering values and formulas

a. title bar

b. menu bar

c. formula bar

d. standard toolbar

  • c. formula bar

Q. ________cell address remains constant, no matter where they are copied

a. individual

b. union

c. range

d. absolute.

  • a. individual

Q. An excel workbook is a collection of

a. workbooks

b. worksheets

c. charts

d. none of above

  • b. worksheets

Q. Excel Probably considers the cell entry January 1, 2000 to be a

a. label

b. value

c. formula

d. text string

  • b. value

Q. 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.

  • a. labels, values, and formulas

Q. 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

  • a. pie chart

Q. The operator to estimate variance is

a. =covar ()

b. =var ()

c. =stdev ()

d. =kurt ()

  • b. =var ()

Q. The operator to estimate mean is

a. =covar ()

b. = mode ()

c. =average ()

d. =median ()

  • c. =average ()
Subscribe Now

Get All Updates & News