MS Excel MCQ with Answers

Apostrophe (&lsquo

Exclamation (!)

Hash (#)

Ampersand (&)

auto formatting

applying styles

changing fonts

all of above

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

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

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

None of above

Can only add values in a range of cells

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

Automatically creates formulas and adds them to a worksheet

A and c

Cell names

Column numbers and row letters

Column letters and row numbers

Cell locator coordinates