MIS IJP

A. APAC

B. EMEA

C. AMER

D. Middle East

Q2. 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

Q3. What do the below mentioned terms stand for?

A. VAD

B. VAR

Q4. MSP Company related with…

A. Manufacturing

B. Retail and Wholesale

C. IT

D. Banking/Finance/Insurance

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

A. SUMIF

B. IFERROR

C. COUNTIF

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

A. Todays()

B. Date()

C. Time()

D. Text()

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

A. CTRL + V

B. ALT + V

C. CTRL + D

D. ALT + D

Q8. Functions in MS Excel must begin with?

A. "()" sign

B. "= " Sign

C. "+" Sign

D. Both b & c

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

A. SUM

B. COUNT

C. AVERAGE

D. IF

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

A. =B1:E5

B. =B1$E5

C. =B1 to E5

D. =B1 - E5

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

A. SUM

B. MAX

C. MIN

D. AVE

Q12. 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

Answer:

Accounting & Accounting Services
Advertisement
Aerospace & Defense
Apparel
Architecture & Planning
Internet

Q13. Bifurcate below into Account list/Suppression list

A. ABM

B. Competitors

C. Suppression

D. TAL

E. Exclusion List

F. Omit List

G. LAL (Look alike list)

Q14. What is full form of MIS?

Q15. Which countries would you consider if the Geo to be targeted is North America? (Select all that apply)

A. United States

B. Canada

C. Mexico

D. Costa Rica

Q16. If the specs states IT Security titles only, what all title out of the below would be accepted. (Select all that apply)

A. Risk Analyst

B. Director of Risk Management & Internal Audit

C. Data Compliance Analyst

D. IT Security Manager

E. SAP Security Analyst

F. Global Safety Risk and Security Manager

G. Cyber Security Manager

H. Head of Risk and Information Management

I. IT Security Manager

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

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? (Select all that apply)

A. Education

B. Insurance

C. Non Profit

D. Logistics