Sign in

Forgot Password?

Not signed up yet? Sign up now


Sign up for new account

IBPS Bank PO and Clerk Exam Preparation
IBPS Bank PO and Clerk Exam Preparation
IBPS Bank PO and Clerk Exam Preparation
IBPS Clerk
IBPS Bank PO and Clerk Exam Preparation
IBPS Bank PO and Clerk Exam Preparation
Railways (RRB) Preparation

Already a member? Sign in now

close button

Forgot Password?

Remember your password? Sign in now


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?

(a) Summation

(b) Exponential

(c) Differential

(d) Integration

(e) Percentile

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?

(a) 256

(b) 512

(c) 1024

(d) 255

(e) 300

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?

(a) Fetching

(b) Warehousing

(c) Mining

(d) Finding

(e) Indexing

Q5. In MS Excel Translate feature is available under which Tab?

(a) Page Layout

(b) Home

(c) Edit

(d) Change

(e) Review

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

(b) Column

(c) SmartArt

(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?

(a) Ctrl+Alt+Delete

(b) Ctrl+Delete

(c) Ctrl+Shift+Delete

(d) Alt+Delete

(e) Shift+Alt+Delete

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?

(a) Cake

(b) Cookie

(c) Doughnut

(d) Kitkat

(e) Marshmallow

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?

(a) Method

(b) Class

(c) Directory

(d) Loop

(e) Functions

Q11. Which among the following tag is used to define images in HTML?

(a)  <img>

(b) <jpg>

(c)  <src>

(d)  <alt>

(e)  <tag>

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

(b) VGA

(c) USB

(d) PS/2

(e) Ethernet

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

(c) Execution

(d) IPO Cycle

(e) Multiplexing

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?

(a) Left

(b) Hanging

(c) Center

(d) Right

(e) Justify

Q17. What is the IEEE Standard for Wireless LAN?

(a) 802.11

(b) 802.3

(c) 802.14

(d) 802.15

(e) 802.4

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

(d) Distributed

(e) Network

Q19. Which among the following feature is not in MS Word 2007 but introduced in MS Word 2010 in Illustrations under Insert Tab?

(a) Picture

(b) ClipArt

(c) Shapes

(d) SmartArt

(e) Screenshot

Q20. Which among the following is used to begin a formula in MS Excel?

(a) %

(b) =

(c) +

(d) @

(e) #

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!

Download our Android app to Study Anywhere, Anytime

Studycopter's Android App is used by thousands of users to practice & study for IBPS prelim and mains exams for PO, Clerk, and SO. Get it now to get a top IBPS exam score


Like our Facebook page to get exam updates, current affairs, exam tips etc.