MS excel set 10 Detailed Explanation And More Example

Question : 1

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

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

Question : 3

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

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

Question : 5

Where can you set the shedding color for a range of cells in Excel?

a) Choose required color form Patterns tab of Format Cells dialog box

b) Choose required color on Fill Color tool in Formatting toolbar

c) Choose required color on Fill Color tool in Drawing toolbar

d) All of above

e) None of these

Question : 6

The autofill feature

a) Extends a sequential series of data

b) Automatically adds a range of cell values

c) Applies a boarder around selected cells

d) All of above

e) None of these