MIS IJP Survey 10:00

Q1. Morocco belongs to which region ?

A. APAC

B. EMEA

C. AMER

D. Middle East

2. What is the keyboard shortcut to change pivot Source?

A. ALT + H + I + T

B. SHIFT + H + O

C. CTRL + J + T + I + D

D. ALT + T + I + D

3. What is the definition of VAR and VAD company?

A. VAD:- Value Added Distributer

B. VAR:- Value Added Reseller

4. MSP Company related with…

A. Manufacturing

B. Retail and Wholesale

C. IT

D. Banking/Finance/Insurance

5. Which Excel function is being used to find number of duplications?

A. SUMIF

B. IFERROR

C. COUNTIF

C. SUMIF

6. Which Excel function is being used to change Date and Time format?

A. Todays()

B. Date()

C. Time()

C. Text()

7. Which Key word is using to fills a cell value from its above cell?

A. CTRL + V

B. ALT + V

C. CTRL + D

C. ALT + D

8. Functions in MS Excel must begin with?

A. "()" sign

B. "= " Sign

C. "+" Sign

C. Both b & c

9. Which function in Excel is use to check whether a condition is true or not?

A. SUM

B. COUNT

C. AVERAGE

D. IF

10. Which one from below denotes a range from B1 through E5

A. =B1:E5

B. =B1$E5

C. =B1 to E5

D. =B1 - E5

11. Which one is not a function in MS Excel?

A. SUM

B. MAX

C. MIN

D. AVE

12. Map Below Industry “A” with Industry “B” as per your understandings.

Industry “A”	Industry “B”
Accounting & Accounting Services	Finance/Banking/Investment
Advertisement	Retailer/Distributor/Wholesaler (Non-Computer Related)
Aerospace & Defense	Manufacturing (Non-Computer Related)
Apparel	Construction/Engineering/Architecture
Architecture & Planning	Service Provider (Web Hosting/Data/Wireless/Online)
Internet	Media/Entertainment/Publishing

Industry “A”	Industry “B”
Accounting & Accounting Services
Advertisement
Aerospace & Defense
Apparel
Architecture & Planning
Internet

13. Bifurcate below into Account list/Suppression list

ABM

Competitors

Suppression

TAL

Exclusion List

Omit List

LAL (Look alike list)

14. What is full form of MIS?

15. Which countries would you consider if the Geo to be targeted is North America?

A. United States

B. Canada

A. Mexico

B. Costa Rica

16. If the specs states IT Security titles only, what all title out of the below would be accepted.

Risk Analyst

Director of Risk Management & Internal Audit

Data Compliance Analyst

IT Security Manager

SAP Security Analyst

Global Safety Risk and Security Manager

Cyber Security Manager

Head of Risk and Information Management

IT Security Manager

Q17. If in case the employee size 100-2500 is accepted on a campaign would we consider 1000-5000 on it?

A. Yes

B. No

Q18. Can you target restaurants if the industry required is Leisure, Travel & Tourism?

Q19. Out of the below industries for which industries revenue cannot be found?

A. Education

B. Insurance

A. Non Profit

B. Logistics

Q20. Why do you think you are fit for this position? Explain your Key skills.