www.ThinkITI.com

Home
MCQ
Search
Free Apps
Important
Study Groups
Contact Us
Policy

Home
MCQ
Objective Questions
ITI
COPA
COPA Set-1
Spread Sheet Application
29

Spread Sheet Application MCQ with Answers

29) Which function is used to find the middle number in a range?

MEDIAN()

MID()

TRIM()

MODE()

Answer is:

MEDIAN()

Spread Sheet Application MCQ with Answers

For more MCQ's Click Here

Related Spread Sheet Application MCQ with Answers

30) What is the purpose 'Tab' key in MS Excel?

Moves cell pointer to previous column

Moves cell pointer to next column

Moves cell pointer previous row

Moves cell pointer next row

Answer is:

Moves cell pointer to next column

31) What is the purpose of ?Enter Key? in MS Excel?

Moves cell pointer to previous column

Moves cell pointer to next column

Moves cell pointer to previous row

Moves cell pointer to next row

Answer is:

Moves cell pointer to next row

32) Which function key is used to open goto dialogue box in MS Excel?

F2

F5

F7

F11

Answer is:

F5

33) Which option in MS Excel is used to display the rows that meet certain conditions?

Find

Filter

Format

Sort

Answer is:

Filter

Spread Sheet Application MCQ with Answers

For more MCQ's Click Here