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) #
