MS excel set 8 Detailed Explanation And More Example

Question : 1

To drag a selected range of data to another worksheet in the same workbook, use the

a) Tab key

b) Alt key

c) Shift key

d) Ctrl key

e) None of these

Question : 2

Using the Fl 1 shortcut key to create a chart on chart sheet creates

a) A default chart

b) A 2-dimensional column chart

c) A 2-dimensional bar chart

d) A 3-dimensional line chart

e) None of these

Question : 3

You can copy data or formulas

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

b) With commands on a shortcut menu

c) With buttons on the standard toolbar

d) All of the above

e) None of these

Question : 4

Comments put in cells are called

a) Smart tip

b) Cell tip

c) Web tip

d) Soft tip

e) None of these

Question : 5

In Excel you can select a single range of cells by

a) Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

b) Pressing the Ctrl key while dragging over the desired cells

c) Pressing the Shift key and an arrow key

d) Dragging over the desired cells

Question : 6

In Excel the following will not cut information

a) Pressing Ctrl + C

b) Selecting Edit>Cut from the menu

c) Clicking the Cut button on the standard

d) Pressing Ctrl+X