MS excel set 8 Detailed Explanation And More Example

Question : 1

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

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

What is the keyboard shortcut {button or buttons to be pressed) for creating a chart from the selected cells?

a) F3

b) F5

c) F7

d) F11

e) None of these

Question : 4

In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

a) AutoFill

b) Auto correct

c) Auto sum

d) Auto format

e) None of these

Question : 5

Comments put in cells are called

a) Smart tip

b) Cell tip

c) Web tip

d) Soft tip

e) None of these

Question : 6

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