MS Excel MCQs

Question 1

Concatenation of text can be done using

Accepted Answer

Ampersand ( & )

Answer

Apostrophe ( ‘ )

Answer

Exclamation ( ! )

Answer

Hash ( # )

Question 2

Which area in an Excel window allows entering values and formulas?

Accepted Answer

Formula Bar

Answer

Title Bar

Answer

Menu Bar

Answer

Standard Tool Bar

Question 3

Multiple calculations can be made in a single formula using ________

Accepted Answer

Array Formula

Answer

Standard Formulas

Answer

Complex Formulas

Answer

Smart Formula

Question 4

An Excel Workbook is a collection of ________

Accepted Answer

Worksheets and Charts

Answer

Workbooks

Answer

Worksheets

Answer

Charts

Question 5

What do you mean by a Workspace?

Accepted Answer

Group of Workbooks

Answer

Group of Columns

Answer

Group of Worksheets

Answer

Group of Rows

Question 6

MS-EXCEL is based on ________

Accepted Answer

WINDOWS

Answer

DOS

Answer

UNIX

Answer

OS/2

Question 7

In EXCEL, you can sum a large range of data by simply selecting a tool button called ________.

Accepted Answer

Auto sum

Answer

AutoFill

Answer

Auto correct

Answer

Auto format

Question 8

To select an entire column in MS-EXCEL, press?

Accepted Answer

None of the above

Answer

CTRL + C

Answer

CTRL + Arrow key

Answer

CTRL + S

Question 9

To return the remainder after a number is divided by a divisor in EXCEL we use the function?

Accepted Answer

MOD ( )

Answer

ROUND ( )

Answer

FACT ( )

Answer

DIV ( )