86
82.8k

170+ Computer Applications for Economic Analysis Solved MCQs

These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Bachelor of Arts in Economics (BA Economics) .

51.

Which of the following is not a font style?

A. bold
B. superscript
C. regular
D. italics
Answer» B. superscript
52.

Which enables us to send the same letter to different persons?

A. macros
B. mail merge
C. template
D. none
Answer» B. mail merge
53.

Which of the following is not an essential component to create mail merge?

A. main document
B. data source
C. merge fields
D. word fields
Answer» D. word fields
54.

________consists of most frequently used commands such as cut, copy, paste, print etc

A. quick access toolbar
B. title bar
C. status bar
D. rulers
Answer» A. quick access toolbar
55.

Number of tabs in MS word

A. 8
B. 7
C. 10
D. 5
Answer» B. 7
56.

Which of the following is not an option under font group?

A. underline
B. bold
C. shapes
D. change case
Answer» C. shapes
57.

The word indicates the spelling errors with

A. blue underline
B. green underline
C. red underline
D. black underline
Answer» C. red underline
58.

The word indicates the grammar mistakes with

A. blue underline
B. green underline
C. red underline
D. black underline
Answer» B. green underline
59.

The keyboard short cut for Undo command is

A. alt+u
B. ctrl+y
C. ctrl+u
D. ctrl+z
Answer» D. ctrl+z
60.

The keyboard short cut for Redo command is

A. ctrl+r
B. ctrl+y
C. ctrl+j
D. alt+r
Answer» B. ctrl+y
61.

The keyboard short cut for Paste command is

A. ctrl+v
B. ctrl+p
C. ctrl+j
D. alt+p
Answer» A. ctrl+v
62.

The keyboard short cut for justifying alignment is

A. ctrl+a
B. ctrl+y
C. ctrl+j
D. ctrl+n
Answer» C. ctrl+j
63.

The keyboard short cut for creating a new document is

A. alt+n
B. ctrl+n
C. alt+d
D. ctrl+d
Answer» B. ctrl+n
64.

_______is a collection of predefined design elements and colour schemes

A. feature
B. hyperlink
C. palette
D. theme
Answer» D. theme
65.

Change the _____to create a document in wide format

A. page margins
B. paper style
C. page orientation
D. paper source
Answer» A. page margins
66.

Which operation you will perform if you need to move a block of text.

A. copy and paste
B. paste and delete
C. cut and paste
D. title bar
Answer» C. cut and paste
67.

To view header and footer you must switch to

A. normal view
B. print layout view
C. print preview mode
D. both b and c
Answer» D. both b and c
68.

From where you can access save command.

A. home tab
B. insert tab
C. review tab
D. none of above
Answer» D. none of above
69.

Essential business letter elements include the_________

A. date line and inside address
B. message
C. signature bloc
D. all of above
Answer» D. all of above
70.

Which of the following helps to reduce spelling error in the document?

A. auto format
B. auto correct
C. smart tags
D. auto text.
Answer» B. auto correct
71.

In Word 2007 the Zoom is placed on

A. view tab
B. home tab
C. status bar
D. both a & c
Answer» D. both a & c
72.

A command under a group is known as _____

A. button
B. tab
C. ribbon
D. none of above
Answer» A. button
73.

________indicates writable area of the document

A. gridlines
B. rulers
C. thumbnails
D. document map
Answer» B. rulers
74.

Which is not an option to insert equations?

A. equations
B. symbols
C. smartart
D. ms equation editor
Answer» C. smartart
75.

What is the default file extension for all word documents?

A. .txts
B. . word
C. .docs
D. .docx
Answer» D. .docx
76.

What is the smallest and largest font size tool on formatting toolbar?

A. 8 and 72
B. 8 and 64
C. 12 and 72
D. none of the above.
Answer» A. 8 and 72
77.

The extension of database file in excel is

A. .doc
B. .xls
C. bmp
D. dbf
Answer» B. .xls
78.

The menu for locating regression in MS Excel is

A. format
B. tools
C. insert
D. data analysis
Answer» D. data analysis
79.

Which of the following formula in excel is used for exponential operation?

A. ^
B. +
C. *
D. /
Answer» A. ^
80.

Analysis toolpak is an add-in function in

A. powerpoint
B. excel
C. word
D. access
Answer» B. excel
81.

Which of the following is an electronic spreadsheet?

A. powerpoint
B. excel
C. word
D. access
Answer» B. excel
82.

Solver is an add-in function in

A. powerpoint
B. word
C. excel
D. access
Answer» C. excel
83.

Conditional sum wizard is an add-in function in

A. powerpoint
B. word
C. excel
D. access
Answer» C. excel
84.

Which of the following is an operator for defining natural logarithm in excel worksheet

A. =ni().
B. =ln()
C. =^()
D. =log()
Answer» B. =ln()
85.

Which of the following defines a formula in excel ?

A. &.
B. *
C. ^
D. =
Answer» D. =
86.

Which among the following is a valid cell address in MS Excel?

A. a:20
B. b;15
C. d6
D. 10h
Answer» C. d6
87.

Which among the following represents a union type cell reference in Excel?

A. (a10:a20)
B. (b10:b20)
C. (a10,a20)
D. a10
Answer» C. (a10,a20)
88.

Which among the following represents a individual cell reference in Excel?

A. (c10:c20)
B. (d10,d20)
C. (a10,a20)
D. f10
Answer» D. f10
89.

________useful to display trend of an economic variable over a time period

A. line chart
B. bar chart
C. pie chart
D. scatter plot
Answer» A. line chart
90.

AutoSum can be used to calculate

A. sum
B. average
C. maximum
D. all of the above
Answer» D. all of the above
91.

Which of the following is not an element in formula syntax?

A. equal to sign
B. operator
C. chart
D. cell address
Answer» C. chart
92.

Which of the following is forecasting tool?

A. moving average
B. variance
C. linear trend line
D. cubic trend line
Answer» B. variance
93.

The function library is available under _______tab.

A. formula
B. insert
C. data
D. review
Answer» A. formula
94.

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

A. operator
B. cell
C. formula syntax
D. operand
Answer» C. formula syntax
95.

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
Answer» C. pressing escape key
96.

You can activate a cell by

A. pressing tab key
B. clicking the cell
C. pressing an arrow key
D. all of above
Answer» D. all of above
97.

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
Answer» D. copy the worksheet
98.

How many worksheets a workbook normally consist of?

A. 3
B. 2
C. 1
D. 4
Answer» A. 3
99.

Which area in an excel allows entering values and formulas

A. title bar
B. menu bar
C. formula bar
D. standard toolbar
Answer» C. formula bar
100.

________cell address remains constant, no matter where they are copied

A. individual
B. union
C. range
D. absolute.
Answer» A. individual

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.