IPPB Mains Computer Questions 2017
Analysing The IPPB Mains Computer Questions 2017.
The IPPB Mains 2017 was held on 29th January, 2017 across India in various centres. Detailed analysis of the exam can be found here. We have collected the questions from the IBPPB Mains Computers section that were asked on the exam. You can access the overall exam analysis here. You can also access a detailed list of all GK questions here. These questions will give you an idea of the type of questions one can expect on various exams and you can use these to prepare and practice for future competitive exams.
Q1. For which of the following function, ^ sign is used in MS Excel?
Q2. If you wish to see a particular area of a worksheet visible or multiple rows and columns while you scroll to another area of the worksheet, which among the following should you use?
(a) Freeze Panes
(b) Freeze Columns
(c) Freeze Rows
(d) Freeze Worksheet
(e) Freeze Function
Q3. What is the maximum number, that each of the four parts of an IP Address can have?
Q4. Which among the following is the process of fetching or finding data, relationships, and anomalies from a big collection of data or various databases?
Q5. In MS Excel Translate feature is available under which Tab?
(a) Page Layout
Q6. Which among the following option would you use to analyze, explore, and adding visualization to present the summary of data in MS Excel?
(a) Pivot Chart
(d) Area Chart
(e) Automatic Chart
Q7. In a sentence, if you wish to place your cursor to the right of a word and delete the next word then which among the following is the appropriate shortcut key combination for this task?
Q8. If we use Pie chart, we can only insert and show one data series. Which among the following chart is used to display multiple data series?
Q9. A computer can understand only binary digits 0 and 1. Which among the following language is used by the users and coders to understand easily long streams of 0’s and 1’s representing a computer’s language?
(a) Low Level Language
(b) Assembly Language
(c) Binary Language
(d) High Level Language
(e) Substitute Language
Q10. Which among the following can be used in OOP to write functions, give arguments, commands for particular work?
Q11. Which among the following tag is used to define images in HTML?
Q12. A computer port is a specialized outlet on a piece of equipment to which a plug or cable connects, which of the following port is used to connect video sources to TVs and monitors?
(a) 3.5mm Jack
Q13. Which cloud is a cloud computing environment that uses a mix of on-premises, private cloud and third-party, public cloud services with orchestration between the two platforms and it is particularly valuable for dynamic or highly changeable workloads?
(a) Dynamic Cloud
(b) Advance Cloud
(c) Hybrid Cloud
(d) Sharing Cloud
(e) Combined Cloud
Q14. Which among the following operation facilitate the operating system to allow more than one process to be loaded into the executable memory at a time and loaded process shares the CPU using time multiplexing?
(a) Process Scheduling
(b) Device queues
(d) IPO Cycle
Q15. Which among the following is not a function of Star Topology?
(a) It facilitates centralized management of the network, through the use of the central computer.
(b) Hub acts as a repeater for data flow.
(c) Only that node is affected which has failed, rest of the nodes can work smoothly.
(d) It transmits data only in one direction.
(e) Easy to add another computer to the network.
Q16. Which among the following option is not available for indentation of text in MS Word?
Q17. What is the IEEE Standard for Wireless LAN?
Q18. Which among the following type of operating system facilitates execution of multiple jobs by CPU in the same time virtually by instant switching and enabling many people, located at various terminals, to use a particular computer system at the same time?
(a) Real Time
(b) Batch Processing
(c) Time Sharing
Q19. Which among the following feature is not in MS Word 2007 but introduced in MS Word 2010 in Illustrations under Insert Tab?
Q20. Which among the following is used to begin a formula in MS Excel?
These were some of the questions that were asked in the IPPB Mains 2017. It may be noticed here that the questions mainly revolve over the basic understanding of documenting software like the Ms-Word and Ms-Excel. The aspirants as advised to prepare accordingly.
We wish you all the best!