Dream With Data
Training, Research & Development Center
Dream With Data Entrance Awareness Test
Exam Name
DreamWithData Entrance Awareness Test
Duration
40 Minutes
Total Questions 100 Multiple Choice Questions
Marks
1 Mark per Question
Mode
Online
1 / 100
In Excel, the default alignment for text is:
2 / 100
What is the smallest unit of data in a computer?
3 / 100
Excel is developed by:
4 / 100
Which of the following is NOT a web browser?
5 / 100
Formula for sum of B2 to B10:
6 / 100
Find the missing number:4 → 16, 5 → 25, 6 → 36, 7 → ?
7 / 100
The term “machine learning” refers to:
8 / 100
BIOS stands for:
9 / 100
Which email service is developed by Google?
10 / 100
If “SUN” is coded as “TVQ”, what is “MOON”?
11 / 100
If 5x – 15 = 10, then x = ?
12 / 100
Which type of visualization is best for comparing categories?
13 / 100
Which component interprets and executes program instructions in a computer?
14 / 100
In computing, GUI stands for:
15 / 100
Which language is most often used for database querying?
16 / 100
The main purpose of an Operating System is to:
17 / 100
Which AI tool suggests videos on YouTube?
18 / 100
“Cloud Computing” means:
19 / 100
In analytics, “raw data” means:
20 / 100
The AutoFill feature in Excel is used for:
21 / 100
Which of the following is an example of categorical data?
22 / 100
In Excel, which symbol is used to begin a formula?
23 / 100
The safest password is:
24 / 100
Which of these is NOT an AI application?
25 / 100
What does the COUNT function do?
26 / 100
Power BI is mainly used for:
27 / 100
The term “bit” stands for:
28 / 100
Which is the odd one out?
29 / 100
What is the maximum number of columns in Excel 365?
30 / 100
Which of the following is NOT a valid Excel function?
31 / 100
Which number completes the pattern?8, 16, 32, 64, ___
32 / 100
Data stored in rows and columns is called:
33 / 100
Which of the following storage has the fastest access speed?
34 / 100
A group of 8 bits is called a:
35 / 100
Which of the following represents cell A1 to C5?
36 / 100
The safest online practice is:
37 / 100
Which of the following is NOT a data analysis tool?
38 / 100
Which is the correct order in a data lifecycle?
39 / 100
Which file format preserves formulas and charts?
40 / 100
Which protocol is used to transfer web pages?
41 / 100
A data analyst uses Python mainly for:
42 / 100
Which AI feature allows email spam detection?
43 / 100
In Excel, which function is often used to find average sales data?
44 / 100
1, 4, 9, 16, 25, 36, ?
45 / 100
The average of 5 numbers is 30. If one number is removed, the average becomes 28. Find the removed number.
46 / 100
A man walks 3 km East, then 4 km North. How far is he from starting point?
47 / 100
The brain of a computer is the:
48 / 100
Which among the following is NOT an output device?
49 / 100
In Windows, the shortcut key Ctrl + Shift + N is used to:
50 / 100
Which of the following is volatile memory?
51 / 100
The function =AVERAGE(5,10,15) returns:
52 / 100
Which AI model generates human-like text responses?
53 / 100
Which software helps you create text documents?
54 / 100
Shortcut key to insert a new worksheet:
55 / 100
Which symbol is used for cell range?
56 / 100
If all BLOSSOM are FLOWERS and all FLOWERS are PLANTS, then all BLOSSOM are:
57 / 100
Arrange in order: “Egg”, “Hen”, “Chick”
58 / 100
When data is too large to process with normal tools, it is called:
59 / 100
If 3 pens = ₹45, what is the cost of 7 pens?
60 / 100
A dataset with missing values is considered:
61 / 100
AI that mimics human conversation is known as:
62 / 100
What is the main goal of data analytics?
63 / 100
Which part of the CPU performs mathematical operations?
64 / 100
Which cloud platform provides free storage by Google?
65 / 100
Which chart displays proportions of a whole?
66 / 100
The intersection of a row and a column is called:
67 / 100
Which function counts only text entries?
68 / 100
Which among the following is system software?
69 / 100
Which shape does not belong: Circle, Triangle, Square, Cube?
70 / 100
2, 6, 12, 20, 30, ? — what is the next number?
71 / 100
File extension .csv represents:
72 / 100
A train running 60 km/h crosses a pole in 30 seconds. Its length is:
73 / 100
What ensures secure website connection?
74 / 100
The process of finding hidden patterns in large data sets is
75 / 100
The full form of AI is:
76 / 100
Which device converts digital data into analog signals?
77 / 100
Which Excel feature removes duplicates?
78 / 100
Which file extension is associated with PowerPoint?
79 / 100
A clock shows 3:15. What is the angle between hour and minute hand?
80 / 100
Which of the following data types can be analyzed numerically?
81 / 100
AI in smartphones helps in:
82 / 100
A dashboard in analytics helps to:
83 / 100
Cloud storage allows users to:
84 / 100
Choose the correct analogy:Mango : Fruit :: Spinach : ?
85 / 100
To arrange data alphabetically in Excel, use:
86 / 100
Which of these is NOT an example of an input device?
87 / 100
The process of cleaning incorrect or duplicate data is
88 / 100
If A = 1, B = 2, …, then what is the sum of D + E + F?
89 / 100
Which memory is directly accessed by the CPU?
90 / 100
If 5 men can complete a task in 8 days, how many days will 10 men take?
91 / 100
Online storage of data is commonly referred to as:
92 / 100
If 24 = 7, 49 = 10, 64 = 11, 81 = ?, find ?
93 / 100
In business analytics, a “KPI” stands for:
94 / 100
Which number does not belong to the series: 1, 4, 9, 16, 25, 36, 49, 65?
95 / 100
Data becomes information when:
96 / 100
Which of the following is a phishing example?
97 / 100
What does “phishing” attempt to steal?
98 / 100
A Data Analyst primarily focuses on:
99 / 100
Which file type cannot store formulas?
100 / 100
Which chart type is best for showing trends over time?
Your score is
Dream With Data (DwD)
© 2023 Created by Dream with Data ( DwD )