MS excel set 10 Detailed Explanation And More Example

Question : 1

How are data organized in a spreadsheet?

a) Lines and spaces

b) Layers and planes

c) Rows and columns

d) Height and width

e) None of these

Question : 2

In Excel it is acceptable to let long text flow into adjacent cells on a worksheet when

a) Data will be entered in the adjacent cells

b) No data will be entered in the adjacent cells

c) There is not suitable abbreviation of the text

d) There is not time to format the next

Question : 3

How can you print three copies of a workbook?

a) Select File>Properties form the menu and type 3 in the Copies to print text box.

b) Select File >Print from the menu and type 3 in the Number of copies text box.

c) Click the Print button on the standard toolbar to print the document then take it to Kinko's and have 2 more copies made

d) Press Ctri+P+3

e) None of these

Question : 4

We can save and protect 1he workbook by

a) Write Reservation Password

b) Protection Password

c) Read-only Recommended

d) Any of the above

e) None of these

Question : 5

In Excel to access the Go To Special feature, you can press

a) Ctrl + G

b) Ctrl + O

c) Ctrl + Shift + G

d) Ctrl + 1

Question : 6

Which types of charts can excel produce?

a) Line graphs and pie charts only

b) Only line graphs

c) Bar charts, line graphs and pie charts

d) Bar charts and line graphs only

e) None of these