MS excel set 1 Detailed Explanation And More Example

Question : 1

In Excel which of the following formulas will Excel not be able to calculate?

a) =SUM(A1:A5)-10

b) =SUM(A1:A5)/(10-10)

c) =SUM(A1:A5)*.5

d) =SUM(Sales)-A3

Question : 2

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 : 3

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 : 4

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 : 5

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

Question : 6

Excel uses the …. Function when creating a data table

a) Count

b) Table

c) Average

d) Sum