BSF Head Constable Exam  >  BSF Head Constable Tests  >  BSF Head Constable Ministerial (HCM) Mock Test Series 2025  >  BSF Head Constable Ministerial (HCM) Mock Test - 4 - BSF Head Constable MCQ

BSF Head Constable Ministerial (HCM) Mock Test - 4 - BSF Head Constable MCQ


Test Description

30 Questions MCQ Test BSF Head Constable Ministerial (HCM) Mock Test Series 2025 - BSF Head Constable Ministerial (HCM) Mock Test - 4

BSF Head Constable Ministerial (HCM) Mock Test - 4 for BSF Head Constable 2025 is part of BSF Head Constable Ministerial (HCM) Mock Test Series 2025 preparation. The BSF Head Constable Ministerial (HCM) Mock Test - 4 questions and answers have been prepared according to the BSF Head Constable exam syllabus.The BSF Head Constable Ministerial (HCM) Mock Test - 4 MCQs are made for BSF Head Constable 2025 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests for BSF Head Constable Ministerial (HCM) Mock Test - 4 below.
Solutions of BSF Head Constable Ministerial (HCM) Mock Test - 4 questions in English are available as part of our BSF Head Constable Ministerial (HCM) Mock Test Series 2025 for BSF Head Constable & BSF Head Constable Ministerial (HCM) Mock Test - 4 solutions in Hindi for BSF Head Constable Ministerial (HCM) Mock Test Series 2025 course. Download more important topics, notes, lectures and mock test series for BSF Head Constable Exam by signing up for free. Attempt BSF Head Constable Ministerial (HCM) Mock Test - 4 | 100 questions in 100 minutes | Mock test for BSF Head Constable preparation | Free important questions MCQ to study BSF Head Constable Ministerial (HCM) Mock Test Series 2025 for BSF Head Constable Exam | Download free PDF with solutions
BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 1

Direction: Select the word from the options which is exactly opposite in meaning to the bracketed word given in the sentence below.
She relished our (arguments), most of which she won.

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 1

The correct answer is "agreements."
Key Points

  • "Arguments" means angry discussions between two or more people who disagree with each other. (विवाद, झगड़ा, बहस)
    • Example: Leela had arguments with her father about politics.
  • "Agreements" means harmony or accordance in opinion or feeling. (राय या भावना में सामंजस्य या अनुरूपता)
    • Example: The dispute was settled by agreements that satisfied both sides.
  • So, the word which is exactly opposite in meaning to the bracketed word is "agreements."
  • Therefore, Option D is the correct answer.

