Computer Knowledge - 5 - SSC CGL MCQ

• The correct answer is Dot Matrix.

Key Points

• Dot matrix:-
  • An impact printer with a fixed number of pins or wires is known as a dot matrix printer.
  • Typically, one or more vertical columns of pins or wires are used to organize the components.

Important Points

• ​Laser:
  • Without continuous contact between the printing head and the paper, non-impact printers produce images, characters, and figures.
  • Examples of non-impact printers include laser printers, inkjet printers, and thermal printers.
• Deskjet printing:
  • It is a type of printing where the ink is deposited on paper through a desktop printer.
  • The most common type of deskjet printer uses thermal inkjet technology, which heats small drops of ink and sprays them onto the paper.

The correct answer is Ctrl + Y.

Key Points

• Ctrl + Y is used to redo the last action in MS- word.​

Additional Information

The correct option is (1)

30

Given:

=AVERAGE(10, 20, 30, 40, 50)

Calculation:

Average = sum of total number/ total number

Average = (10 + 20 + 30 + 40 + 50) / 5

⇒ Average = 150/5 = 30

⇒ Average = 30

Hence the average of the given Excel formula = 30

Key Points

• The sum of all values divided by the total number of values is the formula used to determine the average of the given numbers. Sum of Values / Number of Values = Average
• returns the parameters' arithmetic means, or average. For instance, the formula =AVERAGE(A1:A20) provides the average of the values in the range A1:A20.

Additional Information

To rapidly find the average, use AutoSum.

1. To find the average of the numbers in a column or row, click a cell below the column or to the right of the row.
2. Click the arrow next to AutoSum > Average on the HOME tab, then press Enter.

The correct answer is Disk Operating System (DOS) was used in Microsoft's x86-based PCs.

Key Points

• Microsoft Disk Operating System or abbreviated as MS-DOS is a non-graphical command line operating system developed for IBM-compatible systems.
• It was derived from x86 processors. Hence statement 3 is correct.
• It was written in C language and x86 assembly language. It was superseded by the systems that offer a Graphical User Interface, so DOS doesn't support GUI. Users must use different commands in the command line interface to get the action done.
• It is a single-user system and it does not support multitasking. It does not have built-in security, file restrictions etc.

Additional Information

• MS-DOS provides two types of commands to get the tasks done: Internal command and External command.
• Internal commands are built-in commands of the operating system, stored in the command interpreter file COMMAND.COM, in the C drive.
• Dir command is an internal command which is used to list all files of specific directories or subdirectories.
• Deltree command is an external command which deletes a directory and its subdirectories it has.

The correct answer is Option 4.

Key Points

• A barcode reader is not an output device.
• It is actually an input device, which is used to read and interpret data from barcode labels and transmit that data to a computer or other device.
• Barcode readers use optical scanning technology to read the pattern of bars and spaces on a barcode label, which represents a specific code or series of numbers and characters.
• This information is then sent to a computer or other device for processing and interpretation.
• Output devices, on the other hand, are devices that are used to display or transmit information or data from a computer or other device.
• Examples of output devices include computer monitors, printers, speakers, and projectors.

Additional Information

• A plotter is a type of output device that is used to print large-scale graphics, designs, and technical drawings.
  • Unlike traditional printers, which use ink or toner to create images on paper, plotters use a pen or other marking instrument to draw precise lines and shapes on paper, vinyl, or other materials.
• ​A monitor is an output device that displays visual information from a computer or other electronic device. Also referred to as a computer screen or display screen, a monitor is one of the most important components of a computer system.

• A dot matrix printer is a type of impact printer that uses a matrix of small pins to strike an inked ribbon and create an image or text on paper.

  • The pins are arranged in a grid, and when the printer head moves across the page, the pins strike the ribbon and transfer ink onto the paper, creating a series of dots that form characters and images.

The correct answer is option 2

Key Points

• Ctrl + Y is used to perform a "redo" operation in MS-Word.
• Ctrl + Z is used to perform an "undo" operation in MS-Word.
• Undo means to cancel or reverse the effects or results of (a previous action or measure).
• Redo means to do (something) again or differently.
• Center the text - Ctrl+E.

Additional Information

Important Shortcut keys used in MS Word:

• Cut the selected content to the Clipboard - Ctrl+X
• Copy the selected content to the Clipboard - Ctrl+C
• Paste the contents of the Clipboard -Ctrl+V
• Increase the font size by 1 point.- Ctrl+]
• Align the text to the left - Ctrl+L.

The correct answer is interprets computer output into user understandable form.

Key Points

• A device driver for an output device, such as a printer or display, typically takes data from the computer and translates it into a format that the device can understand and process.
  • This may involve converting the data into a specific language or format that the device recognizes, such as converting a document into a series of printer commands or a video signal into a format that a display can use.
  • While the device driver plays a vital role in enabling the output device to process data and produce output, it is not solely responsible for interpreting the output in a way that is understandable to the user.

The correct answer is Home

Key Points

In Microsoft PowerPoint 2016, the Home tab in the ribbon contains a wide variety of tools and features, including commands related to paragraphs, drawing, and editing. This includes:

