ITI MCQ
Home
SPREAD SHEET APPLICATION - Quiz
Categories
Computer Operator and Programming Assistant (COPA)
SPREAD SHEET APPLICATION
1) 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
2) Which function key is used to open goto dialogue box in MS Excel?
F2
F5
F7
F11
3) Which option in MS Excel is used to display the rows that meet certain conditions?
Find
Filter
Format
Sort
4) Which option in Excel is used to rearrange the rows base on the content of a particular column?
Find
Filter
Sort
Format
5) Which type of addressing is used to keep rows constant and column changes and vice versa while copying a formula from one area of the worksheet to another in Excel?
Mixed
General
Relative
Absolute
Submit Quiz