Mechanical Engineering Exam  >  Mechanical Engineering Test  >  UPSSSC JE Mechanical Mock Test Series 2026  >  UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Mechanical Engineering MCQ

UPSSSC JE Mechanical Paper 1 Mock Test - 6 Free Online Test 2026


Full Mock Test & Solutions: UPSSSC JE Mechanical Paper 1 Mock Test - 6 (150 Questions)

You can boost your Mechanical Engineering 2026 exam preparation with this UPSSSC JE Mechanical Paper 1 Mock Test - 6 (available with detailed solutions).. This mock test has been designed with the analysis of important topics, recent trends of the exam, and previous year questions of the last 3-years. All the questions have been designed to mirror the official pattern of Mechanical Engineering 2026 exam, helping you build speed, accuracy as per the actual exam.

Mock Test Highlights:

  • - Format: Multiple Choice Questions (MCQ)
  • - Duration: 120 minutes
  • - Total Questions: 150
  • - Analysis: Detailed Solutions & Performance Insights
  • - Sections covered: General Hindi & English, General Intelligence, General Knowledge, Computer knowledge

Sign up on EduRev for free and get access to these mock tests, get your All India Rank, and identify your weak areas to improve your marks & rank in the actual exam.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 1

Direction: Item in this section has a sentence with three underlined parts labelled as (a), (b) and (c). Read each sentence to find out whether there is any error in any underlined part and indicate your response on the Answer Sheet against the corresponding letter, i.e., (a) or (b) or (c). If you find no error, your response should be indicated as (d).

One must not (a) / boast of (b) / one's own success. (c) / No error (d)

Detailed Solution: Question 1

The correct answer is 'd'.

Key Points

  • In this sentence, all the underlined parts are grammatically correct and there is no error. The sentence means that it is not considered appropriate to talk in a proud or arrogant way about one's own success.
  • Let's look at each of the underlined parts:
  • (a) "One must not" is a modal verb construction that expresses a prohibition or a rule. It is followed by the base form of the verb, which in this case is "boast". This means that the sentence is stating that it is prohibited to boast.
  • (b) "Boast of" is a phrasal verb that means to speak with excessive pride or satisfaction about one's own achievements, possessions, or abilities. The preposition "of" is used after the verb "boast" to indicate what the person is boasting about.
  • (c) "One's own success" means one's own achievements or accomplishments. In this context, it refers to the things that a person has accomplished that they might be tempted to boast about.
  • In summary, this sentence is error-free.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 2

Select the most appropriate synonym of the given word.

TRADUCE

Detailed Solution: Question 2

The correct answer is option 2) i.e. Defame.

Key Points

The word 'Traduce' means speak badly of or tell lies about (someone) so as to damage their reputation.

  • The synonyms of the given word 'Traduce' are "defame, asperse, blacken, calumniate, malign".
  • The antonyms of the given word 'Traduce' are "exalt, glorify, honour".
  • The synonym of the given word 'Traduce' is 'Defame' since both have a similar meaning.
  • Example of 'Traduce' in a sentence: The Times has chosen to traduce our reputations.
  • The word 'Defame' means damage the good reputation of (someone); slander or libel.

Hence, the correct answer is 'Defame'. ​​​Let's look at the meaning of the other given options:

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 3

प्रेमचंद के अधूरे उपन्यास का नाम है?

Detailed Solution: Question 3

मंगलसूत्र - यह प्रेमचंद का अधूरा उपन्‍यास है जिसे उनके पुत्र अमृतराय ने पूरा किया। इसके प्रकाशन के संदर्भ में अमृतराय प्रेमचंद की जीवनी में लिखते हैं कि इसका-"प्रकाशन लेखक के देहान्त के अनेक वर्ष बाद 1948 में हुआ।" प्रेमचंद हिन्दी और उर्दू के सर्वाधिक लोकप्रिय उपन्यासकार, कहानीकार एवं विचारक थे। उन्होंने सेवासदन, प्रेमाश्रम, रंगभूमि, निर्मला, गवन, कर्मभूमि, गोदान आदि लगभग डेढ़ दर्जन उपन्यास तथा कफन, पूस की रात, पंच परमेश्वर, बड़े घर की बेटी, बूढ़ी काकी, दो बैलों की कथा आदि तीन सौ से अधिक कहानियाँ लिखीं।

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 4

