MS excel set 10 Detailed Explanation And More Example

Question : 1

You can open the consolidate dialog box by choosing' Consolidate from the...... menu.

a) Insert

b) Format

c) Tools

d) Data

e) None of these

Question : 2

The Name box on to the left of formula bar

a) shows the name of workbook currently working on

b) shows tne name of worksheet currently working on

c) shows the name of cell or range currently working on

d) All of above

e) None of these

Question : 3

In Excel Tab scrolling buttons

a) Allow you to view a different worksheet

b) Allow you to view additional worksheet row down

c) Allow you to view additional worksheet columns to the right

d) Allow you to view additional sheet tabs

Question : 4

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

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

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)