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.
To add two cells (A1 and A2) together in MS Excel, which formula is used?
Read More With Details
In MS Excel, typing “=A1+A2” adds the values of the two referenced cells. Every formula in Excel starts with an equals sign (=).
Which one is the spreadsheet application that comes with the MS Office software group?
Read More With Details
Microsoft Excel is a spreadsheet program included in the MS Office suite. It is used for organizing, analyzing, and visualizing data.
Microsoft Excel function arguments are always written in:
Read More With Details
All Excel functions enclose their arguments within parentheses, e.g., =SUM(A1:A5).
What is the shortcut key to mark a citation in MS Word?
Read More With Details
In MS Word, pressing Alt + Shift + I opens the Mark Citation dialog box for creating references in a document.
Which of the following is not an essential component to perform a Mail Merge operation?
Read More With Details
Mail Merge in MS Word requires a main document, a data source, and merge fields. “Word Fields” are not required.
Which menu or group is used if you want to change the typeface of selected text?
Read More With Details
The Format Menu in MS Word allows users to change the typeface, size, and style of selected text.
In MS Excel, the formula used to perform calculations in the worksheet can be inserted with the help of:
Read More With Details
In MS Excel, the “Insert Function” or “fx” icon helps users to insert formulas quickly and choose from a list of available functions.
Where is a list of all functions displayed in MS Excel?
Read More With Details
Excel’s Function Box lists all available functions, allowing users to easily select and insert them into formulas.
Main window in a computer spreadsheet is called:
Read More With Details
In MS Excel, the workbook is the main file that contains one or more worksheets for data entry and analysis.
In MS Excel, two common wildcard characters recognized are:
Read More With Details
Excel uses * (asterisk) to represent any number of characters and ? (question mark) for a single character when filtering or searching.
The process of verifying the identity of a user is termed as:
Read More With Details
Authentication is the process of verifying who a user is, typically using passwords, PINs, or biometric verification.
PIN stands for:
Read More With Details
PIN stands for Personal Identification Number, used to authenticate a user’s identity in digital or banking systems.
For hearing and playing sound, which device is required?
Read More With Details
A sound card processes audio signals, and speakers output the sound, enabling audio playback on computers.
Which command is used to generate a series of data directly from the values of the selected cells in Excel?
Read More With Details
The Fill command in Excel is used to automatically continue a series based on selected cell patterns, like numbers or dates.
By default, the orientation of a document when printing is:
Read More With Details
By default, Word prints documents in Portrait orientation. This can be changed to Landscape via Page Layout options.
The most commonly used type of software in industry, offices and WAN is:
Read More With Details
Horizontal market software is designed for a wide range of industries, like word processors or spreadsheets used in all offices.
After creating a table in a database, which of the following is correct?
Read More With Details
In most database software, you can modify the structure of a table by adding, deleting, or editing fields as needed.
Ctrl + S is used to:
Read More With Details
Ctrl + S quickly saves the active document using its current name and location without opening the Save As dialog.
In which of the following storage devices data is stored permanently?
Read More With Details
A hard disk stores data permanently, even when the power is turned off, unlike RAM or cache memory which are volatile.
Which of the following is the smallest unit of information that a computer can process?
Read More With Details
A bit (binary digit) is the smallest unit of data in computing and can represent either 0 or 1.
The process of copying software from secondary storage to the hard disk is called:
Read More With Details
Installation is the process of copying and setting up software programs onto a computer’s hard drive for use.
Which of the following keys is used to refresh the content on a computer screen?
Read More With Details
The F5 key refreshes the contents of a page or window, reloading it to display updated information.
Which of the following controls the process of interaction between the user and the operating system?
Read More With Details
The User Interface (UI) manages communication between the user and the operating system, allowing commands to be issued and responses displayed.
Any data or instruction entered into the memory of a computer is considered as:
Read More With Details
Input refers to the process of entering data or instructions into a computer for processing.
What should be done after fixing a problem or installing a new application or making configuration changes in a computer?
Read More With Details
Restarting ensures that configuration changes or software installations take effect properly by reloading the operating system.
Circular divisions of a disk used to store and retrieve data are known as:
Read More With Details
A track is a circular path on the surface of a disk where data is magnetically recorded and read.
Which of the following is the file extension of the PowerPoint application?
Read More With Details
PowerPoint presentations are saved with the file extension .ppt (or .pptx in newer versions).
Which of the following shortcut keys is used to close a tab on a browser?
Read More With Details
Pressing Ctrl + W in a web browser closes the current active tab instantly.
A feature that automatically corrects common spelling errors is called:
Read More With Details
AutoCorrect automatically fixes commonly misspelled words and typing mistakes while typing in Word or Excel.
In MS Excel, what is a function inside another function called?
Read More With Details
A nested function in Excel occurs when one function is placed inside another to perform more complex calculations.
Which of the following does not belong to queues for processes?
Read More With Details
PCB (Process Control Block) is not a queue; it is a data structure containing process information like state, ID, and resources.
Which key is used for Help in MS Word?
Read More With Details
Pressing F1 in MS Word opens the Help pane, allowing users to search for guidance and troubleshooting information.
You can organize files by storing them in:
Read More With Details
Folders help users organize related files together, making data management and retrieval easier.
What kind of memory is both static and non-volatile?
Read More With Details
ROM (Read Only Memory) is non-volatile, retaining data even when the power is off, and is considered static because its contents do not change.
In MS Excel 2016, the function =NOW() is used to:
Read More With Details
The =NOW() function in Excel returns the current system date and time, updating automatically when the sheet recalculates.
A word processor would most likely be used to type a:
Read More With Details
Word processors like MS Word are designed for creating, editing, and formatting text documents such as letters or biographies.
An optical disk is an electronic data storage medium that can be written to and read from using a:
Read More With Details
Optical disks like CDs and DVDs use low-powered laser beams to read and write data on their reflective surface.
Which of the following is not a valid data type in MS Access?
Read More With Details
MS Access does not include a “Picture” data type; images are stored using the OLE Object or Attachment type instead.
To restore the last undone action, which option is used?
Read More With Details
The Redo command reverses the most recent Undo action, restoring the previously undone change.
The processed output given by a computer is also called:
Read More With Details
After processing data, the meaningful result produced by a computer is called information.
In MS Excel, what should be added before a fraction to prevent it from being treated as a date?
Read More With Details
Adding a space before a fraction (e.g., ” 1/2″) in Excel prevents it from being automatically formatted as a date.
The shortcut key to insert a new worksheet in MS Excel is:
Read More With Details
Pressing Shift + F11 quickly adds a new worksheet to the current Excel workbook.
Which key combination is used in MS Excel to insert the current time?
Read More With Details
Pressing Ctrl + Shift + ; inserts the current system time into the selected Excel cell.
Which key is used for moving one screen down in MS Word?
Read More With Details
The Page Down key scrolls the MS Word document down by one full screen of text.
Microprocessor is the ______ of the computer and performs all the computational tasks.
Read More With Details
The microprocessor is often called the heart of the computer because it executes all the processing and control operations.
MS Word offers how many different views of a document?
Read More With Details
MS Word provides five different document views: Print Layout, Full Screen Reading, Web Layout, Outline, and Draft view.
Which type of memory holds the computer startup routine?
Read More With Details
ROM (Read-Only Memory) contains the computer’s startup instructions or BIOS, which executes when the computer is turned on.
Whose work laid the foundation for building computers and encryption in the 20th century?
Read More With Details
Al-Khwarizmi’s pioneering work in mathematics and algorithms laid the groundwork for modern computing and encryption techniques.
Which of the following holds data and processing instructions temporarily until the CPU needs it?
Read More With Details
Main memory (RAM) temporarily stores data and instructions needed by the CPU during processing operations.
A computer program that translates one program instruction at a time into machine language is called a/an:
Read More With Details
An interpreter translates high-level programming code into machine code line-by-line, allowing real-time execution and debugging.
If you press ______, the cell accepts your typing as its contents in MS Excel.
Read More With Details
Pressing Enter in Excel confirms the typed data and stores it in the active cell.
What is the main purpose of Format Painter in Microsoft applications?
Read More With Details
Format Painter is used to quickly copy formatting (like font style, size, and color) and apply it to other text or objects.
Which of the following is a valid font style in MS Word?
Read More With Details
MS Word includes font styles like Regular, Bold, Italic, and Bold Italic for text customization.
How can you delete selected text in MS Word?
Read More With Details
Pressing the Delete key removes the selected text from the document in MS Word.
If a formula refers to a cell that contains text instead of a number, what error does Excel display?
Read More With Details
Excel displays the #VALUE! error when a formula references a cell containing text instead of a numeric value.
Which type of computers are large in size and can handle multiple tasks simultaneously?
Read More With Details
Mainframe computers are large, powerful systems used by organizations for bulk data processing and multi-user operations.
A ______ is a unit of information in a ______.
Read More With Details
A field is the smallest unit of data in a record, representing a single piece of information such as a name or age.
Which among the following is the fastest memory component in a computer?
Read More With Details
Cache memory is the fastest memory in a computer, used to temporarily store frequently accessed data for quick retrieval by the CPU.
Which of the following components executes instructions in a computer?
Read More With Details
The CPU (Central Processing Unit) executes instructions from programs and performs basic arithmetic, logic, and control operations.
Which material is primarily used in optical fiber technology?
Read More With Details
Optical fibers are made of glass threads that transmit data as light signals over long distances with minimal loss.
Which component provides quick access to commonly used commands and tools?
Read More With Details
Toolbars offer quick access to frequently used commands like Save, Print, and Undo in Microsoft Office applications.
Which feature is used to add text inside a slide in MS PowerPoint?
Read More With Details
A Text Box in PowerPoint allows you to insert and customize text freely anywhere on a slide.
Which PowerPoint command allows you to change the color of multiple objects without altering content?
Read More With Details
The Color Scheme option in PowerPoint modifies color combinations of design elements without changing the slide content.
In Excel, a data series is defined as what?
Read More With Details
A data series in Excel refers to a set of related data points plotted on a chart to show trends or comparisons.
Which feature allows you to move from one page or website to another easily?
Read More With Details
Hyperlinks connect one document, webpage, or section to another, allowing seamless navigation.
What is the specific information added at the top of a page called?
Read More With Details
A Header is text or graphics displayed at the top of each page, commonly used for titles or dates.
What can be added in MS PowerPoint to make slides more dynamic and engaging?
Read More With Details
Animations in PowerPoint add motion effects to text, objects, or slides to enhance presentations.
In MS PowerPoint, which key is used to move to the next slide during a presentation?
Read More With Details
During a PowerPoint presentation, pressing the Enter key or the right arrow key advances to the next slide.
Which of the following is NOT a valid font style in MS Word?
Read More With Details
Bold, Italic, and Regular are valid font styles in MS Word. Underline is a text effect, not a font style.
If you write 8/9 in an Excel cell without using a formula, what does Excel display?
Read More With Details
In Excel, typing 8/9 is automatically formatted as a date (8th September) unless entered as a fraction using 0 8/9.
Which shortcut key moves the cursor one word to the right in MS Word?
Read More With Details
Pressing Ctrl + Right Arrow moves the cursor one word to the right in MS Word documents.
Cybersecurity is related to which field?
Read More With Details
Cybersecurity involves protecting computer systems, networks, and data from unauthorized access or attacks.
To write x² in MS Word, which key combination is used to make the 2 superscript?
Read More With Details
The Ctrl + Shift + + shortcut in MS Word applies superscript formatting, useful for writing powers like x² or y³.
What is the most suitable reason to use macros in MS Office?
Read More With Details
Macros in MS Office automate repetitive sequences of commands or actions, saving time and improving efficiency.
Websites often use information called ______ to track user activity and preferences.
Read More With Details
Trackers are small scripts or data files websites use to monitor user behavior and collect analytics information.
Page numbers can be set in which type of document?
Read More With Details
Page numbers can be inserted in word processing applications like MS Word or Notepad through the insert menu.
Which feature in PowerPoint displays the list of all objects on a slide?
Read More With Details
The Selection Pane lists all shapes, images, and text boxes on a slide, allowing easy organization and visibility control.
The feature that stores previously entered information for web pages is known as?
Read More With Details
AutoComplete allows browsers to suggest previously entered text, like usernames or addresses, for faster input.
What is the function of the keyboard shortcut Ctrl + Shift + < in MS Word?
Read More With Details
In MS Word, Ctrl + Shift + < decreases the current font size incrementally.
Which PowerPoint view displays only text, such as titles and bullet points?
Read More With Details
The Outline View in PowerPoint shows only text from slides, helping users focus on structure and content flow.
What is a predefined set of colors, fonts, and visual effects that you apply to your slides called?
Read More With Details
A Theme in PowerPoint ensures design consistency by applying a unified set of colors, fonts, and effects across all slides.
What is the first page of any website called?
Read More With Details
The Home Page is the main entry point of a website, providing navigation to all other sections.
Which items are typically placed at the end of a document?
Read More With Details
Endnotes appear at the end of a document and contain references or additional comments for citations.
To select multiple worksheets in Excel, which key is held while selecting sheets?
Read More With Details
Holding the Ctrl key allows users to select multiple, non-adjacent worksheets in Excel for grouped actions.
Which of the following is a valid cell address in MS Excel?
Read More With Details
In Excel, a valid cell address is written with a column letter followed by a row number, e.g., A5.
What is a predefined set of colors, fonts, and visual effects applied to slides in PowerPoint called?
Read More With Details
A PowerPoint theme is a predefined combination of colors, fonts, and effects that gives slides a consistent professional look.
Which class of computer cannot support multiple users simultaneously?
Read More With Details
Microcomputers are designed for single-user operation and cannot handle multiple users at once like mainframes or minicomputers.
The F12 key in MS Word is used for which purpose?
Read More With Details
The F12 key in MS Word opens the “Save As” dialog box, allowing you to save the document with a new name or location.
A compiler is best described as:
Read More With Details
A compiler is a system software that translates high-level programming code into machine-level instructions.
Which Excel tool allows setting specific conditions for data entry to ensure accuracy?
Read More With Details
Data Validation in Excel helps ensure accurate data entry by setting rules such as range limits or specific formats.
The space between the margin and the start of a paragraph is called:
Read More With Details
Indentation is the space added between the page margin and the beginning of a paragraph in Word documents.
In MS Excel, ready-made templates are available under which tab?
Read More With Details
Excel provides a variety of ready-made templates under the “File” tab for budgeting, tracking, and reports.
MS Excel is generally used for what purpose?
Read More With Details
Excel is a spreadsheet software used to organize, analyze, and visualize numerical and textual data.
A _____ is a dynamic mathematical calculation that displays a single value for a specific field.
Read More With Details
Aggregate functions like SUM, AVG, and COUNT perform dynamic calculations to produce a single summarized value from a set of records.
Presentation pages in PowerPoint are called:
Read More With Details
In PowerPoint, each presentation page is called a Slide, which can contain text, images, charts, and other multimedia elements.
The ability to read or write each piece of information in a storage device in approximately the same length of time regardless of its location is called:
Read More With Details
Random Access allows data to be read or written directly from any location on the storage medium without sequentially scanning other data.
Procedural language was used in which generation of computers?
Read More With Details
Procedural programming languages like COBOL and FORTRAN were used in third-generation computers based on integrated circuits.
Which of the following software is used to prepare a presentation?
Read More With Details
Microsoft PowerPoint is a presentation software used to create slideshows containing text, graphics, and animations for effective communication.
Which component provides a path to transfer data between CPU and memory?
Read More With Details
The Data Bus is responsible for carrying data between the CPU, memory, and other hardware components in a computer system.
Which shortcut key is used to undo the last action in a document?
Read More With Details
Ctrl + Z is a universal keyboard shortcut used to undo the last performed action in most software applications.