Directions: Out of the given options, choose the one which is the correct active voice of the sentence given below.

A massive tribal welfare program has been launched by the government in Jharkhand.

Detailed Solution: Question 4

The correct answer is 'The government has launched a massive tribal welfare program in Jharkhand'.

Key Points

  • In Active Voice, a sentence emphasizes the subject, performing an action.
  • In Passive Voice, a sentence emphasizes the action or the object of the sentence.
  • The given sentence is in the passive voice, and 'A massive tribal welfare program' is the subject, and 'the government' is the object.
  • When we convert this sentence into an active voice, the subject 'A massive tribal welfare program' of the passive voice becomes the object, the object 'the government' becomes the subject.
  • The passive format "has + been + V3 (launched)" should be converted into the active format "has + V3 (launched)".
  • This is the active and passive voice rule for the present perfect tense.

Hence, the correct answer is option 1.
Additional Information

  • Verbs of passive format have a different set of tenses (*V3 - Past participle or Third form of the Verb) as given below in the table:

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 5

Select the option that expresses the given sentence in passive voice.

Marvel Comics created Superman.

Detailed Solution: Question 5

Here the correct answer is Superman was created by Marvel Comics.

Key Points

  • The above-given sentence is in the active voice.
  • We need to change it in the passive voice.
  • The following steps are required to change the given sentence into passive voice:-
  • The subject 'Marvel Comics' of the active voice will become the object of the passive voice.
  • The object 'Superman' of the active voice will become the subject of the passive voice.
  • The tense(simple past tense) will change according to the following structure:-
    • Active Voice - Subject + (did + V1) or (V2) + Object.
    • Passive Voice - Object + was/were + V3 + by + Subject.
  • ​Thus, the correct answer is Option 1.

Therefore, the correct passive voice is Superman was created by Marvel Comics.

Additional Information

  • When we convert active voice to passive voice, three things need to be kept in mind:-
    • Change object into subject.
    • Change subject into object.
    • Always use the third form of the verb in the passive voice.
    • Use 'by' before the new object.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 6

Select the most appropriate ANTONYM of the given word.

Loyal

Detailed Solution: Question 6

The correct answer is Fickle.Key Points

  • Loyal” means someone who is very trustable.
  • Fickle” means who is never fixed on anything, especially when it comes to trust or loyalty.
    • Example: You should never trust a fickle-minded person.
  • Therefore, “Fickle” is the correct antonym for “Loyal”.

Additional Information

The meaning and usage of the other words are as follows:

  • Ardent” means very passionate about something.
    • Example: He is an ardent follower of Virat Kohli.
  • Stupid” means foolish.
    • Example: I have never encountered such a stupid excuse for not coming to the party.
  • Tragic” means heartbreaking or sad.
    • Example: His failure in the exam after so much hard work was very tragic.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 7

Birbal penned his collection of poetry under the name_________

Detailed Solution: Question 7

The correct answer is 'Brahm'.

Key Points

  • Let's refer to the following lines of the passage:
    • Birbal's collection of poetry published under the pen name Brahm is preserved in Bharatpur Museum, Rajasthan, India.
  • Thus, from above we can conclude that the correct answer is option 3.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 8

वह खा रहा था।” – इस वाक्य में क्रिया किस काल का बोध करा रही है?

Detailed Solution: Question 8

