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) #
ANSWERS :
S1. Ans.(b)
Sol. ^ is the symbol for exponential function.
S2. Ans.(a)
Sol. When you freeze panes, Microsoft Excel keeps specific rows or columns visible when you scroll in the worksheet. For example, if the first row in your spreadsheet contains headers, you might freeze that row to make sure that the column headers remain visible as you scroll down in your spreadsheet.
To lock one row only, choose the View tab, and then click Freeze Top Row.
To lock one column only, choose the View tab, and then click Freeze First Column.
To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes.
S3. Ans.(d)
Sol. All IP addresses are made up of four parts (quadrants) separated by dots, like this: XXX.XXX.XXX.XXX
Where each XXX can be any number between 0 and 255. Each of these numbers are stored in 8 bits (binary digits), and the number of possibilities you can have is 2 raised to the power of 8, which is 256 (0-255).
S4. Ans.(c)
Sol. Data mining is the analysis of data for relationships that have not previously been discovered. Data mining is the process of finding anomalies, patterns and correlations within large data sets to predict outcomes.
S5. Ans.(e)
Sol. Translate feature is available in Language section under Review Tab. Other features under Review tab are Proofing which includes Spelling, Research and Thesaurus, Comments and Changes.
S6. Ans.(a)
Sol. PivotChart is best type of graphs for the analysis of data. You can use a PivotTable report to summarize, analyze, explore, and present summary data. PivotCharts complement PivotTables by adding visualizations to the summary data in a PivotTable, and allow you to easily see comparisons, patterns, and trends. Both PivotTables and PivotCharts enable you to make informed decisions about critical data in your enterprise.
S7. Ans.(b)
Sol. Ctrl+Delete is used to delete the next word.
S8. Ans.(c)
Sol. Data that is arranged in columns or rows only on a worksheet can be plotted in a doughnut chart. Just like a pie chart, a doughnut chart shows the relationship of parts to a whole, but a doughnut chart can contain more than one data series. Each data series that you plot in a doughnut chart adds a ring to the chart.
S9. Ans.(d)
Sol. Low-level languages those languages which are extremely close to machine language, whereas High Level Languages are close to the user or programmer. A high-level language is a programming language such as C, FORTRAN, or Pascal that enables a programmer to write programs that are more or less independent of a particular type of computer. Such languages are considered high-level because they are closer to human languages and further from machine languages.
S10. Ans.(e)
Sol. A class, in current, conventional OOP, is a collection of data (member variables) bound together with the functions/procedures that work on that data (member functions or methods).
A function is a collection of computing statements. Function is a combination of instructions coupled together to achieve some result. It may take arguments and return result.
A method is just jargon for a function (or procedure) bound to a class. A method in object-oriented programming is a procedure associated with a class. A method defines the behaviour of the objects that are created from the class. Another way to say this is that a method is an action that an object is able to perform.
S11. Ans.(a)
Sol. <img> tag is used to define images in HTML. The <img> tag has two required attributes: src and alt.
S12. Ans.(b)
Sol. The Video Graphics Array (VGA) is one of the oldest connection standards which can still be found in large swaths of computing equipment. It was first developed by IBM and introduced in 1987. It was widely used for video cards, TV sets, computer monitors, and laptops.
S13. Ans.(c)
Sol. Hybrid cloud is a cloud computing environment which uses a mix of on-premises, private cloud and third-party, public cloud services with orchestration between the two platforms. By using a Hybrid approach, companies can maintain control of an internally managed private cloud while relying on the public cloud as needed.
S14. Ans.(a)
Sol. The process scheduling is the activity of the process manager that handles the removal of the running process from the CPU and the selection of another process on the basis of a particular strategy. Process scheduling is an essential part of Multiprogramming operating systems.
S15. Ans.(d)
Sol. ‘It transmits data only in one direction.’ It is the function of Bus topology not Star Topology.
S16. Ans.(c)
Sol. Center is no option under indentation of text.
S17. Ans.(a)
Sol. 802.11 – Wireless LAN
802.3 - Ethernet
802.14 - Cable modems
802.15 - Wireless PAN
802.4 - Token bus
S18. Ans.(c)
Sol. Time-sharing is a technique which enables many people, located at various terminals, to use a particular computer system at the same time. Time-sharing or multitasking is a logical extension of multiprogramming. Processor's time which is shared among multiple users simultaneously is termed as time-sharing.
S19. Ans.(e)
Sol. Screenshot is a new feature in MS Word 2010 in Illustrations under Insert Tab; it is not there in MS Word 2007.
S20. Ans.(b)
Sol. A formula in MS Excel begins with =
Important Note:
To receive the fastest updates on Bank Exams like IBPS, SBI, RBI, IPPB, etc. as well as all other ongoing as well as forthcoming exams, kindly subscribe to our website. All you have to do is enter your email in the pop-up that appears on the website when you first enter it on the home page. Once you’re subscribed, you will receive all the latest updates concerning all competitive exams.
For more Updates & Notifications for bank exams like SBI PO, SBI CLERK, IBPS PO, IBPS RRB, IBPS CLERK, IBPS SO, NIACL, SSC CHSL, SSC CGL etc. like our facebook page at :
0 comments:
Post a Comment