MS excel set 2 Detailed Explanation And More Example

Question : 1

To delete an embedded objects, first

a) Double click the object

b) Select the object by clicking it

c) Press the Shift + Delete ' keys

d) Select it and then press the delete key

e) None of these

Question : 2

In Excel you cannot link excel worksheet data to a word document

a) With the right drag method

b) With a hyperlink

c) With the copy and paste special commands

d) With the copy and paste buttons on the standard toolbar

Question : 3

You can add a hyperlink to your worksheet by pressing

a) Alt + K

b) Ctrl + H

c) Ctrl + K

d) Ctrl + Shift + K

e) None of these

Question : 4

In Excel concatenation of text can be done using

a) Apostrophe (‘)

b) Exclamation (!)

c) Hash (#)

d) Ampersand (&)

Question : 5

In Excel the following is not an example of a value

a) 350

b) May 10, 2001

c) 57&per cent;

d) Serial Number 50771

Question : 6

A circular reference is

a) Geometric modeling tool

b) A cell that points to a drawing object

c) A formula that either directly or indirectly depends on itself

d) Always erroneous

e) None of these