Microsoft Excel Questions

MCQ bookmark_border

191.

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

A

Accessing

B

Referencing

C

Updating

D

Functioning

Correct Answer: B

Getting data from a cell located in a different sheet is called Cell reference.
There are Three types of Cell reference in Excel
Relative
Absolute
Mixed

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

192.

Tab scrolling button

A

Allow you to view a different worksheet

B

Allow you to view additional worksheet rows down

C

Allow you to view additional worksheet columns to the right

D

Allow you to view additional sheets tabs

Correct Answer: D

Tab scrolling button allow us to view additional sheets tabs.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

193.

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

A

Apostrophe (')

B

Exclamation (!)

C

Hash (#)

D

Ampersand (&)

Correct Answer: A

An apostrophe before a cell value forces Excel to interpret the value as label. This is mostly useful for values that look like a number or date.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

194.

Concatenation of text can be done using

A

Apostrophe (')

B

Exclamation (!)

C

Hash (#)

D

Ampersand (&)

Correct Answer: D

Concatenation of text can be done using Ampersand (&).

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

195.

Concatenation of text can be done using

A

Apostrophe (')

B

Exclamation (!)

C

Hash (#)

D

Ampersand (&)

Correct Answer: D

Concatenation of text can be done using Ampersand (&).

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

196.

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

A

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

B

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

C

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

D

None of above

Correct Answer: A

We can use drag-and-drop to embed excel worksheet data in a word document by dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

197.

The auto calculate feature

A

Can only add values in a range of cells

B

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

C

Automatically creates formulas and adds them to a worksheet

D

A and C

Correct Answer: B

The auto calculate feature provides a quick way to view the result of an arithmetic operation on a range of cells.

Check Answer report_problem Report forum Discussion