MS excel set 5 Detailed Explanation And More Example

Question : 1

You can add an image to a template by clicking the Insert Picture From File button on the .... Toolbar.

a) Standard

b) Formatting

c) Drawing

d) Picture

e) None of these

Question : 2

In Excel the Paste Special command lets you copy and paste

a) Multiply the selection by a copied value

b) Cell comments

c) Formatting options

d) The resulting values of a formula instead of the actual formula

Question : 3

In Excel which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell

a) Count

b) Average

c) Sum

d) None of above

Question : 4

The active cell:

a) is defined by a bold border around the cell.

b) Receives the data the user enters.

c) It is the formula bar.

d) Only A and B

e) None of these

Question : 5

You want to set such that when you type Baishakh and drag the fill .handle. Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

a) Fill Across Worksheet

b) Custom List

c) Auto Fill Options

d) Fill Series

e) None of these

Question : 6

In Excel to activate the previous cell in a preselected range, press

a) The Alt key

b) The Tab key

c) The Enter key

d) None of above