HP JOA IT Paper (817) - Online Test & Solved Answer Key

Question 1 of 170 Computer

Key combination used to insert a new line character in a cell in MS-Excel?

A. Alt+Enter B. Enter C. Shift+Enter D. Ctrl+Enter

Question 2 of 170 Computer

An array formula can be entered in a cell in MS-Excel by pressing:

A. Ctrl+Enter B. Ctrl+Alt+Enter C. Ctrl+Shift+Enter D. Shift+Enter

Question 3 of 170 Computer

Value of the array formula {=SUM(A1:D1*A2:D2)} for data {5,4,8,2} and {2,2,3,1}?

A. 64 B. 36 C. 43 D. 55

Question 4 of 170 Computer

Value of =LARGE(A1:E2,1)+LARGE(A1:E2,2) for the given table?

A. 14 B. 16 C. 15 D. 12

Question 5 of 170 Computer

Which feature is NOT found in MS-Excel?

A. split a cell B. conditional formatting C. merge adjacent cells D. insert row

Question 6 of 170 Computer

Option to split full names into first and last names in MS-Excel?

A. Text to Columns B. Consolidate C. Columns to Text D. Ungroup

Question 7 of 170 Computer

Option to restrict the value of a cell from a list of values?

A. Consolidate B. Filter C. Freeze Panes D. Data Validation

Question 8 of 170 Computer

If A1 contains 10% and A2 contains 5%, what is =A1*A2?

A. 0.05 B. 0.005 C. 0.5 D. 5

Question 9 of 170 Computer

Formula to round A1 to the nearest multiple of 10?

