Computer Question Bank
for Exam preparation

Computer- Q2. Ms Excel:Which of the following is correct syntax in Excel?

1. =IF(LogicalTest, TrueResult, FalseResult)
2. =IF(LogicalTest, (TrueResult, FalseResult))
3. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)
4. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

Computer- Q3. System files allocated at

1. Boot area
2. FAT area
3. Data area
4. Directory

Computer- Q4. Ms Excel:Which of following is Not one of Excel’s what-if function?

1. Goal seek
2. Solver
3. Scenario manager
4. Auto Outline

Computer- Q5. Ms Access: This query wizard will create a select query.

1. Crosstab
2. Find duplicates
3. Simple
4. Design view

Computer- Q6. What is Thrashing?

1. A high paging activity is called thrashin
3. A high executing activity is called thrashing
4. A extremely long process is called thrashing
5. A extremely long virtual memory is called thrashing

Computer- Q7. Ms Access: In a query, what symbol is used to surround a parameter\’s user prompt?

1. [ ]
2. { }
3. ” ”
4. ( )

Computer- Q8. Ms Access: This is not one of the sections of the form design window

1. Form footer
2. Form content
3. Form header
4. Form detail

Computer- Q9. The virtual memory is

1. An extremely large main memory
2. An extremely large secondary memory
3. An illusion of extremely large main memory
4. A type of memory used in super computer

Computer- Q10. Ms Excel:A smart tag will be removed from a cell when

1. the cell is moved
2. the cell is hidden
3. the data in the cell is changed or deleted
4. the formatting of the cell is changed