MS excel set 10 Detailed Explanation And More Example

Question : 1

Two common wildcard characters that Excel recognizes are

a) * and?

b) < and >

c) * and /

d) + and –

e) None of these

Question : 2

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

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

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

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

What is represented by the small, black square in the lower-right corner of an active cell or range?

a) Copy handle

b) Fill handle

c) Insert handle

d) Border

e) None of these