Additional Information

  • Option A: Altercation means a noisy argument or disagreement. (विवाद, झगड़ा, कहा-सुनी, अनबन)
  • Option B: Negotiations involve discussion and compromise to reach an agreement, but they still involve some level of disagreement. (वार्ता (किसी निर्णय या समझौते पर पहुँचने के लिए लोगों में बातचीत)
  • Option C: Feud means a prolonged and bitter quarrel between two parties. (दो व्‍यक्तियों या व्‍यक्ति-समूहों के बीच लंबे समय तक चलने वाला झगड़ा; पुश्‍तैनी रंजिश)
BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 2

Read each sentence to find out whether there is any error in it. The error, if any, will be in one part of the sentence. The alphabet of that part is the answer :

The bright (a) / lamps (b) / gave much (c) / lights (d).

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 2

The correct answer is '(d)'.
Key Points

  • The error lies in Part (d) of the sentence.
  • 'Light' is the term for the brightness that is produced by a lamp, the sun, etc. which allows things to be seen.
  • In most contexts, 'light' is uncountable and does not take a plural form.
  • Lamps would not 'give lights'. They would 'give light'.
  • Therefore, 'lights' in Part (d) should be replaced with 'light'.

Correct sentence: The bright lamps gave much light.
Additional Information

  • While 'lights' does exist as a word in English, it does not have the same meaning as 'light'.
  • 'Lights' can refer to pieces of equipment for producing light, such as lamps or ceiling lights.
  • For example "The lights in the room were very bright".
  • It does not generally refer to the brightness produced by these things, which is the context in this sentence.
BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 3

 Select the most appropriate word from the options against ___Z___

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 3

The correct answer is "consumes"
Key Points
Look at the selected option within the context of the sentence:

  • The blank should be filled with a verb because it follows the noun ""average person" on Earth"
  • The sentence is in present tense so the verb must be in present tense.
  • The blank follows a singular noun, that's why we will use "consumes".

Hence, the correct passage: Each human being has a legitimate claim to a sufficient and fair amount of Earth’s resources. But with a population approaching 8 billion, even if everyone adopted a relatively low material standard of living like the one currently found in Papua New Guinea, it would still push Earth to its ecological breaking point. Unfortunately, the "average person" on Earth consumes at a rate over 50% above a sustainable level.

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 4

Which of the words in the passage is the opposite of "indifferent?"

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 4

The correct answer is 'concerned.'
Key Points

  • The meaning of the word "Indifferent" is not interested in or caring about somebody/something. (व्‍यक्ति या वस्‍तु में रुचि या सोच-विचार से रहित; उदासीन)
  • Let us see the meanings of the given options:
    • Precisely: exactly. (सही-सही)
    • Concerned: interested, worried and feeling concern about something. (किसी के लिए चिंतित और परेशान)
    • Discussed: to talk or write about something seriously or formally. ((लेख या भाषण के रूप में) गंभीर विचार-विमर्श करना)
    • Solely: not involving anyone or anything else; only. (केवल, एकमात्र)
  • F rom the meanings of the given words, we can say that the word which is opposite of "indifferent" is "concerned."

Hence, the correct answer is Option B.

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 5

Find out the antonym of the underlined word in the given sentence.

No one likes to cultivate in a barren land.

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 5

The correct answer is 'fertile'.
Key Points

  • barren: not able to produce offspring or crops, or unproductive or unfruitful. (संतान या फसल पैदा करने में सक्षम नहीं, या अनुत्पादक या अनुपयोगी।)
    • Synonyms:- Sterile,Unproductive, Unfruitful, Desolate, Wasteland, Arid
    • Example:- The once-fertile land had become barren after years of drought and over-farming.
  • "fertile" refers (used about land or soil) that plants grow well in (ज़मीन या मिट्टी) उपजाऊ
    • ​Synonyms:- productive
    • Example:- Fertile land is able to produce good crops or plants.

Hence, the correct answer will be Option D.
Additional Information

  • desperate: out of control and ready to do anything to change the situation you are in because it is so terrible. अत्‍यधिक निराशा के कारण दुस्‍साहसी, निराशोन्‍मत
  • parched: very hot and dry, or very thirsty बहुत गरम और सूखा, या बहुत प्‍यासा
  • desolate: (used about a place) empty in a way that seems very sad (स्‍थान) निर्जन और अवसादपूर्ण
BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 6

In the following question, select the related words from the given options.

Car : Road :: Submarine : ?

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 6

Car is driven on the road
Similarly,
Submarine is a watercraft capable of independent operation under water
Hence, option B is correct answer.

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 7

Select the figure from the options that can replace the question mark (?) in the following figure series.

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 7

The images in the figure are shifting its position by rotating in:

  • For '@' - It is shifting in the anti-clockwise direction.

  • For '$' - It is shifting in the anti-clockwise direction.

  • For '#' - It is shifting in the anti-clockwise direction.

  • For '?' - It is shifting in the anti-clockwise direction.

  • For 'LINE' () - It is not shifting and are in the decreasing order.

Hence, "Option - (C)" is the correct answer.

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 8

In a certain code language,
A + B means 'A is the mother of B'.
A - B means 'A is the brother of B'.
A × B means 'A is the wife of B'.
A ÷ B means 'A is the father of B'.
Based on the above, how is P related to S if 'P × Q ÷ R - T × S'?

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 8

Consider the following Symbols:

P is the wife of Q,Q is the father of R,R is the brother of T,T is the wife of S.
The family tree for the above condition is given as follows:

Hence, the correct answer is "Mother in law".

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 9

What will be the angle between the hour-hand and the minute-hand at 8.00 PM?

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 9

Θ = | Hours x 30° - 11/2 x Minute |
H = 8 and M = 0
Θ = |11/2 x 0 - 30 x 8 |
Θ = | 0 - 240 |
Θ = 240°
Hence, '240°' is the correct answer.

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 10

The cost price of an article is ₹600. A shopkeeper sells it for ₹680 after giving a discount of 15% on its list price. If he sells it after giving a discount of 10% on its list price, find the profit percentage.

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 10

Formula Used:
List Price (LP) calculation with discount:
Selling Price (SP) with 15% discount:  SP15 = LP x (1 - (15/100))
Selling Price (SP) with 10% discount:  SP10 = LP x (1 - (10/100)) 
Profit Percentage:  Profit % = SP - CP/CP x 100 
Calculation:
Given SP with 15% discount is ₹680:
680 = LP x (1 - (15/100))
680 = LP x 0.85 
LP = 680/0.85 
LP = 800
Now, SP with 10% discount:
SP10 = 800 x (1 - (10/100)) 
SP10 = 800 x 0.90
SP10 = 720
Profit Percentage:
Profit % = 720 - 600/600 x 100
Profit % = 120/600 x 100
Profit % = 0.20 x 100
Profit % = 20 %
∴ The correct answer is 20% (B).

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 11

The average weight of 35 students in a class is 66 kg. Six students with average weight of 58.5 kg leave the class, and 11 students with average weight of 68 kg join the class. Now what is the average weight (in kg) of the students in the class?

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 11

Given:

The average weight of 35 students in a class is 66 kg.

Formula Used:

New total weight = (Total weight of initial 35 students - Total weight of 6 students leaving) + Total weight of 11 students joining

Calculation:

Total weight of initial 35 students = 35 × 66

Total weight of 6 students leaving = 6 × 58.5

Total weight of 11 students joining = 11 × 68

New number of students = 35 - 6 + 11

New average weight = New total weight / New number of students

Total weight of initial 35 students = 35 × 66

⇒ 35 × 66 = 2310

Total weight of 6 students leaving = 6 × 58.5

⇒ 6 × 58.5 = 351

Total weight of 11 students joining = 11 × 68

⇒ 11 × 68 = 748

New total weight = (2310 - 351) + 748

⇒ 1959 + 748 = 2707

New number of students = 35 - 6 + 11

⇒ 40

New average weight = 2707 / 40

⇒ 67.675

∴ The correct answer is 67.675 (A).

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 12
A bike consumes 20 mL of petrol per kilometre, if it is driven at a speed in the range of 25 – 50 km/hour and consumes 40 mL of petrol per kilometre at any other speed. How much petrol is consumed by the bike in travelling a distance of 50 km, if the bike is driven at a speed of 40 km/hour for the first 10 km, at a speed of 60 km/hour for the next 30 km and at a speed of 30 km/hour for the last 10 km?
Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 12

Given:

Speed range 25 - 50 km/hr, fuel consume 20 mL per km

Speed range other than 25 - 50 km/hr, fuel consume 40 mL per km

Distance travelled at a speed of 40 km/hr = 10 km

Distance travelled at a speed of 60 km/hr = 30 km

Distance travelled at a speed of 30 km/hr = 10 km

Total distance travelled = 50 km

Concept used:

Speed = distance/time

Fuel consumed = fuel consumption rate per km × distance travelled

Calculation:

Distance travelled above the speed range of 25 – 50 km/hr = 30 km

⇒ Petrol consumed = 30 × 40 = 1200 mL = 1.2 L

Distance travelled other than speed range of 25 - 50 km/hr

= (10 + 10) = 20 km

⇒ Petrol consumed = 20 × 20 = 400 mL = 0.4 L

∴ Total petrol consumed = 1.2 + 0.4 = 1.6 L
BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 13
'p’ varies inversely as the square of q. When q = 4.8, p = 1.5. When p = 24, then the value of q is:
Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 13

Given:

p varies inversely as the square of q

Formula used:

p = k/q2

Where k = integer

Calculation:

According to the question

⇒ 1.5 = k/(4.8)2

⇒ k = 1.55 × 23.04

⇒ k = 34.56

So,

When p = 24

⇒ 24 = 34.56/q2

⇒ q2 = 34.56/24

⇒ q2 = 1.44

⇒ q = 1.2

The possible value of q = ± 1.2

∴ The required result will be 1.2.

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 14

If in a certain code language ‘ACE’ is written as ‘DGJ’, or ARMS is written as DVRY, then how will ‘STOP’ be written in the same language?

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 14

The logic followed here is:
‘ACE’ is written as ‘DGJ’

'ARMS' is written as 'DVRY'

Similarly, for ‘STOP’

So, ‘STOP’ is written as 'VXTV'.
Hence, the correct answer is "Option C".

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 15

Below are given some parts of a sentence in jumbled order. Arrange the parts in the correct order to form a meaningful sentence.
1) to white, beautiful beaches
2) for swimming and relaxing
3) Mandvi Beach is host
4) with amazing seawater

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 15

