Railway Science (Computer – Microsoft Office)

Total Questions: 33

21. Which of the following is NOT a spreadsheet program ? [RRB NTPC CBT - I (29/01/2021) Evening]

Correct Answer: (d) Ubuntu
Solution:

It is a complete Linux operating system, freely available with both community and professional support. Spreadsheet - It is a software program you use to easily perform mathematical calculations on statistical data.

22. The cell with a dark boundary in ______ is called an active cell. [RRB NTPC CBT - I (17/01/2021) Evening]

Correct Answer: (a) MS Excel
Solution:

When using a spreadsheet (or a general 2-dimensional table), the selected, highlighted, or clicked-upon cell is called the active cell.

23. Which of the following is an example of a spreadsheet? [RRB NTPC CBT - I (16/01/2021) Morning]

Correct Answer: (a) Microsoft Excel
Solution:

MS Word, an example of Application software. Microsoft Powerpoint is an example of presentation software.

24. _____ and ______ are the two kinds of sound effects files that can be added in Microsoft PowerPoint. [RRB NTPC CBT - I (13/01/2021) Evening]

Correct Answer: (a) .wav files, .mid files
Solution:

WAV stands for Waveform Audio File Format and was developed by Microsoft and IBM. MIDI stands for Musical Instrument Digital Interface.

25. In Excel, what shortcut key is used to fill the selected cells with active cells to the right? [RRB NTPC CBT - I (12/01/2021) Morning]

Correct Answer: (a) Ctrl + R
Solution:

In Excel, Ctrl + R, fill the row cell to the right with the contents of the selected cell. Ctrl + V, will paste anything stored in the clipboard into the currently -selected cell. Ctrl + S, saves the current worksheet, and fills and overwrites a cell with the contents of the cell above it in a column.

26. Which function key in Excel helps to switch to edit mode? [RRB NTPC CBT - I (08/01/2021) Evening]

Correct Answer: (b) F2
Solution:

F7- Open the "Spelling" option in excel using which you can check the spellings in your workbook. F5 - Displays the "Go To" dialog box. F3 - Paste Named Range or Named List.

27. By default, how many worksheets are present in the workbook of Excel MS office 2010 ? [RRB NTPC CBT - I (04/01/2021 ) Evening]

Correct Answer: (c) 3
Solution:

The default worksheet tabs are Sheet1, Sheet2, Sheet3.

28. Which of the following does not support bidirectional data transmission? [RRB NTPC CBT - II (15/06/2022) Shift 2]

Correct Answer: (b) Simplex
Solution:

Example- Keyboard and monitor. Half-duplex data transmission means that data can be transmitted in both directions on a signal carrier, but not at the same time. Example:- Walkie- Talkie.
Full-duplex data transmission means that data can be transmitted in both directions on a signal carrier at the same time. Example:- Mobile Phone.

29. In which of the following network topologies do the connected components make a closed loop ? [RRB NTPC CBT - II (17/06/2022) Shift I]

Correct Answer: (b) Ring topology
Solution:

Tree topology - Tree topology is a type of network topology in which nodes are grouped in the shape of a tree. Star topology - It is a network topology in which each network component is physically connected to a central node such as a router, hub or switch. Bus topology - It is a network type in which every computer and network device is connected to a single cable.

30. Which one of the following is called a super-network or meta-network? [RRB NTPC CBT - I (20/1/2021) Morning]

Correct Answer: (c) Internet
Solution:

Metropolitan area network (MAN) is a computer network that is larger than a single building local area network (LAN) but is located in a single geographic area that is smaller than a wide area network (WAN).