MS excel set 10 Detailed Explanation And More Example

Question : 1

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

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

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

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

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

Question : 6

In Excel when creating a vertical page break

a) The active cell must be A1

b) The active cell can be anywhere in the worksheet

c) The active cell must be in row 1

d) The active cell must be in column A