MS excel set 1 Detailed Explanation And More Example

Question : 1

In Excel the drag and drop method of copying or moving

a) Can be used between workbooks but not worksheets

b) Can be used between worksheets but not workbooks

c) Can be used between workbooks but not worksheets

d) None

Question : 2

In Excel to activate the previous cell in a preselected range, press

a) The Enter key

b) The Alt key

c) The Tab key

d) None of the above

Question : 3

In Excel you can quickly change the appearance of your work by choosing Auto Format from the ……….. Menu

a) Format

b) Edit

c) View

d) Tools

Question : 4

In Excel To select several cells or ranges that are not touching each other, you would … while selecting

a) hold down the Shift key

b) hold down the Alt key

c) hold down Ctrl + Shift key

d) hold down the Ctrl key

Question : 5

You cannot link Excel worksheet data to a Word document

a) With a hyperlink

b) With the copy and paste special commands

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

d) With the right drag method

Question : 6

In Excel say that you want to paste a formula result – but not the underlying formula – to another cell. In excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next?

a) Click the arrow on the paste button on the standard toolbar, then click formulas

b) Click the arrow on the paste button on the standard toolbar, then click values.

c) Click the Paste button on the standard toolbar

d) All of above