MS Excel MCQs

Question 1

A worksheet range is a

Accepted Answer

A group of cells

Answer

A command used for data modeling

Answer

A range of values such as from 23 to 234

Answer

A group of worksheets

Question 2

Getting data from a cell located in a different sheet is called ________

Accepted Answer

Referencing

Answer

Accessing

Answer

Updating

Answer

Functioning

Question 3

Tab scrolling button

Accepted Answer

Allow you to view additional sheets tabs

Answer

Allow you to view a different worksheet

Answer

Allow you to view additional worksheet rows down

Answer

Allow you to view additional worksheet columns to the right

Question 4

A numeric value can be treated as a label value if it precedes with

Accepted Answer

Apostrophe (')

Answer

Exclamation (!)

Answer

Hash (#)

Answer

Ampersand (&)

Question 5

Concatenation of text can be done using

Accepted Answer

Ampersand (&)

Answer

Apostrophe (')

Answer

Exclamation (!)

Answer

Hash (#)

Question 6

Data can be arranged in a worksheet in a easy to understand manner using

Accepted Answer

all of above

Answer

Auto formatting

Answer

Applying styles

Answer

Changing fonts

Question 7

You can use drag-and-drop to embed excel worksheet data in a word document

Accepted Answer

By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

Answer

By dragging a range of excel data to the word button on the taskbar while pressing Shift key

Answer

By dragging a range of excel data to the word button on the taskbar while pressing Alt key

Answer

None of above

Question 8

The auto calculate feature

Accepted Answer

Provides a quick way to view the result of an arithmetic operation on a range of cells

Answer

Can only add values in a range of cells

Answer

Automatically creates formulas and adds them to a worksheet

Answer

A and C

Question 9

Excel uniquely identifies cells within a worksheet with a cell name

Accepted Answer

Column letters and row numbers

Answer

Cell names

Answer

Column numbers and row letters

Answer

Cell locator coordinates