A. ROUND(#REF!,10) B. ROUND(#REF!,1) C. ROUND(#REF!,-10) D. ROUND(#REF!,-1)

Question 10 of 170 Computer

Feature used to highlight marks if they are below 10?

A. Format Painter B. Data Validation C. Format Cells D. Conditional Formatting

Question 11 of 170 Computer

Which is NOT a valid cell address in MS-Excel?

A. $A$1 B. $A1 C. A:1 D. AS1

Question 12 of 170 Computer

Function to search value in leftmost column and return corresponding value?

A. FIND() B. VLOOKUP() C. SEARCH() D. INDIRECT()

Question 13 of 170 Computer

Cell format to display ONLY the month name of a date?

A. Month B. M C. mmmm D. Mon

Question 14 of 170 Computer

Tool to calculate, summarize, and analyze data to study patterns?

A. Line Chart B. Bar Chart C. Mail merge D. Pivot Table

Question 15 of 170 Computer

Feature to quickly insert consecutive odd numbers in a column?

A. Insert Table B. Fill -> Series... C. Data Sort D. Insert Object...

Question 16 of 170 Computer

Value of =A1+A2 if A1=5 and A2=5%?

A. 0.1 B. 0.055 C. 5.05 D. 0.55

Question 17 of 170 Computer

Chart that shows numerical data as slices of a single circle?

A. Bar B. Area C. Scatter D. Pie

Question 18 of 170 Computer

Feature to record a sequence of keystrokes and play them again?

A. Format Painter B. Macro C. Pivot Table D. Wrap Text

Question 19 of 170 Computer

Full form of UDP with reference to TCP/IP?

A. User Defined Protocol B. Unit Data Packet C. Uniform Data Packet D. User Datagram Protocol

Question 20 of 170 Computer

Topology where all nodes connect to a central connection point?

A. Star B. Ring C. Bus D. Mesh

Question 21 of 170 Computer

Media making use of four pairs of insulated copper wires?

A. UTP B. Coaxial C. Infrared D. Optical Fibre

Question 22 of 170 Computer

Service responsible for translation of domain names to IP?

A. ARP B. DNS C. SNMP D. DHCP

Question 23 of 170 Computer

In which network does the problem of hidden terminal arise?

A. Wireless network B. Optical fibre network C. Local area network D. Social network

Question 24 of 170 Computer

What is the length in bits of an IPv6 address?

A. 64 B. 16 C. 32 D. 128

Question 25 of 170 Computer

The concept of IP addresses belongs to which OSI layer?

A. session B. network C. transport D. data link

Question 26 of 170 Computer

Recommended maximum length of UTP CAT 6 cable?

A. 112 m B. 84 m C. 90 m D. 100 m

Question 27 of 170 Computer

Usable IPv4 addresses in subnet mask 255.255.255.240?

A. 15 B. 16 C. 14 D. 17

Question 28 of 170 Computer

IPv4 address series reserved by IANA for private use?

A. 177.94.0.0/16 B. 192.168.0.0/16 C. 16.24.0.0/16 D. 72.68.0.0/16

Question 29 of 170 Computer

Mode where transmission occurs in both directions, but one at a time?

A. Simplex B. Half-duplex C. Half-simplex D. Full-duplex

Question 30 of 170 Computer

GSM, UMTS and LTE are types of:

A. Wi-Fi technologies B. Optical fibre C. Bluetooth D. Cellular technologies

Question 31 of 170 Computer

Which color wire is NOT found in UTP cable?

A. Orange B. Green C. Blue D. Yellow

Question 32 of 170 Computer

Ubuntu, Kali and CentOS are popular distributions of?

A. Mac B. Linux C. Windows D. Android

Question 33 of 170 Computer

What is the built-in web browser for MacOS?

A. Chrome B. Firefox C. Safari D. Edge

Question 34 of 170 Computer

Linux command to list directory contents?

A. ls B. ln C. cd D. ps

Question 35 of 170 Computer

Chrome mode that can be used for private browsing?

A. Confidential B. Developer C. Incognito D. Promiscuous

Question 36 of 170 Computer

The famous WanaCry malware is an example of?

A. Virus B. Keylogger C. Trojan D. RansomWare

Question 37 of 170 Computer

Malware that grabs keystrokes and sends them to hacker?

A. Kiosk B. SPAM C. Virus D. Keylogger

Question 38 of 170 Computer

Security device that blocks traffic based on rules?

A. NAS B. router C. gateway D. firewall

Question 39 of 170 Computer

Command used to check status of active network connections?

A. ping B. netstat C. ipconfig D. traceroute

Question 40 of 170 Computer

HTML tag used to create a numbered list?

A. B. C. D.

Question 41 of 170 Computer

CAPTCHA concept is based on which test?

A. Babbage B. Tomlinson C. McCarthy D. Turing

Question 42 of 170 Computer

How many heading levels are supported by HTML?

A. Five B. Four C. Six D. Three

Question 43 of 170 Computer

Which is NOT a part of a URL?

A. Protocol B. Access type C. Fragment D. Domain name

Question 44 of 170 Computer

HTML tag to create a data cell in a table?

A. B. C. D.

Question 45 of 170 Computer

HTML tag to insert an image in a web page?

A. B. C. D.

Question 46 of 170 Computer

CSS style specified using the "style" attribute?

A. external B. inline C. internal D. exterior

Question 47 of 170 Computer

CSS property to set space between content and border?

A. gutter B. padding C. margin D. spacing

Question 48 of 170 Computer

How to link external JavaScript with HTML?

A. using B. using C. using D. using

Question 49 of 170 Computer

HTML tag used to create a hyperlink?

A. B. C. D.

Question 50 of 170 Computer

Voice-controlled digital assistant in Windows 10?

A. Teneo B. Siri C. Alexa D. Cortana

Question 51 of 170 Computer

Mode that disables all wireless transmission functions?

A. Train B. Recovery C. Hibernation D. Airplane

Question 52 of 170 Computer

Microsoft anti-malware providing real-time protection?

A. Outlook B. Defender C. McAfee D. Kaspersky

Question 53 of 170 Computer

Mode that boots computer with minimal functionality?

A. Safe B. Flight C. Silent D. Dark

Question 54 of 170 Computer

Web browser installed by default in Windows 10?

A. Edge B. Chrome C. Firefox D. Internet Explorer

Question 55 of 170 Computer

Free cloud storage service provided by Microsoft?

A. Amzon Drive B. Media Fire C. DropBox D. OneDrive

Question 56 of 170 Computer

Windows component with "Quick Actions" and Notifications?

A. Control Panel B. Taskbar C. Action Center D. Status Bar

Question 57 of 170 Computer

Character NOT allowed in a file name in Windows?

A. ! B. ? C. $ D. -

Question 58 of 170 Computer

Utility used to check and fix disk errors in Windows OS?

A. defender B. snipping tool C. scan D. chkdsk

Question 59 of 170 Computer

Shortcut key to open Windows Task Manager?

A. Ctrl+Shift+T B. Windows Key+R C. Ctrl+Alt+F4 D. Ctrl+Shift+Esc

Question 60 of 170 Computer

Database used by Windows OS for settings?

A. MySQL B. Config C. Oracle D. registry

Question 61 of 170 Computer

Linux command to terminate a running process?

A. ps B. fire C. kill D. del

Question 62 of 170 Computer

SQL clause used to filter rows per a condition?

A. WHERE B. ORDER BY C. FROM D. GROUP BY

Question 63 of 170 Computer

SQL statement used to add a new column in a table?

A. CHANGE TABLE B. UPDATE TABLE C. TRUNCATE TABLE D. ALTER TABLE

Question 64 of 170 Computer

Language used as scripting language in HTML?

A. JavaScript B. Java C. ForTran D. Python

Question 65 of 170 Computer

Which of the following is a DDL SQL command?

A. INSERT B. CREATE C. DELETE D. UPDATE

Question 66 of 170 Computer

SQL query to find number of records where y > 70?

A. SELECT count(*) FROM X B. SELECT count(y>70) FROM x C. SELECT count() FROM x... D. SELECT count(*) FROM x...

Question 67 of 170 Computer

Attribute in <input> to ensure it is not left blank?

A. required B. mandatory C. filled D. valid

Question 68 of 170 Computer

Language used to create macros in MS-Excel?

A. Java B. VBA C. Pearl D. JavaScript

Question 69 of 170 Computer

CPU component generating timing and control signals?

A. Arithmetic Unit B. Control Unit C. Logic Unit D. Instruction Pointer

Question 70 of 170 Computer

SSID term is associated with which networks?

A. LAN B. Wi-Fi C. WPAN D. NFC

Question 71 of 170 Computer

How will you insert the symbol "<" in HTML?

A. &less-than; B. &l; C. < D. &less;

Question 72 of 170 Computer

Popular GUI Linux Desktop Environment?

A. GNOME B. GREP C. GIMP D. GIST

Question 73 of 170 Computer

Network device operating in OSI Layer-3?

A. Hub B. Router C. Switch D. Repeater

Question 74 of 170 Computer

Process of writing data on a CD?

A. burning B. firing C. stashing D. frying

Question 75 of 170 Computer

Which is NOT a relational database management system?

A. Oracle B. SQL-Server C. MongoDB D. MySQL

Question 76 of 170 Computer

Box NOT present in CSS box model?

A. Border B. Padding C. Header D. Margin

Question 77 of 170 Computer

SQL query to fetch rows from "emp" with salary < 5000?

A. SELECT...HAVING... B. SELECT...GROUP BY... C. SELECT...WITH... D. SELECT...WHERE...

Question 78 of 170 Computer

SQL statement to delete a database table?

A. DELETE TABLE B. DELETE FROM C. DROP TABLE D. DESTROY TABLE

Question 79 of 170 Computer

Which of the following is a correct CSS rule?

A. p (color = red;) B. p: color = red; C. p color: red; D. p {color: red;}

Question 80 of 170 Computer

HTML tag used to include an external CSS file?

A. <css> B. <link> C. <cript> D. <style>

Question 81 of 170 HP GK

Longitudinal extent of H.P. is?

A. 75°47' to 79°04' E B. 79°14' to 83°15' E C. 83°22' to 87°34' E D. None of these

Question 82 of 170 HP GK

Number of Municipal Corporations in H.P.?

A. 2 B. 3 C. 4 D. 5

Question 83 of 170 HP GK

Sukkar Khad is located in which district of H.P.?

A. Bilaspur B. Hamirpur C. Kangra D. Chamba

Question 84 of 170 HP GK

Siual is a tributary of which river of H.P.?

A. Chenab B. Beas C. Ravi D. Satluj

Question 85 of 170 HP GK

Baba Barbhag Singh fair is celebrated in which district?

A. Sirmour B. Mandi C. Una D. Solan

Question 86 of 170 HP GK

Environmentalist Kinkri Devi belonged to which district?

A. Shimla B. Sirmour C. Kullu D. Kinnaur

Question 87 of 170 HP GK

Hattu peak is located in which district of H.P.?

A. Shimla B. Lahaul-Spiti C. Kinnaur D. Kullu

Question 88 of 170 HP GK

Chuhar Valley is located in which district of H.P.?

A. Mandi B. Chamba C. Sirmour D. Kullu

Question 89 of 170 HP GK

Pin Parbati National Park is in which district of H.P.?

A. Sirmour B. Shimla C. Lahaul-Spiti D. Kullu

Question 90 of 170 HP GK

Bhunda festival is celebrated in which district of H.P.?

A. Kullu B. Sirmour C. Chamba D. Mandi

Question 91 of 170 HP GK

Chamba dominion was founded in which year?

A. 550 AD B. 600 AD C. 650 AD D. 750 AD

Question 92 of 170 HP GK

Suket princely state was founded by?

A. Bahu Sen B. Bir Sen C. Ajbar Sen D. Garur Sen

Question 93 of 170 HP GK

The old name of Jubbal was?

A. Kirgram B. Baned C. Deorha D. Hindur

Question 94 of 170 HP GK

Executing agency of Pong Hydroelectric Project?

A. HPSEB B. NHPC C. NTPC D. BBMB

Question 95 of 170 HP GK

Eternal University is located at which place in H.P.?

A. Baru Sahib B. Waknaghat C. Indora D. Bathu

Question 96 of 170 India GK

The first Buddhist council met at?

A. Rajgriha B. Kashmir C. Pataliputra D. Kanauj

Question 97 of 170 India GK

The Council of 'Nine gems' is associated with?

A. Chandragupta-II B. Shivaji C. Ashoka D. Kanishka

Question 98 of 170 India GK

Token currency was introduced in India by?

A. Balban B. Iltutmish C. Muhammad-bin-Tughlaq D. Alauddin Khilji

Question 99 of 170 India GK

Capital of kingdom of Maharaja Ranjit Singh was?

A. Lahore B. Patiala C. Amritsar D. Kapurthala

Question 100 of 170 India GK

Who was 'The Leader of Indian Unrest'?

A. Gopal Krishna Gokhle B. Subhash Chandra Bose C. Bal Gangadhar Tilak D. M.K. Gandhi

Question 101 of 170 India GK

Who introduced railways and telegraphs in India?

A. Lord Lytton B. Lord Curzon C. Lord Canning D. Lord Dalhousie

Question 102 of 170 India GK

Fundamental Duties were incorporated in which year?

A. 1976 B. 1978 C. 1985 D. 1993

Question 103 of 170 India GK

Which state does NOT have a bicameral legislature?

A. Bihar B. Rajasthan C. Karnataka D. Maharashtra

Question 104 of 170 India GK

Who administers the oath of office to the President?

A. Vice-President B. Prime Minister C. Chief Justice of India D. Lok Sabha Speaker

Question 105 of 170 India GK

Monetary Policy refers to the policy of?

A. Government B. Moneylenders C. Central Bank D. Commercial Banks

Question 106 of 170 India GK

Seasonal unemployment refers to?

A. Agriculture B. Banks C. Public Sector D. Private Sector

Question 107 of 170 World GK

Which is the brightest planet?

A. Mars B. Jupiter C. Mercury D. Venus

Question 108 of 170 Science

Anticyclones are caused by?

A. Violent winds B. Outward spiral winds C. Inward spiral winds D. None of these

Question 109 of 170 World GK

Peru is located in which continent?

A. Asia B. Europe C. Africa D. South America

Question 110 of 170 World GK

The capital of Switzerland is?

A. Bern B. Dhaka C. Moscow D. Muscat

Question 111 of 170 India GK

Which Indian State is known for its Sandalwood?

A. Gujarat B. Maharashtra C. Tripura D. Karnataka

Question 112 of 170 India GK

The highest dam in India is located in?

A. H.P. B. U.P. C. M.P. D. Punjab

Question 113 of 170 Science

Insulin is secreted in?

A. Liver B. Gall Bladder C. Pancreas D. Intestine

Question 114 of 170 Science

Rayon is chemically?

A. Glucose B. Amylose C. Cellulose D. Pectin

Question 115 of 170 Science

Kala-azar is transmitted by?

A. Sand fly B. Tse-tse fly C. Mites D. Black flies

Question 116 of 170 Science

The air becomes heated by?

A. Conduction B. Convection C. Radiation D. Diffusion

Question 117 of 170 Reasoning

Ravi is 12th from top; Radhika is 3 places above. Rank from bottom?

A. 26 B. 27 C. 28 D. 29

Question 118 of 170 Reasoning

Lady's brother is the father of my son's sister. Relation?

A. Daughter B. Sister C. Grand Daughter D. Niece

Question 119 of 170 Reasoning

Rohit walked 25m S, 20m L, 25m L, 15m R. Start distance/direction?

A. 35m East B. 35m North C. 40m East D. 60m East

Question 120 of 170 India GK

Rajendra Kumar Bhandari won which award?

A. Subhash Bose Apda B. PR Bal Puraskar C. Jeevan Raksha D. Ashoka Chakra

Question 121 of 170 India GK

Venue of Exercise Desert Knight 21?

A. Andaman B. Goa C. Jodhpur D. Mumbai

Question 122 of 170 India GK

'Shagun' is a flagship scheme of which state?

A. Nagaland B. Haryana C. Kerala D. Punjab

Question 123 of 170 English

Antonym of 'Bliss' is?

A. Anguish B. Sorrow C. Agony D. Suffering

Question 124 of 170 English

One word substitution for 'ready belief in others'?

A. Credible B. Credulous C. Sensible D. Sensitive

Question 125 of 170 English

He has been recently discharged ____ the army?

A. off B. by C. to D. from

Question 126 of 170 English

Meaning of the idiom 'A red letter day' is?

A. Important day B. Auspicious day C. Dangerous day D. Unimportant day

Question 127 of 170 Hindi

'चयन' का संधि विच्छेद है?

A. च + अन B. चा अन C. चे + अन D. चो + अन

Question 128 of 170 Hindi

देशभक्ति में समास है?

A. द्वन्द्व B. बहुव्रीहि C. तत्पुरुष D. अव्ययीभाव

Question 129 of 170 Hindi

'थकान' में प्रत्यय है?

A. थक B. कान C. न D. आन

Question 130 of 170 Hindi

'रजनी' का पर्यायवाची है?

A. यामिनी B. मनीषा C. तरुणी D. दामिनी

Question 131 of 170 Computer

C data type with members sharing same memory?

A. structure B. pointer C. union D. array

Question 132 of 170 Computer

C preprocessor directives begin with?

A. & B. # C. % D. @

Question 133 of 170 ^

Bitwise exclusive operator symbol in C?

A. & B. $ C. D.

Question 134 of 170 Computer

C operator with 'pre' and 'post' variants?

A. left shift B. increment C. address D. multiplication

Question 135 of 170 Computer

C character strings terminate with?

A. \0 B. \n C. \t D. \s

Question 136 of 170 Computer

C standard library function for formatted output?

A. putchar() B. puts() C. scanf() D. printf()

Question 137 of 170 Computer

scanf() format specifier for a single character?

A. %s B. %u C. %e D. %c

Question 138 of 170 Computer

Output of C segment: int a=5,b; b=++a+7/2; printf("%d",b)?

A. 6 B. 9 C. 8 D. 7

Question 139 of 170 Computer

Output of C segment: int a=7,b=8; printf("%d",a & b)?

A. 7 B. 15 C. 0 D. 8

Question 140 of 170 Computer

Statement NOT true about variables in C?

A. Case-sensitive B. Hold data type values C. Declared anywhere D. Init simultaneously

Question 141 of 170 Computer

Max value stored in 2-byte short data type?

A. 16384 B. 65536 C. 32767 D. 32768

Question 142 of 170 Computer

Decimal representation of 2's complement 1101011?

A. 20 B. -19 C. -43 D. -21

Question 143 of 170 Computer

Bits used for fractional part in IEEE single precision?

A. 31 B. 32 C. 23 D. 24

Question 144 of 170 Computer

Generation using compilers and interpreters?

A. First B. Second C. Third D. None

Question 145 of 170 Computer

Full form of DHCP in computer networking?

A. Domain Hosting B. Device Handshake C. Dynamic Host Control D. Data Handling

Question 146 of 170 Computer

Full form of WiFi in computer networks?

A. Wireless Fidelity B. Wireless Fiber C. Wireless interior D. Wired Fiber

Question 147 of 170 Computer

OS part that handles core functions (CPU/Memory)?

A. semaphore B. shell C. kernel D. device driver

Question 148 of 170 Computer

Full form of ADF in "scanner may have ADF"?

A. Adobe Document B. Automatic Data C. Adobe Data D. Auto Document

Question 149 of 170 Computer

How many bytes are in 1 MiB?

A. 10^6 B. 2^16 C. 2^20 D. 10^5

Question 150 of 170 Computer

Correct increasing order of memory units?

A. GB<PB<TB<EB B. GB<TB<PB<EB C. EB<TB<PB<GB D. GB<TB<EB<PB

Question 151 of 170 Computer

Terms 'hit' and 'miss' are associated with which memory?

A. secondary B. cache C. main D. read-only

Question 152 of 170 Computer

Which type of printer contains a fuser assembly?

A. Thermal B. Dot Matrix C. Laser D. InkJet

Question 153 of 170 Computer

Option to print each full copy before next copy?

A. filter B. orientation C. collate D. sort

Question 154 of 170 Computer

Provides positioning, navigation, and timing?

A. GPS B. EDGE C. Bluetooth D. GPRS

Question 155 of 170 Computer

Process of removing unwanted outer areas from image?

A. cloning B. scaling C. cropping D. Anti-aliasing

Question 156 of 170 Computer

AWS is which type of service platform?

A. application B. cloud C. Internet D. network

Question 157 of 170 Computer

Which is NOT a product of Adobe Inc.?

A. Photoshop B. InDesign C. Illustrator D. Blender

Question 158 of 170 Computer

Developer of 'C' language?

A. Niklaus Wirth B. John Backus C. Charles Babbage D. Dennis Ritchie

Question 159 of 170 Computer

Correct pairing of networking terms and inventors?

A. WWW-Tomlinson B. WWW-Berners-Lee C. Email-Vinton Cerf D. Internet-Backus

Question 160 of 170 Computer

Computer generation that used integrated circuits?

A. First B. Second C. Third D. Fourth

Question 161 of 170 Computer

Who invented the CD-ROM?

A. Jeff Bezos B. Bill Gates C. Kleinrock D. James Russell

Question 162 of 170 Computer

Who invented the USB?

A. Ajay Bhat B. Sabeer Bhatia C. Vinod Dham D. Sam Pitroda

Question 163 of 170 Computer

Shortcut key to open Font dialog box in MS Word?

A. Ctrl+E B. Ctrl+O C. Ctrl+D D. Ctrl+F

Question 164 of 170 Computer

Font size points are equal to ____ of an inch?

A. 01-Jan-1996 B. 01-Jan-1992 C. 01-Jan-1964 D. 01-Jan-1972

Question 165 of 170 Computer

MS-Word default tab stops are at every ____ inch?

A. 0.5 B. 0.25 C. 1 D. 2

Question 166 of 170 Computer

Which is NOT a type of section break in MS-Word?

A. Next Paragraph B. Continuous C. Next Page D. Even Page

Question 167 of 170 Computer

Tab in MS Word containing option to insert footnotes?

A. Review B. Page layout C. References D. Insert

Question 168 of 170 Computer

How to use different page orientations in same doc?

A. Different sections B. Tab stops C. Rotate 180 D. Change margins

Question 169 of 170 Computer

Shortcut key to set paragraph line spacing to 1.5?

A. Ctrl+2 B. Ctrl+L C. Ctrl+5 D. Ctrl+Q

Question 170 of 170 Computer

Feature to create personalized letters to many?

A. Document map B. Macro C. Cross-reference D. Mail-merge

Himachal Pradesh JOA IT (817) Online Test & Solved Paper

Question Palette

Boost Your Himachal Pradesh JOA IT Exam Preparation

📝 JOA IT Online Practice Test

Himachal Pradesh JOA IT (817) Online Test & Solved Paper

Question Palette

Boost Your Himachal Pradesh JOA IT Exam Preparation