Computer Mcqs | For PPSC & FPSC | Most Important for All Competitve Exam Thats includes All PPSC & FPSC Exam and These are Taken from Past Papers with All Topics To Be Covered in This.For More VIsit Okarians.
In MS Excel 2016, where can you set or clear the print area of a worksheet?
Page Layout Tab
In MS Excel 2016, the print area can be defined or cleared under the “Page Layout” tab.
When formatting a cell in currency in MS Excel, which options can you specify?
Currency Format Options
You can specify decimal places and the currency symbol while formatting a cell in MS Excel.
To open a template in Microsoft Word, which option should be selected after opening the File tab?
Click New
To open or create a new document from a template, you must go to File → New in MS Word.
Which shortcut key allows you to move between worksheets in an Excel workbook?
Ctrl + Page Down
You can move to the next worksheet in an Excel workbook using Ctrl + Page Down.
What is the main function of BIOS in a computer system?
Loading Operating System
BIOS (Basic Input/Output System) initializes and loads the operating system when the computer is powered on.
A computer network that covers a large geographical area such as a city or country is called?
WAN (Wide Area Network)
A Wide Area Network connects multiple LANs across large distances, often using public or leased networks.
Which shortcut creates a new folder in a Windows directory?
Ctrl + Shift + N
In Windows, pressing Ctrl + Shift + N instantly creates a new folder in the current directory.
Incoming messages in an email account are stored in which folder by default?
Inbox Folder
All new incoming emails are automatically received and stored in the Inbox folder by default.
Which technique is used to send multiple signals over a single communication line?
Multiplexing
Multiplexing combines multiple signals into one medium for efficient data transfer.
Which shortcut keys are used to lock the keyboard in Windows?
Windows Logo + L
Pressing Windows + L locks your computer and returns it to the login screen instantly.
What is the full form of LED?
Light Emitting Diode
LED stands for Light Emitting Diode — a semiconductor device that emits light when an electric current passes through it.
In MS Word 2016, the ‘Watermark’ option is available under which tab?
Insert Tab
The Watermark feature in MS Word allows users to insert background text or images behind content pages.
In MS Excel 2016, the ‘Conditional Formatting’ option is available under which menu?
Home Tab
Conditional Formatting in Excel is found under the Home tab, allowing color-based visual cues based on cell values.
In MS Word 2016, which shortcut key is used to view a ‘Print Preview’ of a document?
Alt + Ctrl + I
Pressing Alt + Ctrl + I in MS Word toggles the Print Preview mode for checking page layout before printing.
“Adobe Flash” is an example of which type of software?
Multimedia Software
Adobe Flash was widely used for creating animations, interactive content, and web videos before HTML5 replaced it.
Which of the following line spacing options is invalid in MS Word?
Triple Line Spacing
MS Word supports single, 1.5, and double line spacing by default. “Triple” spacing is not a built-in option.
The orientation of the page in MS Word can be changed from which tab?
Layout Tab
Page orientation (Portrait or Landscape) can be adjusted under the Layout tab in the Page Setup section of MS Word.
In computing, which of the following connects two similar network segments?
Bridge
A Bridge connects two similar LAN segments, reducing network traffic by dividing it into collision domains.
Which program is run by BIOS to check hardware components when a computer is turned on?
Power-On Self-Test (POST)
POST runs automatically when the computer starts to verify that memory, disks, and other hardware components are working correctly.
Ctrl, Shift, and Alt keys are collectively known as:
Modifier Keys
Modifier keys are used with other keys to perform special functions, such as shortcuts and command combinations.
CRT stands for:
Cathode Ray Tube
CRT monitors display images by firing electron beams onto a phosphorescent screen, used before modern LCDs and LEDs.
A Word template stores common document:
Document Structure
A Word template contains predefined document structure, styles, and formatting used to create consistent layouts quickly.
A Terabyte represents approximately how many bytes?
1 Trillion Bytes
A Terabyte (TB) is equal to approximately 1 trillion bytes, commonly used to measure large data storage capacities.
In a computer, data is permanently stored in which component?
Hard Disk
Data is permanently stored on the Hard Disk Drive (HDD), even when the computer is powered off.
Can Excel worksheet data be linked to a Word document using copy and paste?
Paste Special / Object Linking
To link Excel data to Word, use Paste Special → Link or embed as an object. Simple copy-paste won’t maintain live data connection.
What is the shortcut key to extend your current text selection by one word to the left in MS Word?
Ctrl + Shift + Left Arrow
In MS Word, Ctrl + Shift + Left Arrow extends the selection one word to the left — useful for fast editing or formatting.
Which option is not available in the Font Spacing settings of MS Word 2016?
Loosely
MS Word offers Normal, Condensed, and Expanded spacing — “Loosely” is not an available option.
In MS Access, the Form Wizard can build forms that display fields from how many tables or queries?
Multiple Tables or Queries
MS Access’s Form Wizard allows users to create forms that combine data from multiple tables or queries for detailed reports.
In MS Word 2016, a toolbar contains buttons, boxes, and menus that allow tasks to be performed more quickly than using the menu bar. What is it called?
Tool Bar
Tool Bar provides quick access to commonly used commands, tools, and options in MS Word for faster task execution.
What is the maximum zoom percentage available in Microsoft PowerPoint?
400%
The maximum zoom level in PowerPoint is 400%, allowing users to focus on detailed elements of a slide.
Which type of printer produces the best quality graphics output?
Plotter
Plotters are used for high-quality graphical output, such as engineering drawings and architectural blueprints.
To insert a blank embedded Word object in Excel, which option should you select?
Insert Object
To embed a Word document in Excel, click Insert → Object and select “Microsoft Word Document.”
How can you close a Word document without closing the Word window?
Close Command
In MS Word, use the Close command to close the current document while keeping the application open.
CAI stands for what in computer education?
Computer Assisted Instruction
Computer Assisted Instruction (CAI) refers to teaching and learning processes supported by computer software applications.
In Excel, to create a formula, you can use cell references but not what?
Values
In Excel, formulas are typically created using cell references to keep calculations dynamic, not fixed numerical values.
A cell entry “July 16, 2016” will be considered as what type of data in Excel?
Value
Excel recognizes date entries such as “July 16, 2016” as a Value that can be used in date and time calculations.
Using information systems to perform an activity cheaper, faster, and more accurately is called?
Automation
Automation means using information systems or technology to perform tasks efficiently with minimal human intervention.
Larry Page is best known for being one of the co-founders of which company?
Larry Page – Google Co-founder
Larry Page co-founded Google with Sergey Brin in 1998, revolutionizing how people access and search information online.
Who is the creator of the Linux operating system?
Linus Torvalds
Linus Torvalds created the Linux operating system kernel in 1991, which became the foundation for many open-source systems worldwide.
Which of the following is a valid program to access the internet?
Google Chrome
Google Chrome is a web browser used to access websites and internet content efficiently and securely.
In PowerPoint 2016, the “Rehearse Timing” option is available in which tab?
Slide Show Tab
The Rehearse Timings option in PowerPoint is located in the Slide Show tab to help practice and record slide timings.
Which type of software is used to draw pictures, 3D images, and animations?
Graphic Software
Graphic Software allows users to create and edit images, 3D designs, and animations, commonly used in multimedia production.
In computer communication, the process of verifying user identity is called?
Authentication
Authentication is the process of verifying the identity of a user or device before granting access to a system or network.
How can the risk of unauthorized computer system access be reduced when connected to the internet?
Firewall Protection
A firewall acts as a barrier between your computer and external networks, preventing unauthorized access and data breaches.
What is the full form of Wi-Fi?
Wireless Fidelity
Wi-Fi stands for Wireless Fidelity and allows wireless connection to the internet using radio signals.
Common methods of internet access include which of the following?
DSL
DSL (Digital Subscriber Line) is a common broadband technology that provides internet access over telephone lines.
What is data that changes continuously and can have discrete values called?
Continuous Data
Continuous data can take infinite values within a range and often changes over time, such as temperature or speed readings.
A file that contains information such as an image or music is called?
File
A file in computing stores data like text, images, videos, or music in digital format.
What does IBM stand for?
International Business Machines
IBM stands for International Business Machines, one of the world’s leading technology and consulting companies.
In banks, the data on cheques is read by which device?
MICR
MICR (Magnetic Ink Character Recognition) is used in banks to read the printed numbers and codes on cheques accurately.
Which element in MS Word displays the positioning of text, tabs, margins, indents, and other layout elements on the page?
Ruler
The Ruler in MS Word helps users align text, adjust margins, and set tab stops for proper document layout.
When assigning a shortcut key to a symbol in MS Word, what should you ensure?
Unassigned Shortcut Key
When creating custom shortcuts in MS Word, always use a key combination that is not already assigned to another function.
What maintains a database of webpages containing information on various topics?
Search Engine
Search engines like Google or Bing maintain massive databases of indexed webpages, allowing quick retrieval of online information.
Which text alignment style is commonly used in newspapers, magazines, and novels?
Full Justification
Full Justification ensures text lines up evenly on both the left and right margins, commonly used for print media formatting.
Which of the following is NOT a binary number?
102
Binary numbers only contain 0s and 1s. The presence of 2 in “102” makes it non-binary.
The contents of two or more consecutive cells in Excel can be combined using which option?
Merge Cells
The Merge Cells feature in Excel combines multiple adjacent cells into a single larger cell, often used for headings.
In MS Excel, the Insert tab includes which feature?
Chart
The Insert Tab in Excel allows you to add elements such as charts, tables, images, and shapes to your worksheet.
Readymade templates in Microsoft applications are available under which option?
File Tab
In Office applications like Word and PowerPoint, readymade templates can be accessed from the File tab when creating a new document.
The distinguishing feature of a spreadsheet program is that it allows you to:
Perform Calculations
Spreadsheet programs like Excel allow users to perform calculations, apply formulas, and analyze numeric data efficiently.
Which mode allows users to enter new data at the current cursor position?
Insertion Mode
In Insertion Mode, any new text or data entered appears at the current cursor location without replacing existing content.
In MS Word 2016, which shortcut key is used to replace text or specific formatting?
Ctrl + H
The Ctrl + H shortcut in MS Word opens the “Find and Replace” dialog box to replace words or formatting.
A file that contains ready-made styles used for a presentation is called?
Template
A template is a pre-designed presentation file that includes formatting, color, and style themes for slides.
In MS PowerPoint, the Slide Master option is available in which tab?
View Tab
The Slide Master option in PowerPoint is found under the View tab for editing global slide layouts.
What are the effects that occur when you move from one slide to another called?
Slide Transitions
Slide Transitions are motion effects used to change from one slide to another during a PowerPoint presentation.
The WordArt option in PowerPoint exists under which category?
WordArt – Text Tools
In PowerPoint, WordArt is found under the Text category to insert decorative text effects.
What is the area called that contains My Computer, My Documents, and Recycle Bin?
Desktop
The desktop is the main screen area in Windows that contains icons such as My Computer, Recycle Bin, and file shortcuts.
From which of the following can a user account be changed in Windows?
Control Panel
User accounts and system settings can be managed from the Control Panel in Windows OS.
In MS Windows, which of the following is a program group?
Windows Accessories
Accessories is a default Windows program group containing tools like Notepad, Paint, and Calculator.
A common name for software errors is?
Software Bugs
The term bug refers to programming errors or flaws that cause incorrect results or behavior.
What are instructions that tell a computer what to do called?
Software Instructions
Software consists of programs and instructions that tell the computer how to perform specific tasks.
“Add or Remove Programs” in Windows is a type of?
Utility Program
Utility programs help manage system functions such as software installation, removal, and maintenance.
What is the shortcut key to switch to the next open window in Windows?
Alt + Tab
Pressing Alt + Tab allows users to switch quickly between open applications in Windows OS.
What is the shortcut key to insert a hyperlink in Microsoft PowerPoint?
Ctrl + K
In PowerPoint, the shortcut Ctrl + K is used to insert or edit a hyperlink to another slide, file, or website.
What is the name of the programs that control the hardware of a computer?
Device Drivers
Device drivers act as translators between the operating system and computer hardware, ensuring proper functioning of peripherals.
In which menu of PowerPoint can you find Slide Design and Slide Layout options?
PowerPoint Format Menu
In older versions of PowerPoint, Slide Design and Slide Layout are found under the Format menu.
What does a red triangle in an Excel cell indicate?
Excel Cell Indicators
A red triangle in Excel indicates a comment or validation error, showing there’s an issue or note in that cell.
Which type of operating system processes data in very small time intervals?
Real Time OS
A Real-Time Operating System (RTOS) ensures immediate processing and response — used in robotics, aviation, and real-time control.
In a computer, what does OS stand for?
Operating System
The Operating System manages hardware, software, and user interaction — examples include Windows, Linux, and macOS.
How can you start Microsoft PowerPoint application using the Run command?
Starting PowerPoint
To open PowerPoint via Run, type powerpnt and press Enter. It launches Microsoft PowerPoint directly.
To get connected with the internet, which device must be connected?
Internet Connection
A modem (modulator-demodulator) is essential to connect a computer to the internet through an ISP.
In MS Excel 2016, how can you duplicate values in a selected cell range?
Duplicate Values in Excel
To duplicate data, select the cell range and drag the fill handle (small square at the cell’s corner).
In MS Excel, comments put in cells are called:
Excel Comments
In Excel, inserted comments are shown as small red triangles and called Cell Tips.
Which component acts as a buffer between the CPU and main memory?
Cache Memory
Cache memory temporarily stores data to bridge speed differences between the CPU and RAM.
The first cell in an Excel worksheet is labelled as:
Excel Cell Reference
The first cell in an Excel sheet starts at column A and row 1, labelled as A1.
Which of the following is not an operating system?
Non-Operating System
Oracle is a database management system, not an operating system.
Integrated circuits (IC) chips used in computers are made with:
Silicon Chips
Silicon is the semiconductor material used to manufacture integrated circuit chips due to its conductive properties.
What is the storage capacity of a two-sided DVD?
DVD Capacity
A standard double-sided DVD can hold up to 9.4 GB of data, double that of a single-sided disc.
To move to the previous cell in a table inserted in a document, which key combination is used?
Shortcut Key: Shift + Tab
Pressing Shift + Tab moves the cursor to the previous cell in a Word table, while Tab moves forward.
