MS excel set 8 Detailed Explanation And More Example

Question : 1

How can you find specific information in a list?

a) Select Tools > Finder from the menu

b) Click the Find button on the standard toolbar

c) Select Insert > Find from the menu

d) Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

e) None of these

Question : 2

To open the Format Cells dialog box, press

a) Alt* 1

b) Ctrl + 1

c) Ctrl + Shift + 1

d) F1

e) None of these

Question : 3

What happens when you press Ctrl + X after selecting some cells in Excel?

a) The cell content of selected cells disappear from cell and stored in clipboard

b) The cells selected are marked for cutting

c) The selected cells are deleted and the cells are shifted left

d) The selected cells are deleted and cells are shifted up

e) None of these

Question : 4

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

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

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