HPSSC JOA (IT) Post Code 913 (2021) - Practice Test (Part 3)

Question 1

How many total individual cells are contained in the rectangular cell range A10:D30 in MS Excel?

Accepted Answer

84

Answer

80

Answer

76

Answer

60

Question 2

What is the single-word substitution for 'The natural home or environment of an animal, plant, or organism'?

Accepted Answer

Habitat

Answer

Environment

Answer

Settlement

Answer

Niche

Question 3

Fill in the blank with the grammatically correct tense form: 'When I met her last year, she ______ for five years.'

Accepted Answer

had been married

Answer

was married

Answer

had married

Answer

would have married

Question 4

What is the meaning of the English idiom 'To look down one's nose at someone'?

Accepted Answer

To regard someone with feelings of superiority or contempt

Answer

To backbite about someone

Answer

To show visible anger

Answer

To insult someone in public

Question 5

'अन्याय' (न न्याय) में कौन सा समास है?

Accepted Answer

तत्पुरुष समास (नञ् तत्पुरुष)

Answer

अव्ययीभाव समास

Answer

द्वंद्व समास

Answer

बहुव्रीहि समास

Question 6

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

Accepted Answer

सत्य + आनंद

Answer

सत्या + आनंद

Answer

सत् + आनंद

Answer

सत्या + नन्द

Question 7

'कोशिश' शब्द में किस प्रत्यय का योग माना जाता है?

Accepted Answer

इश

Answer

को

Answer

कोश

Answer

शिश

Question 8

Which of the following is NOT a valid native data type for a table field in Microsoft Access 2013?

Accepted Answer

Email

Answer

Hyperlink

Answer

Long Text (Memo)

Answer

Currency

Question 9

The two primary design and viewing modes for tables in Microsoft Access are Design View and _______ View.

Accepted Answer

Datasheet View

Answer

Outline View

Answer

User View

Answer

Spreadsheet View

Question 10

How can you search for field values beginning with the letter 'A' or 'B' using wildcards in the Find dialog of MS Access?

Accepted Answer

[AB]*

Answer

(AB)*

Answer

\AB%

Answer

{AB}$

Question 11

Which field type in an MS Access table generates read-only values based on an expression of other table fields?

Accepted Answer

Calculated

Answer

Short Text

Answer

Currency

Answer

Date/Time

Question 12

What is the full form of the database middleware interface acronym ODBC?

Accepted Answer

Open Database Connectivity

Answer

Object Database Connectivity

Answer

Other Database Connectivity

Answer

Oracle Database Connectivity

Question 13

A ______ key consists of one or more column attributes in a table that match the Primary Key of another table, establishing a relationship.

Accepted Answer

Foreign Key

Answer

Secondary Key

Answer

Alternate Key

Answer

Candidate Key

Question 14

What is the decimal number represented by the 8-bit unsigned binary number (10101010)_2?

Accepted Answer

170

Answer

210

Answer

164

Answer

168

Question 15

What is the 8-bit two's complement binary representation of decimal -25?

Accepted Answer

11100111

Answer

11001001

Answer

10011001

Answer

11100110

Question 16

In an Excel sheet with headers in row 1 and 4 rows of data (Sr no in col A, Name in col B, Marks in col C), what does =COUNT(A1:C5) return?

Accepted Answer

8

Answer

12

Answer

15

Answer

4

Question 17

A _______ is a powerful interactive Excel tool used to aggregate, calculate, cross-tabulate, and analyze tabular data dynamically.

Accepted Answer

Pivot Table

Answer

Filter

Answer

Macro

Answer

Range

Question 18

In MS Excel, cell A2 contains the date '10 December 2021'. What text value is returned by the formula =TEXT(A2, "mmmm")?

Accepted Answer

December

Answer

Friday

Answer

344

Answer

6

Question 19

If cell A1 in an MS Excel sheet contains the number 212, what value is returned by the formula =CEILING(A1, 5)?

Accepted Answer

215

Answer

212

Answer

200

Answer

210

Question 20

What text string is returned by the MS Excel formula =BASE(212, 2, 8) (converting 212 to base 2 with 8 minimum characters)?

Accepted Answer

11010100

Answer

10010101

Answer

11010011

Answer

1101011

Question 21

What value is returned by the MS Excel unit conversion formula =CONVERT(100, "in", "ft") converting inches to feet?

Accepted Answer

8.33

Answer

8.6

Answer

8.5

Answer

8.0

Question 22

For a data array of values: 16, 19, 38, 42, 40, 24, what is the value returned by the Excel formula =MEDIAN()?

Accepted Answer

31.0

Answer

13.5

Answer

14.5

Answer

32.0

Question 23

In MS Excel, a ______ is a recorded sequence of keystrokes, commands, and mouse clicks that can be played back to automate repetitive workflows.

Accepted Answer

Macro

Answer

Formula

Answer

Table

Answer

Array

Question 24

Which of the following is NOT a syntactically valid cell address in MS Excel?

Accepted Answer

A:A1

Answer

BA$10

Answer

AC210

Answer

$AB10

Question 25

The concept of punched cards to store binary control sequences was invented by Joseph Marie Jacquard in 1804 for automated:

Accepted Answer

Jacquard Textile Looms

Answer

Abacus Calculators

Answer

Napier's Bones

Answer

Difference Engines