0% found this document useful (0 votes)
20 views2 pages

MCQs on Operating Systems & Excel

Uploaded by

Arpit Mishra
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
20 views2 pages

MCQs on Operating Systems & Excel

Uploaded by

Arpit Mishra
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

1 (viii) com.

Multiple Choice Questions (MCQs)


CLASS: VIII
SUBJECT: COMPUTER
Chapter – 1 [OPERATING SYSTEM]

Question 1) It manages computer hardware and software


(a) Program (b) Instruction (c) Operating system
Question 2) Who is called supervisor of computer activity
(a) Memory (b) Operating system (c) Control unit
Question 3) Operating system manages :
(a) Memory (b) Processor (c) All of these
Question 4) Unix operating system is an :
(a) Multi user (b) Single user (c) Real Time
Question 5) MS DOS is an :
(a) CUI (b) GUI (c) None of these
Question 6) Operating system used to run batch operations :
(a) Real Time (b) Batch (c) Single user
Question 7) Operating system used in robots.
(a) Batch (b) Multitasking (c) Real Time
Question 8) It takes care of creation & deletion of processes.
(a) Process Management (b) Memory Management (c) File Management
Question 9) It involves keeping track of all files
(a) Process Management (b) Memory Management (c) File Management
Question 10) It takes care of allocation and reallocation of memory space.
(a) Process Management (b) File Management (c) Memory Management
Question 11) A type of user interface that allows users to interact with electronic devices through icons.
(a) CUI (b) GUI (c) None of these
Question 12) The background picture on the desktop is called.
(a) Screen Saver (b) Wallpaper (c) Desktop Screen
Question 13) In which type of operating system, response time is very crucial :
(a) Real Time (b) Network (c) Batch
Question 14) _________ shares characteristics with both hardware and software.
(a) Operating system (b) Software (c) Hardware
Question 15) Which is the first program run on a computer when it boots up?
(a) System software (b) Operating system (c) None
Question 16) Which is not the function of an operating system?
(a) Memory Management (b) Virus protection (c) File Management
Question 17) What should be the extension to executable files?
(a) . exe (b) . doc (c) . pay
Question 18) Which of these is not the advantage of GUI ?
(a) You have to learn commands (b) It is easy to use (c) It has icons to work
Question 19) Latest version of windows operating system –
(a) Windows 8 (b) Windows 8.1 (c) Windows 10
Question 20) Windows was introduced by :
(a) Mac (b) Microsoft (c) Apple
Question 21) This area store the deleted files :
(a) Network (b) Recycle Bin (c) This PC
Question 22) Full form of DOS is :
(a) Disk operating system (b) Disk operated system (c) None
Question 23) Single user OS supports :
(a) Many users (b) One user (c) No user
Question 24) Antivirus application is an :
(a) System software (b) Device Driver (c) Application software
Question 25) It offers graphical icons and visual indicators.
(a) BUI (b) CUI (c) GUI
Chapter – 2 [FUNCTION AND CHART]
Question 1) It always begin with an equal to sign
(a) Formulas (b) Functions (c) Both
Question 2) It is a group of connected cells.
(a) Formula (b) Range (c) Function
Question 3) Another form of formulas is :
(a) Equation (b) Functions (c) None
Question 4) Number of Rows in a worksheet :
(a) 10, 48, 676 (b) 10, 48, 756 (c) 10, 48, 576
Question 5) Number of columns in a worksheet
(a) 16, 576 (b) 16, 384 (c) 16, 584
Question 6) By default, a workbook contains ___________ worksheets
(a) 2 (b) 3 (c) 1
Question 7) Formed by the intersection of a row and column
(a) Cell (b) Range (c) worksheet
Question 8) Valid formula is :
(a) = A + B2 (b) A2 + B2 (c) = A2 + B2
2 (viii) com.
Question 9) Function used to find maximum value in a range
(a) MAX ( ) (b) MIN ( ) (c) AVERAGE ( )
Question 10) The workbook is saved in MS- Excel with an extension.
(a) . xlsx (b) . xlxs (c) Both
Question 11) Shortcut for moving data from one worksheet to another.
(a) Ctrl + C (b) Ctrl + X (c) Alt + F4
Question 12) Shortcut for saving excel worksheet.
(a) Ctrl + C (b) Ctrl + S (c) Ctrl + V
Question 13) Function used to find the square root of a value.
(a) Sprt (b) srt (c) Sqrt
Question 14) A valid function to insert date in worksheet.
(a) =Today (A1) (b) Today ( ) (c) None
Question 15) To Rename a worksheet, select ________ in worksheet menu
(a) Name (b) Rename (c) None
Question 16) The first version of MS Excel
(a) Excel 2 (b) Excel 7 (c) Excel 10
Question 17) Chart representing data in horizontal legends.
(a) Bar chart (b) Column chart (c) Line chart
Question 18) Category axis is ________ axis.
(a) X (b) Y (c) Z
Question 19) Value axis is ________ axis
(a) X (b) Y (c) Z
Question 20) A key that identifies patterns, colors or Symbols
(a) Gridlines (b) X axis (c) Legend
Question 21) To have a look of your chart before printing.
(a) Print Preview (b) Print (c) None
Question 22) Press ________ together to close a Workbook.
(a) Ctrl + F4 (b) Ctrl + F2 (c) Ctrl + F3
Question 23) Press ________ to show print preview of a chart graph.
(a) Ctrl + F2 (b) Ctrl + F3 (c) Ctrl + F4
Question 24) To print a chart on a worksheet, press ________
(a) Ctrl + S (b) Ctrl + P (c) Ctrl + X

Common questions

Powered by AI

Antivirus applications are distinguished by their specific function to detect, prevent, and remove malicious software (malware). Unlike general system software that manages hardware or application software providing specific user tasks, antiviruses focus on the security and protection of data and system integrity from external threats .

Process management involves the creation, scheduling, and termination of processes. It ensures efficient CPU usage, prevents process conflicts, and facilitates multitasking, which collectively optimize the system performance by managing the execution of multiple tasks without interference .

Real-time operating systems are designed to process inputs and outputs within specified time constraints, making them suitable for time-sensitive applications, unlike batch operating systems which execute jobs consecutively without direct user interaction, often without strict timing constraints .

The operating system is the first program run because it initializes the hardware components and loads necessary software components required for starting the system's operation and managing further tasks .

Real-time operating systems are crucial in scenarios where time constraints are critical, such as in robotics, industrial control systems, and embedded systems. They are designed to respond predictably to input within a specified time, ensuring consistent performance and system reliability .

File management is integral as it keeps track of all information and data files on a computer. It organizes, stores, retrieves, and manages data, ensuring data integrity and security, which are crucial for efficient data handling and user accessibility .

Multi-user operating systems allow multiple users to access a computer system concurrently, whereas single-user operating systems support only one user at a time . This distinction is crucial for environments where resource sharing and simultaneous user interaction are required, such as in server or networked settings.

CUIs require users to interact with the operating system through textual commands, requiring familiarity with command syntax. In contrast, GUIs provide visual elements like icons and windows, making the system more user-friendly and accessible, as they do not require extensive command knowledge .

An operating system is considered a combination of hardware and software because it manages hardware resources like memory and processors, while also providing a software platform for application programs. It integrates these components to work seamlessly together .

The primary role of an operating system is managing computer hardware and software resources. It acts as a bridge between user applications and the hardware, handling tasks such as memory management, process scheduling, and file system organization .

You might also like