microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 16

When you copy a formula

a) Excel erases the original copy of the formula

b) Excel edits cell references in the newly copied formula

c) Excel adjusts absolute cell references

d) Excel doesn't adjust relative cell references

e) None of these

Question : 17

You can copy data or formulas

a) With the copy, paste and cut commands on the edit menu

b) With commands on the shortcut menu

c) With buttons on the standard toolbars

d) All of the above

e) None of these

Question : 18

In Excel to edit in an embedded excel worksheet object in a word document

a) Use the excel menu bar and toolbars inside the word application

b) Edit the hyperlink

c) Edit the data in a excel source application

d) Use the word menu bar and toolbars

Question : 19

When integrating word and excel, word is usually the

a) Server

b) Destination

c) Client

d) Both b and c

e) None of these

Question : 20

It is acceptable to let long text flow into adjacent cells on a worksheet when

a) data will be entered in the adjacent cells

b) no data will be entered in the adjacent cells

c) there is no suitable abbreviation for the text

d) there is not time to format the text

e) None of these