The correct answer is Option A) i.e. 3, 1, 4, 2.

Key Points

  • The sentence should start with the subject "Mandvi Beach," which is introduced in item 3.
  • The phrase "is host to" naturally follows, indicating what Mandvi Beach is known for.
  • The phrase "white, beautiful beaches" describes the main attraction, fitting well after "is host to."
  • To complete the description, "with amazing seawater" supplements the beauty of the beaches.
  • Finally, "for swimming and relaxing" adds the activities associated with Mandvi Beach, rounding out the sentence.
  • Point 1: The subject "Mandvi Beach" should be introduced first as it is the main focus.
  • Point 2: The phrase "is host to" sets up the expectation of introducing what Mandvi Beach offers.
  • Point 3: Describing the beaches as "white and beautiful" provides a visual aspect.
  • Point 4: "With amazing seawater" enhances the description of the beaches.
  • Point 5: Ending with "for swimming and relaxing" indicates the activities available, completing the coherent idea.

Therefore, the correct answer is- 3, 1, 4, 2

Additional Information

  • Option B (3, 4, 2, 1): This arrangement would read "Mandvi Beach is host with amazing seawater for swimming and relaxing to white, beautiful beaches," which disrupts the logical flow of the sentence.
  • Option C (3, 1, 2, 4): This would place the activity "for swimming and relaxing" in the middle, missing the natural descriptive flow and making the sentence clunky.
  • Option D (3, 2, 4, 1): This arrangement splits the description of the beaches and seawater inappropriately, leading to a less coherent sentence structure.
BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 16

In the questions below, out of the four alternatives choose the word which best expresses the meaning of the given word
RESCUE

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 16

The correct answer is "Help"
Key Points
Let's look at the meaning of the word which is given in the question:

  • Rescue- save (someone) from a dangerous or difficult situation.
  • Example: firemen rescued a man trapped in the river.
  • Help is the closest meaning of rescue

Hence, the correct answer is "option B"
Hinglish
Meanings in Hindi:

  • Rescue- बचाव
  • Example: firemen rescued a man trapped in the river.
  • Defence- रक्षा
  • Safety- सुरक्षा
  • Command- आदेश
BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 17

Arpit started from his office and travelled 2 km towards west, then he turned right and travelled 2 km and then turned left and travelled 3 km. From there he took a bus which travelled straight towards north and he travelled 10 km by this us and reached his home. What is the shortest distance between his home and office?

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 17

According to the given information:

  1. Arpit started from his office and travelled 2 km towards west,
  2. then turned right and travelled 2 km and then turned left and travelled 3 km.
  3. From there he took a bus which travelled straight towards North and travelled 10 km by this bus and reached his home.

The following diagram can be deduced,

The shortest distance between his home and office:

The least distance will be the hypotenuse of triangles.

  • Shortest distance (?2) = 122 + 52 =144 + 25 = 169
  • So the total distance becomes = 13 km.

Hence, the correct answer is "13 km".

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 18

In a family, each daughter has the same number of brothers as she has sisters and each son has twice as many sisters as he has brothers. How many sons are there in the family ?

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 18

