KEMBAR78
Nice Analysis | PDF | Microsoft Excel
0% found this document useful (0 votes)
8 views5 pages

Nice Analysis

The document outlines an assessment test consisting of personal questions and analytical tasks. It includes sections on personal interests, motivations, problem-solving abilities, and various mathematical and analytical challenges. Additionally, it covers practical Excel-related questions and basic SQL knowledge, aimed at evaluating the candidate's suitability for a role in analytics.

Uploaded by

Madhu Reddy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
8 views5 pages

Nice Analysis

The document outlines an assessment test consisting of personal questions and analytical tasks. It includes sections on personal interests, motivations, problem-solving abilities, and various mathematical and analytical challenges. Additionally, it covers practical Excel-related questions and basic SQL knowledge, aimed at evaluating the candidate's suitability for a role in analytics.

Uploaded by

Madhu Reddy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

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

You might also like