[Forest Guard, 2022]

1. Computer keyboard shortcut which is used to change case is





Answer & Solution

Answer:

Shift+F3

Solution:

The Shift+F3 keyboard shortcut is commonly used to toggle the case of text in Microsoft Word and some other text editors. Pressing Shift+F3 once will change the selected text to all uppercase, pressing it again will change the selected text to all lowercase, and pressing it a third time will capitalize the first letter of each word in the selected text.

[Forest Guard, 2022]

2. Which of the following is the correct order of the four major functions of a computer?





Answer & Solution

Answer:

Input, Process, Output, Storage

Solution:

Input refers to the process of entering data into the computer, either through a keyboard, mouse, scanner, or other input devices.

Process refers to the manipulation of data by the computer's central processing unit (CPU), which includes arithmetic operations, logical operations, and data transfers.

Output refers to the presentation of data processed by the computer, either through a monitor, printer, or other output devices.

Storage refers to the long-term retention of data by the computer on hard drives, solid-state drives, or other storage media.

[Forest Guard, 2022]

3. Which of the following is capable of recognizing a pre-specified type of mark by pencil or pen ?





Answer & Solution

Answer:

OMR

Solution:

OMR is a technology that is capable of recognizing a pre-specified type of mark made by pencil or pen. It is commonly used in various applications such as surveys, exams, and voting systems. OMR scanners work by shining a light on the paper that contains the marks, and then reading the reflection of the light to detect the presence or absence of the marks.

[Forest Guard, 2022]

4. In a computer spreadsheet, cell range A3 through G3 should be keyed in as ________





Answer & Solution

Answer:

A3:G3

Solution:

In a computer spreadsheet, cell range A3 through G3 should be keyed in as A3:G3. The colon (:) is used to indicate a range of cells between two cells. So, A3:G3 refers to all cells from A3 through to G3, inclusive.

Option (a) A3-G3 is not a valid syntax for representing a cell range in a spreadsheet.

Option (c) A3?.G3 is also an invalid syntax as it contains a question mark character.

Option (d) A3 to G3 is not a valid syntax for representing a cell range in a spreadsheet.

 

[Forest Guard, 2022]

5. VLOOKUP function _______





Answer & Solution

Answer:

Finds related records

Solution:

VLOOKUP is a function in spreadsheet programs, such as Microsoft Excel and Google Sheets, that is used to search for a specific value in the first column of a range of cells, and then return a related value in the same row from a specified column. It is commonly used to look up information in a table, such as employee names and salaries, or product names and prices.

Option (b) is incorrect because VLOOKUP does not search for text that contains "v".

Option (c) is incorrect because checking if two cells are identical is done using a different function, such as the Excel function "EXACT".

Therefore, the correct answer is (a) Finds related records.