Computer MCQs

Which component of an Operating System is responsible for managing the CPU time and allocating it among various processes?

Which keyboard shortcut is primarily used in MS Word to quickly remove paragraph formatting and restore the text to its default state?

In MS Excel, if you want to calculate the average of a range of cells (A1 to A10) but exclude any cells that contain the text 'N/A', which function should you use?

In Windows OS, what is the primary function of the Task Manager (Ctrl+Shift+Esc)?

When designing a presentation in MS PowerPoint, what feature should be utilized to ensure that a specific slide sequence is presented automatically, without the presenter needing to click through each slide?

Which Linux command is used to view the usage statistics and resource consumption of currently running processes?

In Microsoft Excel, which function is most appropriate for counting the number of cells within a specified range that contain values meeting a given criterion?

In an Operating System context, what is the primary purpose of a 'Process Scheduler'?

When comparing Windows and Linux operating systems, which feature best describes the foundational difference in managing system resources and allowing for decentralized customization?

In Microsoft Excel, which function is best suited for counting the number of cells within a given range that meet a specific criterion (e.g., counting all salaries greater than 50000)?

In MS Excel, if a dataset contains many cells that appear to be blank but actually contain hidden spaces or non-printing characters, which function or tool is most effective for cleaning the data and removing these spurious entries?

Which function in Microsoft Excel is used to count the number of cells in a range that meet a specified criterion or criteria?

In a Linux environment, which command is used to monitor the current usage of CPU, memory, and other system resources in real-time and is generally considered a comprehensive system monitor?

When designing a professional presentation in PowerPoint, which feature should be used to ensure consistent formatting (like font style, size, and colors) across multiple slides?

When preparing a professional report in MS Word, which feature should be used to ensure consistent formatting and sequential numbering for chapter titles and subheadings?

In Microsoft Excel, which function is most appropriate for counting the number of cells within a specified range that meet a given criterion, such as counting all 'Pass' entries?

Which feature in Microsoft Word allows a user to automatically generate customized documents, such as formal letters or certificates, by combining data from a source like an Excel spreadsheet?

When designing a presentation in Microsoft PowerPoint, which feature allows you to pre-set the timings and transitions for specific slides to create a synchronized viewing experience?

When preparing a professional document in MS Word, what is the best practice to ensure consistent formatting and structure across multiple sections?

In Microsoft Excel, which function is used to count the number of cells within a range that meet a specified criterion?

When designing a professional presentation using PowerPoint, what is the primary function of the 'Slide Master' view?

In Linux, which command is primarily used to view network configuration details, such as IP addresses, subnet masks, and broadcast addresses, on a machine?

In the context of operating systems, what is the primary function of a 'kernel'?

In the context of file systems on Linux, what command is used to check the filesystem integrity and repair common structural issues?

Which command is used in Linux to display the total amount of used and available memory in a human-readable format?

In the context of Windows operating systems, what is the primary function of the Task Manager?

Which concept allows a modern operating system, like Windows or Linux, to execute multiple processes concurrently, making it appear as if they are running simultaneously?

A user needs to calculate the total sum of sales only for the 'Punjab' region, but only if the sales amount is above PKR 50,000. Which Excel function should be used?

In Microsoft Word, which method is best suited for creating a large volume of personalized documents, such as certificates or letters with varying recipient details?

Which process in an operating system manages the physical memory allocation and ensures that different running programs do not interfere with each other's memory space?

Which keystroke combination is the standard shortcut used to undo the last action performed in most Microsoft Office applications?

Which feature in MS PowerPoint allows users to display a customized set of slides, skipping or reorganizing the standard presentation flow, making it ideal for board reports or selective review?

In Linux, if a user needs to grant read (r) and write (w) permissions to the owner (user) and the group (group), while restricting permissions for others (world), which symbolic chmod command should they use?

In Microsoft Excel, which function is used to count the number of cells in a range that meet specific criteria?

In Linux operating system, which command is typically used to change the permissions of a file or directory (read, write, execute) for different user classes?

When creating a professional presentation in PowerPoint, which feature allows a user to display specific information or visuals exactly when needed, controlling the flow of information?

In PowerPoint, if you want to ensure that specific elements (like slide numbers or corporate logos) appear consistently on every slide without manually adding them, you should utilize:

Which feature in Microsoft Excel allows users to automatically calculate and update multiple related calculations across different sheets or parts of the workbook?

To ensure consistent formatting and style across a long document in MS Word, what feature is most efficiently used?

In PowerPoint, if you want to apply a visual effect (like Fade or Zoom) that occurs when moving from one slide to the next, which feature should you utilize?

When linking data from an Excel sheet to a PowerPoint slide, what method ensures that the embedded graph updates automatically if the source data in Excel is modified?

In Windows OS, what is the primary function of the Control Panel, as opposed to the Settings app?

In Microsoft Excel, which function is correctly used to count the number of cells within a specified range that contain only numerical values?