Computer Mcqs | For PPSC & FPSC | These are Mostly Revised Computer Mcqs From PPSC & FPSC Past Papers Taken from 10 Years PPSC Past Papers-includes All PPSC & FPSC Past Papers with All Topics To Be Covered in This,For More VIsit Okarians.
SQL stands for what in computer terminology?
Structured Query Language
SQL (Structured Query Language) is used to manage and manipulate data in relational databases.
Slide design option in MS PowerPoint is available under which toolbar?
Formatting Toolbar
The Slide Design option in PowerPoint is found on the Formatting Toolbar to apply visual themes and layouts.
Which of the following is not a valid text case option in MS Word?
Invalid Text Case Option
“Indent Case” is not a valid text case option. The correct options are Sentence, Uppercase, Lowercase, Capitalize Each Word, and Toggle Case.
Electronic devices developed after vacuum tubes were based on which component?
Transistor Era
Transistors replaced vacuum tubes in the second generation of computers, making them smaller and more efficient.
Errors from computer hardware and software can be identified and removed through which process?
Debugging Process
Debugging is the process of finding and resolving errors or bugs in hardware or software systems.
Where is BIOS stored in a computer system?
BIOS Storage
The BIOS (Basic Input/Output System) is stored in ROM or Flash memory on the motherboard, allowing the system to boot and load the operating system.
In which year was Amazon founded and by whom?
Amazon Foundation
Amazon was founded in 1994 by Jeff Bezos as an online bookstore and later expanded into the world’s largest e-commerce and cloud computing company.
From which tab can you insert a page number in Microsoft Word?
Insert Tab
In Microsoft Word, the Insert tab allows users to add page numbers, tables, images, headers, and other objects to their documents.
Optical fiber works on which scientific principle?
Total Internal Reflection
Optical fibers transmit light signals using total internal reflection, ensuring minimal signal loss over long distances.
Which Microsoft product is not available on the Linux operating system?
MS Access
Microsoft Access is not natively available for Linux systems, as it is a Windows-based database management application.
Which of the following represents the correct format of an email address?
Email Format
The correct email address format is name@website.com, consisting of a username, @ symbol, and domain name.
Which MS Word feature allows adding addresses and names automatically into documents?
Mail Merge
Mail Merge is used in MS Word to create personalized letters, emails, or labels by linking a document to a data source containing names and addresses.
Which formula is used in MS Excel to add values automatically?
AutoSum Function
The AutoSum function in Excel quickly adds a range of numbers and displays the total in the selected cell.
What is the purpose of the Citation and Bibliography tools in MS Word?
Citation and Bibliography
These tools help users manage and format references or sources within academic or research documents in MS Word.
What does the word “Attachment” mean in email communication?
Email Attachments
Attachments in emails allow users to send files such as videos, photos, or documents along with their message.
Which type of chart is shaped like a pie chart but used to organize data intuitively?
Bar Chart
A bar chart visually represents data using rectangular bars and is ideal for comparing categorical data.
Which Excel feature allows creating a dropdown list within a cell?
Data Validation
Data Validation helps restrict input in cells and allows creating dropdown lists for consistent data entry.
Who invented the computer mouse?
Douglas Engelbart
Douglas Engelbart invented the first computer mouse in 1964 as part of his work on human-computer interaction.
If you want to change the orientation of a document from Portrait to Landscape, which tab will you use in MS Word?
Page Layout Tab
In MS Word, you can change page orientation between Portrait and Landscape through the Page Layout tab under “Page Setup.”
By default, documents in MS Word are saved in which folder?
Default Save Location
MS Word saves documents in the “My Documents” folder by default unless the user changes the save location.
In email, how can you move a mail from the inbox without deleting it permanently?
Archive Option
Archiving an email removes it from your inbox but keeps it accessible in your account for future reference.
Google Drive is primarily used for what purpose?
Google Drive
Google Drive is a cloud storage service that allows users to store, share, and access files online securely.
What is the process of converting data into a code to prevent unauthorized access called?
Encryption
Encryption protects data by converting it into unreadable code, which can only be decrypted by authorized users.
What is the purpose of the MATCH function in Excel?
MATCH Function in Excel
The MATCH function returns the relative position of a specific item in a range, making it useful for lookup formulas.
Who is known as the Father of Microprocessor?
Father of Microprocessor
Marcian Hoff, with contributions from Federico Faggin and Stanley Mazor, developed the first microprocessor at Intel in 1971.
Who is known as the Father of Email?
Father of Email
Ray Tomlinson invented the email system in 1971 and introduced the use of the “@” symbol in email addresses.
Which semiconductor device amplifies signals while preserving their original shape?
Transistor
Transistors are used to amplify or switch electronic signals, maintaining the integrity of the original signal’s shape.
Who invented the first compiler in computer programming?
Grace Hopper
Grace Hopper invented the first compiler in 1951, revolutionizing computer programming by enabling high-level code translation.
Which coding language uses only binary numbers (0 and 1)?
Machine Language
Machine language uses binary code (0s and 1s) and is directly understood by a computer’s CPU.
Which shortcut key is used to save a PowerPoint presentation?
Ctrl + S
In PowerPoint and other Office applications, Ctrl + S quickly saves your current file or presentation.
What is the shortcut key for center alignment in MS Word?
Center Alignment
Press Ctrl + E in MS Word to center-align the selected text horizontally on the page.
Which shortcut key opens the Replace dialog box in MS Word?
Replace Dialog Box
Ctrl + H opens the Replace dialog box in MS Word, allowing you to find and replace specific words or phrases easily.
Which alignment option balances text evenly between the left and right margins?
Justify Alignment
The justify alignment distributes text evenly across the page, aligning it to both margins for a clean and professional look.
Which key is used to capture the picture of the whole screen?
Print Screen Key
The Print Screen key captures an image of your entire screen, which can be pasted into programs like Paint or Word for editing.
From which tab can you insert themes in a PowerPoint presentation?
Design Tab
In PowerPoint, themes and background styles can be applied from the Design tab to enhance presentation visuals.
Through which tab can you insert a new slide in PowerPoint?
Insert Tab
The Insert tab in PowerPoint allows you to add new slides, pictures, charts, and various elements to enhance your presentation.
What is the main purpose of a slideshow in PowerPoint?
Purpose of a Slideshow
A slideshow is used to display presentation slides sequentially during a presentation, making it easier to communicate ideas visually.
What is another name for junk email?
Spam Email
Unsolicited or irrelevant emails sent in bulk to multiple recipients are commonly known as spam or junk mail.
What is the shortcut key for Superscript in MS Word?
Superscript Shortcut
Pressing Ctrl + Shift + + in MS Word changes the selected text into superscript — smaller text raised above the baseline.
Which online technique is used to steal usernames and passwords?
Phishing
Phishing is a cyber technique where fake emails or websites are used to deceive users into revealing sensitive information such as passwords or credit card details.
Which PowerPoint view displays slide thumbnails on the left and the current slide in a large window?
Normal View
Normal view shows the current slide with smaller thumbnails of all slides on the left side for easy navigation and editing.
Arrow keys on the keyboard are called?
Navigation Keys
Arrow keys are used to move the cursor or selection in the direction indicated — up, down, left, or right — hence called navigation keys.
Which option allows you to print multiple slides on one page in PowerPoint?
Handout Option
The handout print layout allows printing multiple slides on a single sheet of paper, ideal for summaries or lecture notes.
In email communication, “Cc” stands for?
Carbon Copy (Cc)
“Cc” in an email allows the sender to send a copy of the message to additional recipients, just like carbon copies in letters.
Who invented the first digital computer?
John Vincent Atanasoff
John Vincent Atanasoff, along with Clifford Berry, developed the first electronic digital computer in the late 1930s — the Atanasoff–Berry Computer (ABC).
Which Excel formula is used to enter the current date and time?
Excel Function =NOW()
The =NOW() function in Excel displays both the current date and time, updating automatically whenever the worksheet recalculates.
In PowerPoint, what is the Transition option used for?
Transitions in PowerPoint
Slide transitions control how one slide moves to the next during a presentation, creating smooth visual effects.
Which symbol is used in an email address to separate the username from the domain name?
@ Symbol
In every email address, the “@” symbol separates the username from the domain, e.g., user@example.com.
Docx is a symbol of which type of file?
.docx File Extension
The .docx extension identifies a Microsoft Word document created in versions from Office 2007 onwards.
By which tab can we insert a picture in PowerPoint?
Insert Tab
The “Insert” tab in PowerPoint allows users to add pictures, videos, tables, and other objects to slides.
Who is considered the father of the computer?
Charles Babbage
Charles Babbage designed the first mechanical computer, known as the Analytical Engine, earning him the title “Father of the Computer.”
Which of the following is used to create a PowerPoint presentation the fastest?
Auto Content Wizard
The Auto Content Wizard in PowerPoint provides ready-made templates to create presentations quickly and easily.
Which of the following methods cannot be used to edit the contents of a cell in Excel?
Alt Key
The Alt key is not used for editing in Excel — it activates menu shortcuts instead of cell content editing.
What is the shortcut key for Print Preview in MS Office applications?
Ctrl + F2
In MS Office, the shortcut Ctrl + F2 opens the Print Preview window to check document layout before printing.
A webpage has a unique address called what?
URL
A URL (Uniform Resource Locator) is the unique address of a webpage on the internet.
Which key is used to create a chart quickly in Excel?
F11
Pressing F11 in Excel instantly creates a chart based on the selected data in a new worksheet.
Which PowerPoint view displays only text such as titles and bullet points?
Outline View
Outline View in PowerPoint displays only the slide text — titles and bullet points — without graphics or images.
What is the smallest unit in a digital system?
Bit
A bit (binary digit) is the smallest unit of digital information, representing either 0 or 1.
Multiple users can access the mainframe computer through what type of devices?
Terminals
Mainframes support multiple users simultaneously using terminals that access the central system for data processing.
What is the function of the Enter key on a keyboard?
Enter Key
The Enter key is used to begin a new line or paragraph in text-based applications.
Cropping is the process of removing the unwanted part of what?
Cropping
Cropping removes the unnecessary parts of an image to focus on the desired portion.
When you open a new worksheet in MS Excel, which of the following appears on the top?
Menu Bar
In MS Excel, the Menu Bar appears at the top, providing access to options like File, Insert, and View.
Which application is used for checking grammar and spelling?
Word Processor
Word processors like MS Word include built-in grammar and spelling check tools to improve document accuracy.
MS PowerPoint is used for which of the following purposes?
Create Presentations
Microsoft PowerPoint is primarily used for creating slide-based presentations for educational or business use.
What happens when you insert a new row in Excel?
Row Movement
When a new row is inserted, Excel automatically moves the existing rows downward to make space for new data.
What does the “PROPER” text function do in MS Excel?
PROPER Function
The PROPER function in MS Excel capitalizes the first letter of each word, making text look like a proper title.
Which tab is NOT available on the left panel when you open a presentation in PowerPoint?
Notes Tab
In PowerPoint, the left panel typically includes the “Slides” and “Outline” tabs — the “Notes” tab is not displayed there by default.
What type of software is Windows 10?
System Software
Windows 10 is an operating system, which is a type of system software that manages hardware and application interactions.
What is another term for free software?
Public Domain Software
Public domain software is free to use, distribute, and modify without any restrictions or licensing fees.
Which option converts a Word file into PDF in MS Word?
Save As
In MS Word, you can convert a document to PDF using the “Save As” option and selecting PDF as the file format.
Which of the following is called a low-level programming language?
Assembly Language
Assembly language is a low-level language that interacts directly with a computer’s hardware through symbolic code.
What is the storage capacity of a standard floppy disk?
Floppy Disk Capacity
A standard 3.5-inch floppy disk could store up to 1.44 MB of data, which was once commonly used for transferring small files.
What is a single page of a PowerPoint presentation called?
Slide
Each PowerPoint presentation consists of multiple slides — each slide acts as one page of your presentation content.
How many bits are equivalent to 4 bytes?
32 Bits
1 byte = 8 bits, so 4 bytes equal 8 × 4 = 32 bits.
In C and C++ programming, which symbol is used to access the value stored at a memory address?
Asterisk (*)
In C/C++, the * operator is known as the dereference operator and is used to access the value stored at a specific memory address.
A __________ is a software program used to view webpages on the internet.
Web Browser
A web browser such as Chrome, Firefox, or Edge allows users to access and navigate websites on the World Wide Web.
What is processed by the computer into information?
Data
Raw facts and figures (data) are processed by a computer to produce meaningful information.
1024 Kilobytes is equal to how many Megabytes?
1 MB
1024 Kilobytes make one Megabyte, which is a standard digital storage conversion.
Which of the following is the default page setup orientation in MS Word?
Portrait Orientation
By default, MS Word documents use the Portrait layout where the page height is greater than its width.
Which among the following is the smallest heading style by default?
H4
HTML heading tags decrease in size from H1 (largest) to H6 (smallest). H4 is smaller than H1–H3.
What is the shortcut key for clearing all formatting in MS Word?
Ctrl + Spacebar
Ctrl + Spacebar removes all text formatting, reverting it to the default style in MS Word.
In MS Word, the Home key moves the cursor to which position?
Beginning of the Line
Pressing the Home key in MS Word moves the cursor to the beginning of the current line.
What is the function of the shortcut Ctrl + 5 in MS Word?
Sets Line Spacing to 1.5
In MS Word, pressing Ctrl + 5 changes the line spacing to 1.5 lines.
A database that contains tables linked by common fields is called what?
Relational Database
A relational database organizes data into tables connected by shared key fields, allowing complex data relationships.
Which of the following does NOT exist in a PowerPoint slide layout?
Animations
Animations are effects applied later, not part of the default PowerPoint slide layout structure.
What is the maximum default font size available in MS Word?
72
The default maximum font size in MS Word is 72 points, though larger sizes can be typed manually.
From which of the following can a user account be changed in Windows?
Control Panel
In Windows, user accounts can be added, removed, or modified using the Control Panel’s User Accounts section.
“Add or Remove Programs” is an example of which type of software?
Utility Program
“Add or Remove Programs” in Windows is a utility program used for uninstalling or modifying installed software.
The output displayed on a computer’s monitor is considered what type of copy?
Soft Copy
Information displayed on a monitor is called a soft copy, while printed data is called a hard copy.
The different generations of computers are classified based on what?
Memory and Microprocessor
Computer generations are mainly classified based on the development of memory technology and microprocessors.
What is the short-term memory of a computer called?
RAM
RAM (Random Access Memory) is the short-term memory of a computer that temporarily stores data for active processes.
Which one is a Hypertext language?
HTML
HTML stands for HyperText Markup Language — it is the standard language used to create and structure web pages.
MS Word and MS Excel are examples of what type of software?
Application Software
MS Word and MS Excel are application software designed for word processing and spreadsheet management.
The graph used to show data on a nominal scale is called?
Pie Graph / Bar Chart
Nominal data is represented visually using pie or bar charts to compare categories effectively.
A set of instructions that directs a computer’s hardware to perform a task is called?
Program or Software
A software program is a set of coded instructions that tell the hardware how to perform specific tasks.
What does CPU stand for?
CPU (Central Processing Unit)
The CPU is the brain of the computer responsible for executing instructions and processing data.
In MS Excel 2016, which shortcut key combination takes you to cell A1?
Ctrl + Home
In MS Excel, pressing Ctrl + Home instantly moves the cursor to the top-left corner of the worksheet (cell A1).
Which of the following is a volatile memory in computers?
RAM (Volatile Memory)
RAM loses all stored data when power is turned off, which makes it a volatile type of memory.
Which shortcut key is used to align selected text to the left in MS Word?
Ctrl + L
Ctrl + L is the shortcut used to align text to the left margin in MS Word.
Where is the “Add New Hardware” option found in Windows?
Control Panel
The “Add New Hardware” wizard in older Windows versions is found within the Control Panel settings.
In Windows, which program functions as the file manager?
Windows Explorer
Windows Explorer (now called File Explorer) allows users to navigate and manage files and folders on the system.
In PowerPoint, what are the effects that determine how a slide enters or exits during a presentation called?
Slide Transitions
In PowerPoint, transitions are visual effects that determine how slides move in and out of view during a slideshow.
Which of the following does NOT belong to the class size of computers?
Digital Computer
Digital computers are classified by technology, not by size — categories like micro, mini, mainframe, and super are size-based classifications.
What is the total number of columns in a Microsoft Excel worksheet?
16,384 Columns
In modern versions of Excel, there are 16,384 columns, labeled from A to XFD.
All peripheral devices of a computer are connected to which main component?
Motherboard
All peripheral devices like keyboard, mouse, and printer are connected via ports and slots on the motherboard.
Which device is used to enter data into the computer system?
Input Devices
Input devices like keyboards, mice, and scanners allow users to send data and commands to the computer.
Which software is used to convert a .doc file into a PDF?
Convert DOC to PDF
A .doc file can be converted to PDF using MS Word’s “Save As PDF” option or Adobe Acrobat Export tools.
The F7 key is commonly used for?
F7 Key Function
In MS Word and PowerPoint, pressing F7 runs the Spelling and Grammar check feature for your document.
Which PowerPoint feature applies motion effects to different objects of a slide?
Animation Scheme
In PowerPoint, the Animation Scheme feature allows adding motion and visual effects to text or objects on slides.
Which type of malware is a program that loads onto a computer without the user’s knowledge and runs against their wishes?
Computer Virus
A virus is a malicious program that installs without consent, replicates, and can harm or modify files and data.
Which key is used to toggle the display of the ribbon in MS Office?
Ctrl + F1
Pressing Ctrl + F1 in MS Office hides or displays the ribbon, providing more workspace on the screen.
Which button is used to go to a different slide, file, website, or sound in PowerPoint?
Action Button
In PowerPoint, the Action button allows linking slides, files, websites, or sounds for interactive presentations.
Whereas a computer mouse moves over the table surface, the trackball is?
Trackball
Unlike a mouse, a trackball remains stationary, and the user rotates the ball to move the pointer on the screen.
To connect to the internet, the computer must be connected to a/an?
Internet Service Provider
An ISP provides the connection and access to the global internet network for users and organizations.
Cell entry “July 16, 1982” will be considered as what in Excel?
Value
Excel recognizes date entries like “July 16, 1982” as a value type, used in calculations and formatting.
Which key on the keyboard is used to start a slide show in PowerPoint?
F5 Key
Pressing F5 in PowerPoint launches the slideshow from the first slide instantly.
The term DNS stands for?
Domain Name System
DNS (Domain Name System) translates website domain names like “google.com” into IP addresses that computers understand.
The Header and Footer commands are located under which tab in MS Word?
Insert Tab
In MS Word, the Insert tab provides options to add Headers, Footers, Page Numbers, and other elements to your document.
Time taken by a computer to process a job or instruction is called?
Execution Time
Execution time refers to the total time a computer takes to complete a particular instruction or task.
A set of possible data values is called?
Domain
In database terminology, a domain defines the set of all possible values that an attribute can hold.
Which of the following is not an operating system?
Oracle
Oracle is a database management system, not an operating system. Windows, Linux, and macOS are examples of OS.
Which key is used for Help in PowerPoint?
Help Key (F1)
Pressing F1 opens the PowerPoint Help window where you can search for assistance on any feature.
One byte equals to how many bits?
1 Byte = 8 Bits
A byte is made up of 8 bits. Each bit is a binary digit representing either 0 or 1.
In a computer, processed data is known as?
Information
When data is processed and organized meaningfully, it becomes information that can be used for decision-making.
1 Gigabyte is equal to?
1 GB = 1024 MB
In computing, 1 gigabyte equals 1024 megabytes, based on binary measurement (2¹⁰).
How many relations may exist between tables in databases?
Three Types of Relationships
There are three main types of relationships in databases: One-to-One, One-to-Many, and Many-to-Many.
What is the default name of a newly created MS Word file?
Document 1
When a new MS Word file is created, it is automatically named “Document 1” until the user saves it with a custom name.
Which keyboard shortcut is used to switch between open applications in Windows 10?
Alt + Tab
Pressing Alt + Tab allows users to quickly switch between open windows or apps in Windows 10.
When a peripheral device needs immediate attention from the operating system, it generates what?
Interrupt
An interrupt is a signal sent by a hardware device to the CPU requesting immediate attention or service.
A character that is raised and smaller above the baseline is known as?
Superscript
A superscript is text raised slightly above the normal line, often used in mathematical formulas or footnotes (e.g., x²).
Which of the following is not a valid data type in Excel?
Character Type
Excel supports Number, Text, Date, and Boolean types, but “Character” is not recognized as a valid data type.
Physical part of a computer is called?
Hardware
All physical components of a computer such as keyboard, monitor, and CPU are known as hardware.
File extension of MS Word is?
.docx
MS Word saves files with the .docx extension, introduced in Office 2007 as part of the XML-based format.
In Microsoft Office, the options “Portrait” and “Landscape” come under which setting?
Page Orientation
In MS Word, “Portrait” and “Landscape” are orientation settings under the Page Layout tab, controlling page direction.
Which language is primarily used in computers?
Machine Language
Machine language is the fundamental binary language that the computer’s CPU understands directly.
If you want to calculate maximum value in Excel sheet, which command should you select?
MAX Function
The MAX function in MS Excel is used to find the highest numeric value in a selected range of cells.