• Paragraph: The Home tab contains controls for paragraph alignment, bullets and numbering, indentation, and line spacing for text boxes in slides.
• Drawing: The 'Drawing' group in the Home tab allows you to add shapes, lines, and other drawing elements to your slides. It has tools for selecting, aligning, and distributing shapes, setting the order of elements, and more.
• Editing: The Home tab also contains the Clipboard group (for copy, paste, cut, and format painter features) and the Editing group (with find, replace and select functions).

These tools and features are helpful while creating and editing presentation content, making the Home tab a central location in PowerPoint for managing this content.

Brain is first widespread computer virus for MS-DOS. Brain is a boot sector virus, infecting the first sector of floppies as they are inserted into an infected computer.
Hence, Option C is correct.

WorkSheets is not a type of Microsoft access database object.
Hence, Option B is correct.

RAM (Random Access Memory) is not a part of CPU, while the other three are.
Its function is to store programs and data so that they are ready for use when the CPU needs them.
Hence, option A is the correct answer.

Row in an Access table is also known as record.
Hence, Option D is correct.

The Control Unit (CU) coordinates with the input and output devices of a computer.
It directs the computer to carry out stored program instructions by communicating with the ALU and the registers. It organizes the processing of data and instructions.
Hence, option B is the correct answer.

Computer mapping uses the speed and versatility of computer graphics to display spatial data. The type of data determines how it will be stored and displayed.
The basic principles of cartography apply to computer mapping, with some modifications.
Hence, option C is the correct answer.

System software is a type of computer program that is designed to run a computer's hardware and application programs.
Hence, option D is the correct answer.

In the context of computers, MROM stands for Mask Read Only Memory. It is a memory chip that is made with its data.
These are economical and the first type of ROM, which were hard-wired mechanisms that include pre-programmed directions.
Hence, option B is the correct answer.

The correct answer is Scanner.

Key Points

• Scanner is an input device that works more like a photocopy machine.
  • Scanner is used when the information is on paper (hard copy) and needs to be stored in computer (soft copy) for further functions.
  • These images can be edited before they are printed.e stored on the disc.

Additional Information

• Track ball is an input device which is used instead of mouse in notebooks or laptop computers.
• Light pen is used to select a displayed menu item or draw pictures on the monitor screen.
• Digitizer is an input device which converts analog information into digital form.

The correct answer is Delete.

Key Points

• Both the Delete and Backspace keys are used to delete one character at a time in the text.
• To delete one character to the right side, click Delete. Hence option 1 is correct.
  • To delete one character to the left side, click Backspace.

Additional Information

• To delete the word, press and hold the Delete key.
• Use Ctrl + Delete shortcut to delete one word at a time to the right side.
• To delete the whole word at a time to the left side, use Ctrl + Backspace shortcut key.

The correct answer is ok

Key Points

• The RIGHT() and LEFT() functions in Excel are used to extract a specific number of characters from a text string starting from the right or the left.
• RIGHT(): The RIGHT() function extracts a given number of characters from the right of a supplied text string. For example, =RIGHT("TestBook",2) will return "ok", which are the last 2 characters from the right of the string "TestBook".
• Here's how the RIGHT() function structure looks like: =RIGHT(text, [num_chars]). Both the arguments are as follows:
  • text: The text string that you want to extract from. It must be enclosed in quotation marks.
  • num_chars: Optional. Specifies the number of characters you want to extract. If omitted, it will take 1 by default.
• LEFT(): The LEFT() function extracts a given number of characters from the left of a supplied text string. For example, =LEFT("TestBook",2) will return "Te", which are the first 2 characters from the left of the string "TestBook".
• Here's how the LEFT() function structure looks like: =LEFT(text, [num_chars]). Both the arguments are as follows:
  • text: The text string that you want to extract from. It must be enclosed in quotation marks.
  • num_chars: Optional. Specifies the number of characters you want to extract. If omitted, it will take 1 by default.

Additional Information

• SUM(): This function adds all the numbers in a range of cells.
• AVERAGE(): This function returns the average of the numbers in a range of cells.
• COUNT(): This function counts the number of cells that contain numerical data in a range.
• VLOOKUP(): This function looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. However, starting in Excel 2021, it's recommended to use XLOOKUP() instead, as it has more flexibility and it corrects certain drawbacks from VLOOKUP.
• IF(): This function performs a logical test and returns one value for a TRUE result, and another for a FALSE result.
• CONCATENATE() or CONCAT(): This function combines two or more text strings into one string.

The correct answer is ultraviolet light.

Key Points

• The data stored in EPROM chips can be erased and the chip can be reprogrammed. This is achieved by exposing the chip to an intense Ultraviolet (UV) light through a specially designed window in the chip.
• The process of erasing the data with UV light makes EPROM a reusable and flexible choice in hardware that needs occasional data updates.
• An EPROM (Erasable Programmable Read-Only Memory) is a non-volatile memory, meaning it can retain its data even when the power supply is switched off.
• EPROMs are used to store data, like system software, that need not be changed frequently.
• They have been extensively utilized in computers and other devices where permanent storage is essential.
• In many security systems, EPROMs are used to hold both the operating system and the program for the access control panel.