Bloomberg Certification - Core Exam Questions and Answers, Exams of Business Economics

Download Bloomberg Certification - Core Exam Questions and Answers and more Exams Business Economics in PDF only on Docsity! Bloomberg Certification - Core Exam Questions with correct Answers Which Bloomberg Excel tool, wishing the Real-TIme/Historical wizard, would you select to download historical weekly close data on a rolling basis of a security - ANSWER- Historical End of Day What function allows you to create custom news pages for the topics, regions and markets that are important to you? - ANSWER-MYN <Go> Where can you find important contact information and support resources for Bloomberg in one place? - ANSWER-<Cancel> key While on a function like WEI <Go>, how can you get a user guide for that particular function? - ANSWER-<Help> key With Bloomberg in Excel, you have the ability to customize the output of some BDP or BDS formulas. For example, you can display the market cap for BMW is USD rather than EUR. These are called overrides. How can you see the possible overrides for a field? - ANSWER-On FLDS<GO>, Click a data field to see the possible overrides. A quick way to create formulas for Excel is by using FLDS<GO>. Find the field "Last Price" in FLDS for IBM. What is the quickest way to get this value into Excel from FLDS so that the price of IBM updates automatically? - ANSWER-Click anywhere in the row LAST_PRICE, then drag this into your Excel file. If you want news based on the major market sectors you follow, what function can you use? - ANSWER-STNI <GO> What are the two types of Bloomberg functions? - ANSWER-Non-Security functions and security-specific functions If you want to explore all the information, functions, and resources available on the topic of "risk" on the Bloomberg, what would you do? - ANSWER-In the command line, type RISK and press <Help> If you want to analyze the historical performance of a security in a chart, what is the correct order you should use in the command line? - ANSWER- Ticker <Asset Class> Function <GO> What is the purpose of the command line? - ANSWER-All of the above. How can you access Bloomberg's live 24-hour Help Desk? - ANSWER-Press the <Help> key twice Which function provides a library of pre-built spreadsheet templates that allow you to perform custom analysis on Bloomberg data in Excel? - ANSWER-XLTP <Go> Which key will allow you to see related functionality when you are on a function? - ANSWER-<Menu> key What Bloomberg Excel tool would you use to explore the widest range of data about a particular security? - ANSWER-Data Navigation How can you switch between different Bloomberg windows so that you can multi-task more effectively? - ANSWER-<Panel> key