"वह खा रहा था।” – इस वाक्य में अपूर्ण भूत काल का बोध हो रहा है।
  • वह खा रहा था। - अपूर्ण भूत
  • क्रिया के जिस रूप से ये पता चलता हैं कि कार्य भूतकाल में पूरा नहीं हुआ था तथा कार्य अभी भी जारी है उसे अपूर्ण भूत कल कहते हैं।
    • उदाहरण - वह खेल रहा था।

Key Pointsअन्य विकल्प -

  • संदिग्धभूत - क्रिया के जिस रूप से बीते हुआ अतीत याद आये या उसका संदेह हो उसे संदिग्ध काल कहते हैं।
  • हेतुहेतुमद् भूतकाल - क्रिया के जिस रूप से यह पता चलता हैं कि कार्य हो सकता था परंतु दूसरे कार्य की वजह से नहीं हो पाया हैं ऐसे काल को हेतुहेतुमद् भूतकाल कहते हैं।
  • हेतुहेतुमद् भविष्यत् - जहाँ क्रिया के भविष्य में हो सकने पर किसी कारण का प्रतिबन्ध दीखता हो, वहाँ क्रिया के काल को हेतुहेतुमद भविष्य काल कहते हैं।

Additional Informationकाल के तीन भेद हैं -

  1. भूतकाल
  2. वर्तमान काल
  3. भविष्य काल

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 9

निम्न में से किस वाक्य में शब्दचयन की दृष्टि अशुद्धता है?

Detailed Solution: Question 9

सही उत्तर है - “भारत एक शक्तिशील देश है”।

  • उपरोक्त विकल्पो मे से "​भारत एक शक्तिशील देश है" वाक्य में शब्दचयन की दृष्टि अशुद्धता है।
  • अन्य विकल्प शुद्ध है। अत: "भारत एक शक्तिशील देश है" सही उत्तर होगा।

Key Points

  • शुद्ध वाक्य होगा:- भारत एक शक्तिशाली देश है।
  • अत: वाक्य में वर्तनी संबंधी अशुद्धता है।

Additional Information

  • यदि वाक्य में किसी तरह की अशुद्धि होती है तो आपके बोले गए वाक्य का अर्थ भी बदल सकता है।
  • अत: वाक्य को बोलते व लिखते समय उसकी शुद्धता, स्पष्टता और सार्थकता का ध्यान रखना बहुत जरूरी है।

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 10

Directions: Study the following question carefully and choose the right answer.

If ‘Development’ is written as ‘Tnemdevelop’. Then ‘Evaluation’ will be written as

Detailed Solution: Question 10


Hence, option D is correct.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 11

Direction: If a Paper (Transparent Sheet ) is folded in a manner and a design or pattern is drawn. When unfolded this paper appears as given below in the answer figure. Choose the correct answer figure given below.

Find out from the four alternatives as how the pattern would appear when the transparent sheet is folded at the dotted line.

Question Figure

Answer Figure

Detailed Solution: Question 11

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 12

Directions to Solve

In each of the following questions find out the alternative which will replace the question mark.

Question -

MO : 13 11 :: HJ : ?

Detailed Solution: Question 12

In this analogy, subtract the position number of each alphabet from 26.
M ⇒ 26 - 13 = 13
O ⇒ 26 - 15 = 11
⇒ MO : 13 11
Similarly,
H ⇒ 26 - 8 = 18
J ⇒ 26 - 10 = 16
So, right answer is 18 16

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 13

Directions: Each of the following consists of a question and two statements numbered I and II given below it. You have to decide whether the data provided in the statements are sufficient to answer the question:

In which direction is Library with respect to the college?
I.  Point A is 3km North of Library. Point C is 3km North of point B. Point D is 3km East of point C.
II.  College is 7km North of point F. Point D is 6km North of point E. Library is 7km west of point E. Point F is 4km East of point E.

Detailed Solution: Question 13

Checking → statement I:

References:

Point A is 3km north of library.

Point C is 3km North of Point B.

Point D is 3km East of point C.

Inferences:

From the above references, we can conclude that instruction about college is missing in statement I.

