Examius

🇮🇳 SBI PO · subject

SBI PO Computer Aptitude Syllabus

The Computer Aptitude syllabus for SBI PO in full: 3 chapters and 9 topics, every one listed below, plus 51 Computer Aptitude flashcards with answers.

3Chapters
9Topics
51Flashcards

Computer Aptitude syllabus: all 3 chapters

Expand any chapter to see its topics and sub-topics.

  1. Basics of Computers

     3 topics
    • Hardware and Software
    • Operating Systems
    • Internet

  2. MS Office

     3 topics
    • MS Word
    • MS Excel
    • MS PowerPoint

  3. Networking

     3 topics
    • LAN and WAN
    • Network Security
    • Protocols

SBI PO Computer Aptitude flashcards — 51 questions with answers

  1. What is the difference between hardware and software?

    Hardware is the physical, tangible components of a computer (e.g., CPU, keyboard, monitor); software is the set of programs and instructions that tell the hardware what to do (e.g., OS, applications).

  2. What are the two main categories of software?

    System software (e.g., operating systems, device drivers, utilities) and application software (e.g., MS Word, browsers, games).

  3. What is firmware?

    Firmware is permanent software programmed into read-only memory (ROM) that provides low-level control for a device's hardware, such as the BIOS.

  4. What is the function of the CPU and its two main components?

    The CPU (Central Processing Unit) is the brain of the computer that executes instructions. Its two main components are the ALU (Arithmetic Logic Unit) and the CU (Control Unit).

  5. What does ALU stand for and what does it do?

    ALU stands for Arithmetic Logic Unit; it performs all arithmetic operations (add, subtract) and logical operations (AND, OR, comparisons).

  6. What is the difference between RAM and ROM?

    RAM (Random Access Memory) is volatile, read/write, temporary memory that loses data when power is off. ROM (Read-Only Memory) is non-volatile, permanent memory that retains data without power.

  7. What are the two types of RAM?

    SRAM (Static RAM), which is fast and used in cache, and DRAM (Dynamic RAM), which is slower, cheaper, and used as main memory.

  8. What is cache memory?

    Cache memory is a small, very fast memory located between the CPU and main memory (RAM) that stores frequently used data and instructions to speed up processing.

  9. Classify input and output devices with examples.

    Input devices send data to the computer (keyboard, mouse, scanner, microphone). Output devices receive data from the computer (monitor, printer, speakers).

  10. What is an operating system?

    An operating system (OS) is system software that manages computer hardware, software resources, and provides common services and an interface for the user (e.g., Windows, Linux, macOS).

  11. List four key functions of an operating system.

    Process management, memory management, file management, and device (I/O) management. (Also security and user interface.)

  12. What is multitasking in an operating system?

    Multitasking is the ability of an OS to execute multiple tasks (processes) seemingly at the same time by rapidly switching the CPU among them.

  13. What is the difference between a GUI and a CLI?

    GUI (Graphical User Interface) uses icons, windows, and a pointer for interaction (e.g., Windows). CLI (Command Line Interface) requires users to type text commands (e.g., MS-DOS, Linux terminal).

  14. What is virtual memory?

    Virtual memory is a technique where part of the hard disk is used as an extension of RAM, allowing the system to run programs larger than physical memory.

  15. What is booting and what are its two types?

    Booting is the process of starting a computer and loading the OS. Cold/hard boot starts from a powered-off state; warm/soft boot restarts an already running computer (e.g., Ctrl+Alt+Del).

  16. What is the Internet?

    The Internet is a global network of interconnected computer networks that communicate using the TCP/IP protocol suite to share information and resources.

  17. What is the difference between the Internet and the World Wide Web (WWW)?

    The Internet is the global hardware/network infrastructure. The WWW is a service running on the Internet—a collection of interlinked web pages accessed via browsers using HTTP.

  18. What is a URL and what are its main parts?

    URL (Uniform Resource Locator) is the address of a web resource. Its parts include the protocol (https), domain name (www.example.com), and path (/page).

  19. What is an IP address?

    An IP (Internet Protocol) address is a unique numerical label assigned to each device on a network to identify and locate it (e.g., 192.168.1.1).

  20. What is the function of DNS?

    DNS (Domain Name System) translates human-readable domain names (e.g., google.com) into machine-readable IP addresses.

