Analyst Questions


Q:

An Excel Workbook is a collection of

A) Charts B) Worksheets
C) Both A & B D) None of the above
 
Answer & Explanation Answer: C) Both A & B

Explanation:

An M.S Excel Workbook is a collection of both Worksheets and Charts.

 

An_Excel_Workbook_is_a_collection_of1558067892.jpg image

Report Error

View Answer Report Error Discuss

29 12521
Q:

Formatting a cell in currency you can specify

A) Percentage symbol B) Currency symbol
C) Decimal places D) Both B & C
 
Answer & Explanation Answer: B) Currency symbol

Explanation:

Formatting a cell in currency you can specify Currency symbol.

Report Error

View Answer Report Error Discuss

Filed Under: Computer
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

10 12459
Q:

Which of the following is a comparison operator in SQL?

A) = B) <>
C) ` D) /
 
Answer & Explanation Answer: A) =

Explanation:

The comparison operator that is used in SQL is '='. Comparison operators test whether two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

3 12440
Q:

6 boys and 8 girls can do job in 10 days , 26 boys & 48 women do work in 2 days. Find time taken by 15 boys and 20 girls to do same work ?

A) 2 days B) 3 days
C) 4 days D) 5 days
 
Answer & Explanation Answer: C) 4 days

Explanation:

One day work of 6 boys and 8 girls is given as 6b + 8g = 1/10 -------->(I)

 


One day work of 26 boys and 48 women is given as 26b + 48w = 1/2 -------->(II)

 

Divide both sides by 2 in (I) and then multiply both sides by 5

Now we get, 15b + 20g = 1/4.

Therefore, 15 boys and 20 girls can do the same work in 4 days.

Report Error

View Answer Report Error Discuss

Filed Under: Time and Work
Exam Prep: GATE , CAT , Bank Exams , AIEEE
Job Role: Bank PO , Bank Clerk , Analyst

13 12366
Q:

Choose Odd one out of the options ?

A) PSRQ B) SVUT
C) MNPO D) KNML
 
Answer & Explanation Answer: C) MNPO

Explanation:

PSRQ --> {16, 19, 18, 17} - next 3 alphabets of "P" is written in reverse order
SVUT --> {19, 22, 21, 20} - next 3 alphabets of "S" is written in reverse order

MNPO --> {13, 14, 16, 15}


KNML --> {11, 14, 13, 12} - next 3 alphabets of "K" is written in reverse order

Except "MNPO", others are not in consecutive order.

Report Error

View Answer Report Error Discuss

Filed Under: Logical Sequence of Words
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE , TOEFL
Job Role: Analyst , Bank Clerk , Bank PO

51 12338
Q:

Main street high school has 10 members on its football team and 14 members on its science club. 5 members at the school belong to both the football and science teams. How many students belong to only science club team or football team?

A) 9 B) 14
C) 24 D) 21
 
Answer & Explanation Answer: A) 9

Explanation:

Given that,

Members in football team = n(f) = 10

Members in science club = n(s) = 14

Members in both football team and science club = n(f ^ s) = 5

 

Then, Members in only football team = n(F) = 10 - 5 = 5

Members in only science team = n(S) = 14 - 5 = 9

football_science_teams1533013879.jpg image

 

Hence, members in only football or science team = n(FUS) = n(F) + n(S) - n(f^s) 

= 9 + 5 - 5

= 9.

 

Hence, many students belong to only science club team or football team = 9.

Report Error

View Answer Report Error Discuss

Filed Under: Logical Venn Diagram
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO

62 12319
Q:

There are six persons 1, 2, 3, 4, 5 and 6. 3 is the sister of 6. 2 is the brother of 5's husband. 4 is the father of 1 and grandfather of 6. There are two fathers, three brothers and a mother in the group. Which of the following is a group of brothers ? 

A) 1, 2, 3 B) 3, 2, 6
C) 1, 2, 4 D) 1, 2, 6
 
Answer & Explanation Answer: D) 1, 2, 6

Explanation:

4 is father of 1 and grandfather of 6. So, 1 is father of 6. Thus, 4 and 1 are the two fathers.
3 is the sister of 6. So, 3 is the daughter of 1. Since there is only one mother, it is evident that 5 is the wife of 1 and hence the mother of  3 and 6. So, 2 is brother of 1. There are three brothers. So, 6 is the brother of 3. Hence, 2 and 1 are brothers. 6 is the brother of 3. So, three brothers are 1, 2, 6.

Report Error

View Answer Report Error Discuss

Filed Under: Blood Relations
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE
Job Role: Analyst , Bank Clerk , Bank PO

3 12305
Q:

First Bank to introduce Credit Card in India

A) HSBC Bank B) ICICI Bank
C) State Bank of India D) Central Bank of India
 
Answer & Explanation Answer: D) Central Bank of India

Explanation:

 

        • First Bank to introduce Credit Card in India - Central Bank of India
        • First Bank to introduce ATM  -  HSBC, 1987
        • First Bank to introduce Internet Banking - ICICI Bank

 

 

Report Error

View Answer Report Error Discuss

21 12285