So, we can’t determine the direction between library and college.

Thus, statement I alone is not sufficient to answer the question

Checking → Statement II:

References:

College is 7km North of point F.

Point D is 6km North of point E.

Library is 7km west of point E.

Point F is 4km East of point E.

Inferences:

From the above references, we can conclude the following.


We can conclude that library is to the South West direction with respect to college.

Thus, statement II alone is sufficient to answer the question.

Hence, option B is correct.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 14

Directions: Each of the following consists of a question and two statements numbered I and II given below it. You have to decide whether the data provided in the statements are sufficient to answer the question:

Eight persons A, B, C, D, U, V, W, and X are sitting in two parallel rows. A, B, C, and D are sitting in row-1 facing south direction and U, V, W, and X, are sitting in row-2 facing north direction in such a way that each person sitting in row-1 faces the person sitting in row-2. Who among the following faces the one who sits just right of X?
Statement I:
Only one person sits between U and W who is sitting at the extreme right end of the row. B sits second to the left of A. C faces the one who is an immediate neighbour of U. V faces D.
Statement II: A sits 2nd from one end and faces the U. B does not face the one who is the neigbour of X. D and V does not sit at ends of the rows.

Detailed Solution: Question 14

From Statement I: From this statement, we get the following arrangement:

Clearly, Statement I alone is not sufficient to answer the question.
From Statement II: From this statement, we get the following arrangement:

Clearly, Statement II alone is not sufficient to answer the question.
Checking both Statement, I and II together:

So, by combining both the statements, we can say A faces U, who sits just right of X.
Clearly, Statement I and Statement II together are necessary to answer the question.
Hence, option E is the correct answer.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 15

Directions to Solve

In each word of the following questions consists of pair of words bearing a relationship among these, from amongst the alternatives, pick up the pair that best illustrate a similar relationship.

Question -

Letter : Word

Detailed Solution: Question 15

As Word is a group of letters similarly Book is a group of papers.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 16

Direction: Study the following information carefully and answer the given questions besides.

Some boys are sitting in a row facing the south. Only three boys sit between O and H. Only two boys sit to the left of J. O sits third to the left of M. More than seven boys sit between P and J. V sits fourth to the right of O. Eight boys sit between R and J. More than 12 boys sit between P and H. Only three boys sit between R and M. T sits third to the right of M. P sits fourth to the right of R.
Q. At least how many boys are sitting in a row?

Detailed Solution: Question 16

From the common explanation, we can say that there are at least 16 boys sitting in the row.
Hence, Option B is correct.
Final Arrangement:

Common Explanation:
References:

Only two boys sit to the left of J.
Eight boys sit between R and J.
Only three boys sit between R and M.
Inferences:
From the above references, we get two different cases:

References:
P sits fourth to the right of R.
O sits third to the left of M.
Inferences:
So, from this case 2 will be eliminated as P sits fourth to the right of R.

References:
Only three boys sit between O and H.
T sits third to the right of M.
V sits fourth to the right of O.
More than 12 boys sit between P and H.
More than seven boys sit between P and J.
Inferences:
From the above reference, we get the final arrangement:

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 17

Bir Bara Ban Wildlife Sanctuary is situated in which district of Haryana?

Detailed Solution: Question 17

The correct answer is Jind.

  • Bir Bara Ban Wildlife Sanctuary is in the Jind district of Haryana.
  • It was changed to a Sanctuary in October 2007.
  • About Jind - 
    • It is one of the 7 districts which were constituted with the establishment of Haryana.
    • It shares its border with 7 districts of Haryana namely Fatehabad, Hisar, Rohtak, Sonipat, Panipat, Karnal and Kaithal.
    • It also shares a border with Sangrur district of Punjab.
    • It was founded by Sikh King Raja Gajpat Singh in 1766.
    • According to the 2011 census, the
      • Total population is 1,334,152.
      • Sex ratio is 871.
      • The literacy rate is 71.4%.
      • The population density is 494.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 18