Each daughter has the same number of brothers as she has sisters. This means, since there are D daughters, each daughter has D-1 sisters (because a girl cannot be her own sister), and each daughter also has as many brothers, which are S. So, D - 1 = S.

Next, look at the second condition. Each son has twice as many sisters as he has brothers. Thus, for the S sons, there are S-1 brothers (since a boy cannot be his own brother), and twice as many sisters, which are D. So, 2 × (S - 1) = D.

Now, the above gives us a system of two equations, which we can solve simultaneously to get the values for D and S.

Let's plug D = S + 1 from the first equation into the second one to solve for S:

2 × (S - 1) = S + 1

S = 3,

So, there are 3 sons in the family.

Hence, the correct answer is "Option (2)".

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 19

Q is the mother of R. P is the husband of Q. S is the brother of R. How is P related to S?

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 19

Family Chart:

Given:
Q is the mother of R.
P is the husband of Q.
S is the brother of R.

So, P is 'Father' of S.
Hence, the correct answer is "Option 1".

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 20
Seven students R, S, T, U, V, W and X, each scored different marks in a test. V scored more than W but less than U. X scored more than S but less than R. T scored more than U but less than S. Who scored the least marks among all?
Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 20

Seven students: R, S, T, U, V, W and X.

1) V scored more than W but less than U.

U > V > W

2) X scored more than S but less than R.

R > X > S

3) T scored more than U but less than S.

S > T > U

Combining all the statements:

R > X > S > T > U > V > W

W score the least marks in all the students.

Hence, the correct answer is "W".

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 21

In a certain code language, "MELODY" is written as "LEMYDO" and "PURPLE" is written as "RUPELP". How will "CLAUSE" be written in that language?

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 21

The logic followed here is :-

"MELODY" is written as "LEMYDO".

and

"PURPLE" is written as "RUPELP".

Similarly,

"CLAUSE" will be written as :

Hence, the correct answer is "ALCESU".

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 22

Which of the following letter-clusters will replace the question mark (?) in the given series to make it logically complete?
FAN 15, KFS 20, PKX 25, UPC 30, ?

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 22

The pattern followed here is:

Thus, the pattern which logically completes the series is ZUH 35.
Hence, the correct answer is Option (D).

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 23

Identify whether the following statements are true or false
i) In MS-Word 365, hanging indent sets the first line of a paragraph at the margin, and then indents each subsequent line of the paragraph.
ii) MS - Word 365, the purpose of toggle case is to start each word in lower case and the rest in upper case.
iii) In MS - Word 365, the popup dialog box 'Define New Bullet' under the 'Bullet' option in the 'Paragraph' group contains only two buttons, 'Symbol' and 'Picture'.

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 23

The correct answer is option C.
Key Points
Analysis of Statements

  • Statement i: In MS-Word 365, hanging indent sets the first line of a paragraph at the margin, and then indents each subsequent line of the paragraph.
    • A hanging indent is a type of paragraph formatting in which the first line of the paragraph is aligned with the left margin, while all subsequent lines are indented from the left margin.
    • This feature is commonly used in bibliographies and reference lists to make it easier to identify individual entries.
    • Hence, statement i is correct.
  • Statement ii: MS - Word 365, the purpose of toggle case is to start each word in lower case and the rest in upper case.
    • The Toggle Case feature in MS Word changes each letter in a selected text to the opposite case; that is, it switches uppercase letters to lowercase and lowercase letters to uppercase.
    • It does not specifically start each word in lowercase and make the rest of the letters in uppercase.
    • Hence, statement ii is incorrect.
  • Statement iii: In MS - Word 365, the popup dialog box 'Define New Bullet' under the 'Bullet' option in the 'Paragraph' group contains only two buttons, 'Symbol' and 'Picture'.
    • The 'Define New Bullet' dialog box in MS Word 365 indeed contains options to add a Symbol or a Picture as a bullet.
    • However, it also includes an option to define a Font for the bullet, so it contains more than just the two buttons mentioned.
    • Hence, statement iii is incorrect.

