Desicrew New Joiners Qualifier Aptitude Test

1, Which function in Excel checks whether a condition is true or not ?

SUM
COUNT
IF
AVERAGE

2, Which function in Excel tells how many numeric entries are there ?

NUM
COUNT
SUM
CHKNUM

A features that displays only the data in column (s) according to specified criteria

Formula
Sorting
Filtering
Pivot

4, Statistical calculations and preparation of tables and graphs can be done using

Adobe Photoshop
Excel
Notepad
Power Point

Functions in MS Excel must begin with ___

An () sign
An Equal Sign
A Plus Sign
A > Sign

6, The Greater Than sign (>) is an example of _____ operator.

Arithmatic
Logical
Conditional
Greater

The basic unit of a worksheet into which you enter data in Excel is called a

cell
table
box
column

How many sheets are there, by default, when we create a new Excel file ?

1
3
5
10

In Excel, which one denoted a range from B1 through E5

B1 - E5
B1:E5
B1 to E5
B1$E5

An Excel file is generally called a / an :

E-Spreadsheet
Woorksheet
Workbook
Sheet

 I ..... tennis every Sunday morning.

playing
play
am playing
am play

 Don't make so much noise. Noriko is trying to study for her ESL test!

try
tries
tried
is trying

..... many times every winter in Frankfurt.

It snows
It snowed
It is snowing
It is snow

What is the average of first five multiples of 12?

36
38
40
42

Average age of a group of 30 boys is 16 years. A boy of age 19 leaves the group and a new boy joins the group. If the new average age of the group is 15.8 years, find the age of the new boy.

12 years
13 years
14 years
15 years

The average weight of 10 men is decreased by 2 kg when one of them whose weight is 60 kg is replaced by a new man. What is the weight of the new man?

35 kg
40 kg
45 kg
50 kg

The average age of 30 boys in a class is 15 years. If we include the age of two teachers the average age increases by 1. Find the sum of ages of the two teachers.

55 years
58 years
62 years
64 years

18, 40 % of 280 =?

112
116
115
120

Whose 35% is 280?

700
750
800
850

20, 45 *? = 35% of 900

6
7
9
4

Which Union Ministry of India has banned 118 Mobile Apps including PUBG?

Ministry of Defence
Ministry of Electronics and Information Technology
Ministry of External Affairs
Ministry of Home Affairs

India is set to establish a ‘Task force for mutual recognition of academic qualifications’ with which country?

USA
UK
France
Germany

 What is the name of the application of the National Highways Authority of India (NHAI) for FASTag users?

India FASTag
Fast FASTag
My FASTag
Naya FASTag

Who amongst the following had called Rabindranath Tagore as THE GREAT SENTINEL?

Abul Kalam Azad
Mahatma Gandhi
Dr. Rajendra Prasad
Subhash Chandra Bose

Grand Central Terminal, Park Avenue, New York is the world's

highest railway station
longest railway station
largest railway station
None of the above

Which of the following is not a type of broadband internet connection?

Satellite
DSL
Dial up
Cable

What is the term for unsolicited Email?

Spam
Backbone
Usenet
News group

who won the historic gold for India in athletics?

Bhavani Devi
Bicky Thokchom
Ena Arora
Neeraj Chopra

Which country has topped the medals tally in Tokyo 2020 Olympics?

China
Japan
USA
Germany

Who are the two silver medal winners from India in Tokyo Olympics?

Mirabai Chanu and Neeraj Chopra
Lovlina Borgohain and Bajrang Punia
Mirabai Chanu and Ravi Kumar Dahiya
PV Sindhu and Lovlina Borgohain