UWSP and USEP are the two components of which yojna

Detailed Solution: Question 18

Swaran Jayanti Shahari Rozgar Yojna. The Urban Self-Employment Program and the Urban Wage Employment Program are two special schemes of the SJSRY initiated in December 1997, which replaced various programs operated earlier for urban poverty alleviation

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 19

Who is the founder of Modern Punjabi literature?

Detailed Solution: Question 19

The correct answer is 'Bhai Veer Singh'.

Key Points

  • Bhai Veer Singh is the founder of Modern Punjabi literature.
  • He was an Indian poet, scholar, and theologian of the Sikh revival movement.
  • He played an important part in the renewal of the Punjabi literary tradition.
  • Bhai Veer Singh was one of the founders of the Punjab & Sind Bank.
  • He was honored with the Sahitya Akademi Award in 1955 and the Padma Bhushan Award in 1956.

Additional Information

  • Nanak Singh
    • Nanak Singh was an Indian poet, songwriter, and novelist of the Punjabi language.
    • His literary works in support of India's independence movement led the British to arrest him.
    • He published novels that won him literary acclaim.
  • Professor Mohan Singh
    • Professor Mohan Singh was a noted Indian poet in the Punjabi language.
    • He was one of the early pioneers of modern Punjabi poetry.
  • Amrita Pritam
    • Amrita Pritam was an Indian novelist, essayist, and poet, who wrote in Punjabi and Hindi.
    • A prominent figure in Punjabi literature, she is the recipient of the 1956 Sahitya Akademi Award.
    • She is considered the first eminent female Punjabi writer, novelist, and poet of the 20th century.
    • Her writing is equally loved by the people of India and Pakistan.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 20

How do banks serve as intermediaries in the financial system, based on the information provided?

Detailed Solution: Question 20

Banks act as intermediaries by facilitating the transfer of funds between those who have surplus funds (depositors) and those who require funds (borrowers). This mediation role enables banks to channel deposits into loans, supporting various economic activities and fostering financial transactions in the economy.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 21

With reference to India, Reh, Kallar, Chopan and Rakar are the names of

Detailed Solution: Question 21

The correct answer is Saline and Alkaline Soils.

Key Points

Saline and Alkaline Soils

  • They are also known as Usara soils.
  • Various local names for saline soils are Reh, Kallar, Chopan, Rakar, Thur, Karl, etc. Hence, Option 3 is correct.
  • These soils have developed in areas with dry climatic conditions accompanied by a lack of proper drainage.
  • In this situation, salts of sodium, calcium, and magnesium are deposited on the upper layer of the soil by capillary action.
  • Some of the salts are transported in solution by the rivers.
  • These soils are also formed when saline water spreads on the land at the time of high tide in coastal areas.
  • Their texture ranges from sandy to loamy.
  • Saline and Alkaline Soils occupy 68,000 sq km of area.
  • Parts of Andhra Pradesh, Telangana, Karnataka, Bihar, Uttar Pradesh, Haryana, Punjab (side effects of improper or excess irrigation), Rajasthan and Maharashtra have this kind of soil.
  • The accumulation of these salts makes the soil infertile and renders it unfit for agriculture.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 22

Who got the honour to be the first Punjabi Sufi poet?

Detailed Solution: Question 22

The correct answer is Baba Farid ji.

  • Baba Farid was a Sufi saint of the Chishti Order.
  • His original name was Hazrat Fariduddin Ganjshakar.
  • He is recognized as the first major Sufi poet of the Punjabi Language.
    • Some parts of the poems of Baba Farid have been included in the Guru Granth Sahib.

