Examius
🇮🇳 SBI PO · flashcards
SBI PO Computer Aptitude Flashcards
51 question-and-answer cards covering Computer Aptitude as it is examined in SBI PO. 24 of them are printed below, taken from across the deck — no signup, no paywall on the preview.
24 sample cards from the Computer Aptitude deck
Sampled from the end of the deck, so these are different cards from the ones shown on the syllabus page.
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).
What is the default file extension of an MS Excel workbook?
.xlsx (in Excel 2007 and later; earlier versions used .xls).
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).
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.
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.
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").
What symbol must every Excel formula begin with?
The equals sign (=).
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.
What is the default file extension of an MS PowerPoint presentation?
.pptx (in PowerPoint 2007 and later; earlier versions used .ppt).
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.
Which key starts a slideshow from the beginning in PowerPoint?
F5 (Shift + F5 starts from the current slide).
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.
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).
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.
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.
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.
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).
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.
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.
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.
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.
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.
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.
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.
What this deck covers
The Computer Aptitude deck follows the SBI PO Computer Aptitude syllabus — 3 chapters and 9 topics — so questions land on material that is genuinely examinable rather than trivia around it. That works out to roughly 17.0 cards per chapter.
Answers are written to be recallable, not just readable — averaging about 139 characters, which is long enough to carry the reasoning and short enough to say out loud.
A deck like this earns its keep on the second and third pass. Read the syllabus first so you know the shape of the subject, then use the cards to find the specific facts that have not stuck.
Computer Aptitude flashcards FAQ
How many Computer Aptitude flashcards are in this SBI PO deck?
51 cards. This page previews 24 of them, sampled evenly across the deck so you can judge the difficulty before installing anything.
Are these SBI PO flashcards free?
Yes. The preview here is free to read with no signup, and the full 51-card deck is free inside the Examius app.
What do the Computer Aptitude cards cover?
They follow the SBI PO Computer Aptitude syllabus — 3 chapters and 9 topics — so the questions track what is actually examinable.
How should I use these flashcards?
Read the syllabus first so you know the shape of the subject, then drill the deck. Examius schedules each card with spaced repetition, so cards you keep missing come back sooner and ones you know drift further apart.