MS excel set 10 Detailed Explanation And More Example

Question : 1

In Excel you can use drag and drop to embed excel worksheet data in a word document

a) By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

b) By dragging a range of excel data to the Word button on the taskbar while pressing Shift key

c) By displaying both applications side-byside and dragging a selected range of Excel data into the word application window while pressing the Ctrl key

d) (A) and (C)

Question : 2

Which of the following series type is not valid for Fill Series dialog box?

a) Linear

b) Growth

c) Autofill

d) Time

e) None of these

Question : 3

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

Question : 4

Which of the cell pointer indicates you that you can make selection?

a) Doctor's symbol (Big Plus)

b) small thin plus icon

c) Mouse Pointer with anchor at the tip

d) Press F3 + Ctrl

e) None of these

Question : 5

What does SUMIF function do?

a) Adds up cell values based on a condition

b) Adds all the numbers in a range of cells

c) Returns a subtotal in a list or database

d) All of above

e) None of these

Question : 6

When you insert an Excel file into a Word document, the data are

a) Hyperlinked

b) Placed in a word table

c) Linked

d) Embedded

e) None of these