Show the other 31 Computer Aptitude flashcards

  1. What is a web browser? Give examples.

    A web browser is application software used to access and view websites on the Internet. Examples: Google Chrome, Mozilla Firefox, Microsoft Edge, Safari.

  2. What is a search engine? Give examples.

    A search engine is a web service that searches the Internet for information based on keywords. Examples: Google, Bing, Yahoo, DuckDuckGo.

  3. What is the default file extension of an MS Word document?

    .docx (in Word 2007 and later; earlier versions used .doc).

  4. Which keyboard shortcut is used to save a document in MS Word?

    Ctrl + S.

  5. In MS Word, what does Ctrl + Z and Ctrl + Y do?

    Ctrl + Z performs Undo (reverses the last action); Ctrl + Y performs Redo (re-applies the undone action).

  6. What is the Mail Merge feature in MS Word?

    Mail Merge creates multiple personalized documents (like letters or labels) by combining a main document with a data source (such as a list of names and addresses).

  7. What is the shortcut to make text bold, italic, and underlined in MS Word?

    Ctrl + B (bold), Ctrl + I (italic), Ctrl + U (underline).

  8. What is a header and footer in MS Word?

    A header is text that appears at the top of every page; a footer appears at the bottom of every page (e.g., page numbers, dates, titles).

  9. What is the default file extension of an MS Excel workbook?

    .xlsx (in Excel 2007 and later; earlier versions used .xls).

  10. In MS Excel, what is a cell, row, and column?

    A cell is the intersection of a row and column where data is entered. Rows run horizontally (numbered 1, 2, 3); columns run vertically (lettered A, B, C). A cell reference combines them (e.g., A1).

  11. What does the SUM function do in Excel and how is it written?

    SUM adds a range of numbers. Syntax: =SUM(A1:A10) adds all values from cell A1 to A10.

  12. What is the difference between the AVERAGE and COUNT functions in Excel?

    AVERAGE returns the arithmetic mean of numeric values in a range; COUNT returns the number of cells containing numbers in a range.

  13. How does the IF function work in Excel?

    IF returns one value if a condition is true and another if false. Syntax: =IF(condition, value_if_true, value_if_false), e.g., =IF(A1>50,"Pass","Fail").

  14. What symbol must every Excel formula begin with?

    The equals sign (=).

  15. What is the difference between a relative and an absolute cell reference in Excel?

    A relative reference (A1) changes when copied to another cell. An absolute reference ($A$1) stays fixed when copied. The $ sign locks the row/column.

  16. What is the default file extension of an MS PowerPoint presentation?

    .pptx (in PowerPoint 2007 and later; earlier versions used .ppt).

  17. In PowerPoint, what is the difference between a transition and an animation?

    A transition is the visual effect when moving from one slide to the next. An animation is the effect applied to individual objects (text, images) within a slide.

  18. Which key starts a slideshow from the beginning in PowerPoint?

    F5 (Shift + F5 starts from the current slide).

  19. What is a Slide Master in PowerPoint?

    The Slide Master is the top slide that controls the overall formatting, layout, fonts, and design of all slides in the presentation, allowing global changes at once.

  20. What is the difference between a LAN and a WAN?

    A LAN (Local Area Network) connects devices within a small area like a building or campus. A WAN (Wide Area Network) connects networks over large geographic areas, such as cities or countries (the Internet is the largest WAN).

  21. What does MAN stand for and where does it fit between LAN and WAN?

    MAN stands for Metropolitan Area Network; it spans a city or large campus, larger than a LAN but smaller than a WAN.

  22. What is network topology? Name common types.

    Network topology is the physical or logical arrangement of devices in a network. Common types: Bus, Star, Ring, Mesh, and Tree.

  23. What is the function of a router in a network?

    A router connects different networks and forwards data packets between them, determining the best path using IP addresses.

  24. What is the difference between a hub and a switch?

    A hub broadcasts incoming data to all connected devices (less efficient). A switch sends data only to the specific intended device using MAC addresses (more efficient).

  25. What is a firewall in network security?

    A firewall is a security system (hardware or software) that monitors and controls incoming and outgoing network traffic based on predefined security rules to block unauthorized access.

  26. What is the difference between a virus and a worm?

    A virus attaches itself to a file/program and needs a host and human action to spread. A worm is standalone malware that self-replicates and spreads across networks without human intervention.

  27. What is phishing?

    Phishing is a cyber-attack where fraudsters impersonate legitimate entities (via fake emails/websites) to trick users into revealing sensitive information like passwords or bank details.

  28. What is encryption?

    Encryption is the process of converting plain readable data (plaintext) into a coded form (ciphertext) to prevent unauthorized access; it can only be read after decryption with a key.

  29. What is the difference between authentication and authorization?

    Authentication verifies who you are (e.g., login with password). Authorization determines what you are allowed to access or do after being authenticated.

  30. What is a protocol in networking?

    A protocol is a set of rules and standards that govern how data is transmitted and communicated between devices on a network.

  31. What is the difference between HTTP and HTTPS?

    HTTP (HyperText Transfer Protocol) transfers web data in plain text. HTTPS (HTTP Secure) adds SSL/TLS encryption for secure, protected communication. HTTP uses port 80; HTTPS uses port 443.

SBI PO Computer Aptitude FAQ

What is in the SBI PO Computer Aptitude syllabus?

SBI PO Computer Aptitude is split into 3 chapters: Basics of Computers, MS Office and Networking. Together they contain 9 topics.

How many chapters are in SBI PO Computer Aptitude?

3 chapters, containing 9 topics. The largest chapter is Basics of Computers, with 3 topics.

Are there flashcards for SBI PO Computer Aptitude?

Yes — a 51-card Computer Aptitude deck, printed in full in the flashcards section of this page and available in the Examius app with spaced repetition. The free plan covers one exam of your choice, including its flashcards; Examius Pro, a one-time purchase, unlocks every other exam and deck.