/100

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

Which type of visualization is best for comparing categories?

2 / 100

The term “machine learning” refers to:

3 / 100

In business analytics, a “KPI” stands for:

4 / 100

Power BI is mainly used for:

5 / 100

Which of the following is an example of categorical data?

6 / 100

A man walks 3 km East, then 4 km North. How far is he from starting point?

7 / 100

A train running 60 km/h crosses a pole in 30 seconds. Its length is:

8 / 100

Which AI model generates human-like text responses?

9 / 100

What ensures secure website connection?

10 / 100

If “SUN” is coded as “TVQ”, what is “MOON”?

11 / 100

In Excel, which function is often used to find average sales data?

12 / 100

A dashboard in analytics helps to:

13 / 100

Which shape does not belong: Circle, Triangle, Square, Cube?

14 / 100

If 3 pens = ₹45, what is the cost of 7 pens?

15 / 100

Which among the following is system software?

16 / 100

The brain of a computer is the:

17 / 100

Which number completes the pattern?
8, 16, 32, 64, ___

18 / 100

Which Excel feature removes duplicates?

19 / 100

A clock shows 3:15. What is the angle between hour and minute hand?

20 / 100

Which of the following is NOT a valid Excel function?

21 / 100

Which of the following storage has the fastest access speed?

22 / 100

Which chart displays proportions of a whole?

23 / 100

The full form of AI is:

24 / 100

Data stored in rows and columns is called:

25 / 100

Which of the following represents cell A1 to C5?

26 / 100

In Excel, the default alignment for text is:

27 / 100

Which of the following is NOT a web browser?

28 / 100

Formula for sum of B2 to B10:

29 / 100

Which file format preserves formulas and charts?

30 / 100

Which is the correct order in a data lifecycle?

31 / 100

What does “phishing” attempt to steal?

32 / 100

Which of the following is NOT a data analysis tool?

33 / 100

BIOS stands for:

34 / 100

Cloud storage allows users to:

35 / 100

What is the main goal of data analytics?

36 / 100

Which cloud platform provides free storage by Google?

37 / 100

In Excel, which symbol is used to begin a formula?

38 / 100

Excel is developed by:

39 / 100

Shortcut key to insert a new worksheet:

40 / 100

“Cloud Computing” means:

41 / 100

Which AI tool suggests videos on YouTube?

42 / 100

A data analyst uses Python mainly for:

43 / 100

A dataset with missing values is considered:

44 / 100

What is the smallest unit of data in a computer?

45 / 100

Which of these is NOT an example of an input device?

46 / 100

Which email service is developed by Google?

47 / 100

Which memory is directly accessed by the CPU?

48 / 100

Which file extension is associated with PowerPoint?

49 / 100

Which software helps you create text documents?

50 / 100

The safest online practice is:

51 / 100

Which among the following is NOT an output device?

52 / 100

The process of finding hidden patterns in large data sets is

53 / 100

File extension .csv represents:

54 / 100

A Data Analyst primarily focuses on:

55 / 100

In analytics, “raw data” means:

56 / 100

Find the missing number:
4 → 16, 5 → 25, 6 → 36, 7 → ?

57 / 100

Arrange in order: “Egg”, “Hen”, “Chick”

58 / 100

Which of the following is volatile memory?

59 / 100

Which number does not belong to the series: 1, 4, 9, 16, 25, 36, 49, 65?

60 / 100

The main purpose of an Operating System is to:

61 / 100

If all BLOSSOM are FLOWERS and all FLOWERS are PLANTS, then all BLOSSOM are:

62 / 100

What does the COUNT function do?

63 / 100

The process of cleaning incorrect or duplicate data is

64 / 100

2, 6, 12, 20, 30, ? — what is the next number?

65 / 100

The intersection of a row and a column is called:

66 / 100

Which chart type is best for showing trends over time?

67 / 100

When data is too large to process with normal tools, it is called:

68 / 100

Which function counts only text entries?

69 / 100

The term “bit” stands for:

70 / 100

To arrange data alphabetically in Excel, use:

71 / 100

Which language is most often used for database querying?

72 / 100

Which part of the CPU performs mathematical operations?

73 / 100

If 5x – 15 = 10, then x = ?

74 / 100

If 24 = 7, 49 = 10, 64 = 11, 81 = ?, find ?

75 / 100

AI in smartphones helps in:

76 / 100

Which of the following data types can be analyzed numerically?

77 / 100

Data becomes information when:

78 / 100

Which device converts digital data into analog signals?

79 / 100

Which of these is NOT an AI application?

80 / 100

Which symbol is used for cell range?

81 / 100

What is the maximum number of columns in Excel 365?

82 / 100

Which component interprets and executes program instructions in a computer?

83 / 100

Which is the odd one out?

84 / 100

AI that mimics human conversation is known as:

85 / 100

Which file type cannot store formulas?

86 / 100

Which of the following is a phishing example?

87 / 100

Which protocol is used to transfer web pages?

88 / 100

In computing, GUI stands for:

89 / 100

A group of 8 bits is called a:

90 / 100

Online storage of data is commonly referred to as:

91 / 100

1, 4, 9, 16, 25, 36, ?

92 / 100

Which AI feature allows email spam detection?

93 / 100

In Windows, the shortcut key Ctrl + Shift + N is used to:

94 / 100

The function =AVERAGE(5,10,15) returns:

95 / 100

Choose the correct analogy:
Mango : Fruit :: Spinach : ?

96 / 100

The average of 5 numbers is 30. If one number is removed, the average becomes 28. Find the removed number.

97 / 100

If 5 men can complete a task in 8 days, how many days will 10 men take?

98 / 100

If A = 1, B = 2, …, then what is the sum of D + E + F?

99 / 100

The safest password is:

100 / 100

The AutoFill feature in Excel is used for:

Your score is

Dream With Data (DwD)

Training, Research & Development Center

Company

Products

Features

Data Analyst Training

Data Science Training

Hands-on Learning

Industry-focused Programs

Software & Tools Training

© 2023 Created by Dream with Data ( DwD )