MS excel set 1 Detailed Explanation And More Example

Question : 1

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

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

In Excel using the F11 shortcut key to create a chart on chart sheet creates

a) A 2-dimensional column chart

b) A default chart

c) A 3-dimensional line chart

d) A 2-dimensional bar chart

Question : 4

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

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

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