Computer gk questions for competitive exams
Computer questions are used in every job based test. If you give competitive exam or sit any government job, then you must know general questions on computer. Through this blog I will share you how you can prepare for the job exam through the questions given below. The following questions appeared in the previous year exam. I am sure, if you practice these questions properly then hopefully some questions may come in the exam, good luck to you. Let's begin
- Which one is not the appropriate method of editing the content of a cell in MS Excel?
- Click on the formula bar
- Double click the cell
- Press F6
- Press F2
2. While comparing transcribed data in an MS Excel document, which of the following functions can be used to look up and retrieve data from a specific column in a Table?
- Sum IF
- Concatenate
- V Lookup
- B Lookup
3. A circular reference in MS Excel is:.
- Geometric modeling tool
- A cell that points to a drawing object
- A formula to create a circle
- A formula that depends on itself
4.You can use which of the following operations to combine text from two cell into one cell in MS Exce
- (space)
- =(equal sign)
- & (ampersand)
- None of the above
5. To insert WordArt in an MS PowerPoint slide, you should press:
- Alt+N, W
- Alt+N,F
- Alt+N, X
- Alt+N, J
6.To insert 3 columns between columns D and E in MS Excel, you would:
- Select columns E,F,G
- Select column E
- Select column D
- Select columns D,E,F
7. Cascade delete option in MS Access is used for
- Deleting all the records of all tables in a database
- Repeating the recent delete operation to all the records of the current table
- Deleting the related records automatically when the parent is deleted
- None of the above
8.Which of the following is not a database object in MS Access?
- Tables
- Quries
- Relationship
- Report
9. Which of the following is true about hypothesis testing
- answering yes/no questions about the data
- estimating numerical characteristics of the data
- describing association within the data
- modeling relationship within the data
10.Which formula will you use to make a number in cell C1 10% smaller than the number in cell C3 in MS Excel?
- =C3 %10
- =C3*0.9
- +C3*110
- =C3*1.10
11.What is the value of the MS Excel formula =COUNT(1>2>3,2,0)
- 3
- 1
- 0
- 5
Conclusion
So, these are some most common questions coming in every competitive exam. Hope you benefit from this blog. Please follow us for more amazing general knowledge posts.