Important Points

  • Bulle Shah was one of the most eminent Punjabi Sufi poet and philosopher who is best known for his Kafi verses.
    • Kafi versus Qawwali is a lyrical composition, mostly in Punjabi and Sindhi, meant for singing in a certain style. The subject matter is essentially mystical-ethical in nature.
  • Hazrat Peelu was a famous Punjabi poet. His romance story Mirza Sahiban is considered one of the best creations of Punjabi literature.
  • Shah Hussain was a Punjabi Sufi poet of the 16th century, who, along with Bulleh Shah and Baba Farid, is considered a pioneer of the Kafi form of Punjabi poetry.
    • Shah Hussain’s love for a Brahmin boy called “Madho” or “Madho Lal” is famous, and they are often referred to as a single person with the composite name of “Madho Lal Hussain”.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 23

What is the primary characteristic feature of cropping pattern in India?

Detailed Solution: Question 23

The primary characteristic feature of cropping pattern in India is the amazing variety of crops. Different regions cultivate diverse crops based on factors such as soil, climate, and water supply.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 24

In MS-Word, which of the following options allows you to combine (or combine) two or more cells in a table?

Detailed Solution: Question 24

The correct answer is Merge Cells.

Key Points

  • First, use the Layout tab to access the Merge Cells button.
  • Second, use the Merge cells option found on the context menu when you right-click on the selected table cells.
  • This will allow you to quickly access the Merge cells option.

MS-Word Tutorial - Merging Cells of a Table

Additional Information

  • Distributed Rows
    • Select the rows that you want to affect.
    • Choose the Layout tab on the ribbon.
    • Click the Distribute Rows tool, in the Cell Size group.

4 Effective Ways to Distribute Rows and Columns Evenly in Your Word Table - Data Recovery Blog

  • Erase table lines by using the Eraser button.
    • To do this, click the “Layout” tab of the “Table Tools”. contextual tab in the Ribbon. Then click the “Eraser” button in the “Draw” button group.
    • After clicking this button, your mouse pointer turns into an eraser when you hold it over the document.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 25

Which is not the application of internet?

Detailed Solution: Question 25

Explanation:
The application of the internet refers to the various ways in which the internet is used in our daily lives. The internet has revolutionized the way we communicate, conduct business, and access information. However, there are certain activities that are not considered as applications of the internet.
Here, the option "D: Sleeping" is not an application of the internet. Sleeping is a biological process and does not involve the use of the internet. The internet cannot be directly used for sleeping purposes.
Applications of the Internet:
A: Communication
- The internet allows people to communicate with each other through various means such as email, instant messaging, video calls, and social media platforms.
- It enables people to connect with others globally, facilitating communication in real-time.
B: Banking
- The internet is widely used for online banking services, allowing individuals to access their bank accounts, make transactions, and manage their finances online.
- It provides convenience and accessibility to banking services from anywhere at any time.
C: Shopping
- Online shopping has become increasingly popular with the advent of the internet.
- It allows consumers to browse and purchase products from various online retailers, making shopping more convenient and accessible.
In summary:
The internet has numerous applications, including communication, banking, and shopping. However, sleeping is not an application of the internet as it does not involve the use of online services or activities.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 26

Which of the following text formatting task is achieved with the help of keyboard shortcut 'Ctrl + E' in MS-Word 2010?

Detailed Solution: Question 26

The correct answer is Align center.

Key Points

  • Alignment is how the text in the document shows up to the user.
  • By default, Excel provides left alignment of the text. But you can change the alignment format.
  • For center alignment, place the cursor anywhere in the text and use the shortcut Ctrl + E. Hence option 4 is correct.
  • To go back to the default alignment or left-align, place the cursor in the text and use Ctrl + L shortcut. Left alignment allows the user to align the text to the left margin of the page.

Additional Information

  • Use Ctrl + R shortcut for the right alignment. Right alignment allows the user to align text to the right margin of the page.
  • Justify text allows the user to align the text to both the margins of the document or page.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 27

What is the function of ‘Ctrl + I’?

Detailed Solution: Question 27

The correct answer is Italic.

