ASSESSMENT TEST
Write your answer in a word document or text document, save the file with
your own name and submit to us:
NICE Analysis:
1. What do you do in your past time? What are your current hobbies?
2. What motivates you?
3. Do you solve puzzles? How good are you in math? Give your rating from 1-10.
4. Have you worked with data or done number crunching in the past?
5. What kind of challenges have you handled? How do you handle stress & pressure in
your job?
6. Are you satisfied with the work you do in your college?
7. What is your career aspiration? What kind of work do you want to do?
8. Why do you want to come into Analytics?
9. How much time in a day can you spend on studying?
10. In 5 years down the line how do you see yourself?
11. What are your expectations from us? How do you want the internship to be conducted
(applicable for person opted Internship)? And how can we support and help you in your
upcoming career in analytics? Please elaborate.
Contact Us :- 9741267715/9945339324 Page 1
Assessment:
1. Find the next pattern for :
deb ijg nol ?
a. rsp
b. stp
c. rsq
d. stq
e. sto
2. There are five friends Sachin, Kunal, Mohit, Anuj and Rohan. Sachin is shorter than Kunal
but taller than Rohan. Mohit is the tallest. Anuj is a little shorter than Kunal and a little
taller than Sachin. If they stand in the order of their heights, who will be in the middle?
3. Two trains X and Y (80 km from each other) are running towards each other on the same
track with a speed of 40km/hr. A bird starts from the train X and travels towards train Y
with constant speed of 100km/hr. Once it reaches train Y, it turns and starts moving
toward train X. It does this till the two trains collide with each other. Find the total
distance travelled by the bird?
4. A birthday cake has to be equally divided into 8 equal pieces exactly how many
minimum number of cuts needs to be done.
5. Find the number of triangles in the given figure.
a. 8
b. 10
c. 12
Contact Us :- 9741267715/9945339324 Page 2
d. 14
6. How can you sum up the Column/Row data quickly in the Excel sheet?
7. What are the most important data formats seen in Excel?
8. Except for the …… function, a formula with a logical function shows the word “TRUE” or
“FALSE” as a result
a. IF
b. AND
c. OR
d. NOT
9. Which types of charts can excel produce?
a. Line graphs and pie charts only
b. Only line graphs
c. Bar charts, line graphs and pie charts.
d. Bar charts and line graphs only
10. Which function calculates your monthly mortgage payment?
a. PMT (payments)
b. NPER (number of periods)
c. PV (present value)
d. All of above
11. Which command is used to remove all the rows from a table?
a. Delete
b. Remove
c. Truncate
d. A & B
12. What is the full form of SQL
a. Structured Query Language
b. Structured Query List
Contact Us :- 9741267715/9945339324 Page 3
c. Simple Query Language
d. Simple Query List
13. Which Operator performs pattern matching?
a. Between operator
b. Like operator.
c. Exists Operator
d. None of these
14. In SQL, which command(s) is (are) used to change table storage characteristics?
a. ALTER table.
b. Modify Table
c. Change Table
d. All of the above
15. Which SQL Statement is correct?
a. SELECT Username AND Password FROM User
b. SELECT Username, Password FROM User
c. SELECT Username AND Password WHERE Username = ‘User1’
d. SELECT Username, Password WHERE Username = ‘User1’
16. The cat and the dog have a ___common_____________ enemy in the rat.
a. Same
b. Common
c. Mutual
d. Similar
Option c
17. What is the opposite meaning of Plausible?
a. Inplausible
b. Unplausible
c. Implausible
d. Displausible
Option a
Contact Us :- 9741267715/9945339324 Page 4
18. Which word have same meaning with Pious
a. Religious
b. Sympathetic
c. Afraid
d. Faithful
19. Anita ______reminds________ me of a girl I used to know.
a. Remembers
b. Recalls
c. Recollects
d. Reminds
20. In the sentence, a word or phrase is written in bold. For the bold part four words are
listed below. Choose the word nearest in meaning to the bold part.
The Inspector was a ______young man.
a. Smart
b. Watchful
c. Ambitious
d. Intelligent
ALL THE BEST
Contact Us :- 9741267715/9945339324 Page 5