If you would like spot check the values for a data field- where can you verify this data? 1) Field search tool in excel 2) Import data wizard 3) FLDS, go 4) All of the above 5) 2 and 3 only What is the lowest tick size that you can select in the historical intraday bars wizard? 1) 1 second 2) 1 minute 3) 30 seconds 4) 2 minutes If one knows the ticker for an equity, the syntax would be: 1) Security ticker, equity, go 2) Equity, security ticker, go 3) Security ticker, go 4) Security ticker, help Where can I view all the optional parameters available for the formulas? 1) Bloomberg drop down, help file 2) Function builder 3) Flds, go 4) All of the above 5) 1 and 2 only What is the shortcut to locating a field within excel? 1) Field range 2) Field finder 3) Field search 4) Enter any keyword of your choice in the cell What is the optional parameter to consolidate all data into one cell when using an =bds formula to bring in bulk data? 1. Direction=h 2. Per=m 3. Aggregate=y 4. None of the above Launchpad allows a user to customize their desktop with any security that has a ticker on Bloomberg
1. True 2. False Where can I find a cheatsheet on Bloomberg? 1. Chea, go 2. Bu, go, 13, go 3. Docs sheatsheet, go 4. All of the above =BDS (“goog us equity”, Px Last”) is an example of what kind of formula?
1. Historical formula 2. Cell reference formula 3. Bulk formula 4. Literal reference formula A white box around a news story on top, go indicates that the s tory was 1. Added to top in the last 5 minutes 2. Added to top in the last 15 minutes 3. Has already been read 4. A Bloomberg exclusive news story Which Bloomberg excel tool would you select to download historical weekly data on a rolling basis of a security? 1. Import data wizard, market, reference, analytical, data sets 2. Import data wizard, historical end of day 3. Import data wizard, historical intraday ticks 4. Import data wizard, historical intraday bars What is the syntax for getting current data into excel without using the Bloomberg import data wizard? 1. =bdp (security, field)] 2. =bdh (security, field, start date) 3. =bds security, field 4. =bdh security field The logic that Bloomberg uses to organize our functionality is that of a menu driven system where functions are located on menus such as the yellow market sector menus on the keyboard 1. True 2. False BDP stands for:
1. Bloomberg data pair 2. Bloomberg data point 3. None of the above Which one of the following formulas requires at least a start date as a mandatory parameter? 1. BDH 2. BDS 3. BEQS 4. BDP How does one acces the Bloomberg help desk for any questions one may have regarding Bloomberg 24 hours a day 7 days a week? 1. Cancel 2. Help help 3. Menu 4. Ib Which key will allow you to go back from a function and see related functionality? 1. Menu 2. Help 3. Go 4. Govt Bloomberg data can be downloaded via api and/or viewed on machines that do not have Bloomberg installed? 1. True 2. False In TOP GO, you have the ability to customize the screen to display market moving news for a selected topic. If a story has a b located to the left of the headline, what does that tell us about this story? 1. Specific to bond news 2. Story broke in the last 15 minuets 3. The story is a Bloomberg exclusive story 4. None of the above How can one look up the ticker for Microsoft? 1. Microsoft, help, 10, go from this menu 2. Microsoft go 3. Typing Microsoft in command line if autocomplete is enabled 4. Microsoft help 1 go from this menu
5. Answers 1 and 3 What function of Bloomberg provides a list of the primary menus that organize the data and functions on Bloomberg? 1. Govt, go 2. Corp, go 3. Main, go 4. Equity, go If I wanted to pull the real time volume of s&p 500 index- how will I write the formula? 1. Bdp(spx index, px_volume”) 2. Bdp…,volum 3. Bds…volume 4. Bds…pxvolume To get a user guide while on a function such as most,go one would hit which key? 1. Cancel 2. Go 3. Menu 4. Help Which of the wizard could one use to mimic the data found by typing ibm us equity qr, go screen on Bloomberg application 1. Market, reference, analytical data sets 2. Historical end of day 3. Historical intraday ticks 4. Bars Where can you find a guide on Bloomberg to using the api? 1. Bloomberg drop down in excel, help file 2. Dapi, go 3. All of the above Dvd_hist_all is an example of what kind of field? 1. Current 2. Historical 3. Bulk 4. Intraday
In addition to the field search tool within excel, what is the function on the Bloomberg application what will allow you to find data fields on a per security basis? 1. Mbbg, go 2. Flds, go 3. Dapi,go 4. All of the above Where can you get help if you have questions about using the api? 1. Dapi, go 2. By hitting helpk,help on your keyboard 3. Bloomberg drop down, help file 4. All of the above In order to start Launchpad, which command do I use on Bloomberg? 1. Blp, go 2. Nw, go 3. W, go 4. Prt, go