Key Points

  • Ctrl + I is used to apply the italic format to the selected text. Hence, Option 3 is correct.

Additional Information

  • List of Computer Shortcut Keys

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 28

Which data type is NOT in M.S. Excel?

Detailed Solution: Question 28

The correct option is (2) Label

Key Points

  • When you wish to enter data manually into Excel, you have a few choices. You can enter data into a single cell, multiple cells at once, or across multiple worksheets.
  • You can enter text, numbers, dates, or times as your data. The data can be formatted in many different ways.
  • Text, number, logical, and error data are the four categories of data. Each type can be used for a variety of tasks, so knowing which to use and when to use it is crucial.
  • You might also keep in mind that while exporting data into a spreadsheet, some data types might change.

Additional Information
Label:- Text that you have entered into a cell is typically referred to as a label. Excel interprets the label as a "tag" that designates that range of numbers if it occurs next to a continuous list of values. In formulas, the label can then be used in place of specific cell references.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 29

Select the option that contains only computer input devices

Detailed Solution: Question 29

A computer is an electronic machine that processes digital data into human information (numeric, text, or physical) and controls electrical devices. A computer must have a system to receive information from the outside world and must be able to communicate results to the external world.

Peripheral Devices/Input and Output Devices: Input and output devices constitute a major part of a computer system. They are an interface between the user and the computer system.

Hence, it can be concluded from the given table that joystick, keyboard, mouse and digitiser are all input devices.

UPSSSC JE Mechanical Paper 1 Mock Test - 6 - Question 30

Which of the following is correct syntax in Excel?

Detailed Solution: Question 30


The correct syntax in Excel is option A: `=IF(LogicalTest, TrueResult, FalseResult)`. Here's a detailed explanation:
IF Function in Excel:
The IF function in Excel is used to perform logical tests and return different values based on the result of the test. It follows the syntax: `=IF(LogicalTest, TrueResult, FalseResult)`, where:
- `LogicalTest` is the condition that is being evaluated.
- `TrueResult` is the value or expression that is returned if the logical test is true.
- `FalseResult` is the value or expression that is returned if the logical test is false.
Explanation of the Given Syntax:
The correct syntax in Excel is option A: `=IF(LogicalTest, TrueResult, FalseResult)`. Let's break it down:
- `IF`: This is the function name that indicates we are using the IF function in Excel.
- `LogicalTest`: This is the condition that is being evaluated. It can be a comparison, a formula, or any expression that returns a logical value (TRUE or FALSE).
- `TrueResult`: This is the value or expression that is returned if the logical test is true. It can be a number, text, formula, or reference to a cell or range.
- `FalseResult`: This is the value or expression that is returned if the logical test is false. It can also be a number, text, formula, or reference to a cell or range.
Incorrect Syntax:
Let's also explain why the other options are incorrect:
- Option B: `=IF(LogicalTest, (TrueResult, FalseResult)`: This syntax is incorrect because the TrueResult and FalseResult are enclosed in parentheses without separating them using a comma.
- Option C: `=IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)`: This syntax is incorrect because it separates the TrueResult and FalseResult into separate IF functions without using the comma to separate the arguments within the IF function.
- Option D: `=IF(LogicalTest,True Result), IF (LogicalTest,   FalseResult)`: This syntax is incorrect because it separates the TrueResult and FalseResult into two separate IF functions, but there is an unnecessary comma in True Result and an unnecessary space before FalseResult.
Therefore, the correct syntax in Excel is option A: `=IF(LogicalTest, TrueResult, FalseResult)`.

View more questions
16 tests
Information about UPSSSC JE Mechanical Paper 1 Mock Test - 6 Page
In this test you can find the Exam questions for UPSSSC JE Mechanical Paper 1 Mock Test - 6 solved & explained in the simplest way possible. Besides giving Questions and answers for UPSSSC JE Mechanical Paper 1 Mock Test - 6, EduRev gives you an ample number of Online tests for practice
Download as PDF