Additional Information

  • Hanging Indent:
    • Uses: Commonly used in bibliographies and reference lists.
    • Features: Makes it easier to read and identify individual entries.
  • Toggle Case:
    • Function: Changes each letter in the selected text to the opposite case.
    • Application: Useful for correcting text with incorrect case formatting.
  • 'Define New Bullet' Dialog Box:
    • Options: Includes Symbol, Picture, and Font.
    • Purpose: Allows customization of bullet points in lists.
BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 24
_______ are equations that perform calculations on values in your Excel Worksheet.
Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 24

The correct answer is Formulas.

Key PointsFormulas

  • Formulas in Excel are equations that perform calculations on values in your Excel worksheet.
  • They can combine values, cell references, operators, and functions to produce a new value.
  • Formulas are used to perform operations such as addition, multiplication, and comparison across cells.
  • For example, the formula =A1+A2 adds the values in cells A1 and A2.
  • Formulas can range from simple arithmetic operations to complex calculations involving nested functions.
Key Points
Functions:
  • Functions are predefined formulas in Excel.
  • They are designed to carry out specific calculations based on the arguments provided.
  • Examples include SUM(), AVERAGE(), and VLOOKUP().
  • While functions can be part of formulas, they are not in themselves equations that act on values in the worksheet but rather predefined operations that can be used within formulas.
References:
  • References in Excel are used to refer to cell(s) that contain the data you want to use in your formula.
  • There are different types of references (relative, absolute, and mixed), and they determine how cell references change when a formula is copied to another cell.
  • Although references are crucial elements within formulas for indicating which cells to calculate, they are not the calculations themselves.
Constants:
  • Constants are values that do not change when Excel recalculates a sheet.
  • They can be directly entered into formulas.
  • For example, in the formula =A1*10, the number 10 is a constant because it remains the same each time the formula is calculated.
  • Constants can be numbers, text, or logical values (TRUE or FALSE) that are used in calculations, but unlike formulas, they do not perform calculations themselves.
BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 25
Which of the following is a shortcut key for "Spelling and Grammar" :
Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 25

The correct answer is F7

Key Points

Function keys are a set of keys on a computer keyboard that have a specific function assigned to them in combination with the keys like Control (Ctrl), Alt, and Shift. Here's an overview of the common functions:

  • F1: Opens the Help screen for almost every program.
  • F2: Allows you to rename a selected file or folder. In some programs, it can also give access to a special function.
  • F3: Opens a search feature for an application that is active at the time.
  • F4: Combined with Alt (Alt + F4), it closes the current application or window. Pressed alone, it displays the address bar in Windows Explorer and Internet Explorer.
  • F5: Refresh or reload the page or document window. It is used in all modern internet browsers.
  • F6: It is often used to move the cursor in the application or browser window.
  • F7: Mainly used to check the spelling in Microsoft programs.
  • F8: Used to enter Windows' startup menu (Safe mode, safe mode with networking, etc.), but only during boot time. Not particularly useful while in the operating system itself.
  • F9: In Microsoft Office, this refreshes a document. In some software, it's used to start or stop recording.
  • F10: Activates the menu bar in an application. SHIFT + F10 is the same as right-clicking on an item.
  • F11: Toggles between full-screen and regular view in browsers and other applications.
  • F12: Opens the "Save as" window in Microsoft Word. Ctrl + F12 opens a document in Word. Shift + F12 saves a document in Word.
BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 26

Which of the following shortcut key is used to repeat the last command or action, if possible, in MS-Excel 365?

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 26

The correct answer is Ctrl + Y.
Key Points
Ctrl + Y
is used to redo the last action in MS- word.​

Additional Information
Important shortcuts in MS- Excel

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 27

The Central Processing Unit (CPU) consists of:

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 27

The correct answer is control unit, arithmetic-logic unit and primary storage.
Key Points

  • The Central Processing Unit (CPU) is often referred to as the brain of the computer.
  • The CPU consists of three main components: the Control Unit (CU), the Arithmetic Logic Unit (ALU), and the Primary Storage (often referred to as registers).
  • The Control Unit directs the operation of the processor. It tells the computer's memory, arithmetic/logic unit and input and output devices how to respond to a program's instructions.
  • The Arithmetic Logic Unit performs all arithmetic and logical operations, such as addition, subtraction, and comparison.
  • The Primary Storage is used to store data temporarily that is being processed by the CPU.

BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 28
Which one of the following is an example of a Web Browser?
Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 28

The correct answer is Opera.

Key Points

  • Opera is a popular web browser that allows users to access and navigate the internet. It is known for its speed, security features, and user-friendly interface.
  • Web browsers are software applications designed to retrieve, present, and traverse information on the World Wide Web.
  • Other well-known web browsers include Google Chrome, Mozilla Firefox, Microsoft Edge, and Safari.

Additional Information

  • StarWorks is not a known web browser. It might be a fictional or lesser-known software but does not belong to the category of web browsers.
  • GoogleApps refers to a suite of cloud computing, productivity, and collaboration tools, software, and products developed by Google. It includes applications like Gmail, Google Drive, Google Docs, etc., but it is not a web browser.
  • Odilla seems to be a misspelling or fictional name and is not recognized as a web browser. The correct spelling might be "Mozilla," which is the organization behind the Firefox browser, but "Odilla" itself is not a web browser.
BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 29

Which of the given options best describes the truth of the following statements?

i) The function TRIM() in MS-Excel365 is used to remove all spaces from a text string except for single spaces between words.

ii) If cell J5 contains the text " Excel ", and the formula =TRIM(J5) is entered in cell J6, the result will be "Excel".

iii) The waterfall chart in MS-Excel365 is used to show the cumulative effect of sequentially introduced positive or negative values.

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 29

The correct answer is i - correct, ii - correct, iii - correct

Key Points

  • i. The function TRIM() in MS-Excel365 is used to remove all spaces from a text string except for single spaces between words.
    • Explanation: The TRIM() function in MS-Excel365 is designed to clean up text by removing any extra spaces at the beginning, end, or within a string, leaving only single spaces between words.
    • Verdict: Correct.
  • ii. If cell J5 contains the text " Excel ", and the formula =TRIM(J5) is entered in cell J6, the result will be "Excel".
    • Explanation: The TRIM() function will remove all leading and trailing spaces from the text in cell J5, which means the text " Excel " will be trimmed to "Excel".
    • Verdict: Correct.
  • iii. The waterfall chart in MS-Excel365 is used to show the cumulative effect of sequentially introduced positive or negative values.
    • Explanation: A waterfall chart is a data visualization tool that helps in understanding the cumulative effect of sequentially introduced positive or negative values, often used for visualizing financial data or any scenario that involves incremental changes.
    • Verdict: Correct.
BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 30

Which of the given options best describes the truth of the following statements?

i Bluetooth is a wireless technology for data exchange.

ii JPEG is a format for compressed images.

iii SQL is used for creating dynamic web pages.

Detailed Solution for BSF Head Constable Ministerial (HCM) Mock Test - 4 - Question 30

The correct answer is i - correct, ii - correct, iii - incorrect

Key Points

  • i. Bluetooth is a wireless technology for data exchange.
    • Explanation: Bluetooth is indeed a wireless technology standard used for exchanging data over short distances from fixed and mobile devices, creating personal area networks (PANs).
    • Verdict: Correct.
  • ii. JPEG is a format for compressed images.
    • Explanation: JPEG (Joint Photographic Experts Group) is a commonly used method of lossy compression for digital images, particularly for those images produced by digital photography.
    • Verdict: Correct.
  • iii. SQL is used for creating dynamic web pages.
    • Explanation: SQL (Structured Query Language) is used for managing and manipulating relational databases. It is not used for creating dynamic web pages directly; languages like PHP, ASP.NET, or JavaScript are used for that purpose.
    • Verdict: Incorrect.

View more questions
10 tests
Information about BSF Head Constable Ministerial (HCM) Mock Test - 4 Page
In this test you can find the Exam questions for BSF Head Constable Ministerial (HCM) Mock Test - 4 solved & explained in the simplest way possible. Besides giving Questions and answers for BSF Head Constable Ministerial (HCM) Mock Test - 4, EduRev gives you an ample number of Online tests for practice
Download as PDF