analyze data to answer questions weekly challenge 2
1. An analyst notes that the “160” in cell A9 is formatted as text, but it should be Australian dollars. What spreadsheet tool can help them select the right format?
- Format as Dollar
- EXCHANGE
- CURRENCY
- Format as Currency
2. You are creating a spreadsheet to help you with your job search. Every time you find an interesting job, you add it to the spreadsheet. Then, you want to indicate two possible options: Need to Apply or Applied. What spreadsheet tool will save you time by enabling you to create a dropdown list with Need to Apply and Applied as the possible options?
- Pop-up menus
- Data validation
- Find
- Conditional formatting
3. You are using a spreadsheet to keep track of your newspaper subscriptions. You add color to indicate if a subscription is current or has expired. Which spreadsheet tool changes how cells appear when values meet each expiration date?
- Data validation
- CONVERT
- Conditional formatting
- Add color
4. You are analyzing data about the capitals of different countries. In your SQL database, you have one column with the names of the countries and another column with the names of the capitals. What function can you use in your query to combine the countries and capitals into a new column?
- GROUP
- CONCAT
- JOIN
- COMBINE
5. You are querying a database of museums to determine which ones will have a sculpture exhibit this year. For your project, you only need the first 50 records. What clause should you add to the following SQL query?
SELECT museums
FROM museum_table
WHERE exhibit = “sculpture”
- LIMIT 50
- LIMIT,50
- LIMIT = 50
- LIMIT_50
6. A data analyst is working with a spreadsheet that has very long text strings. Rather than counting the characters themselves to determine the number of characters they contain, what tool can they use?
- The MID function
- The CHAR function
- The LEN function
- The COUNT function
7. Spreadsheet cell L6 contains the text string “Function”. To return the substring “Fun”, what is the correct syntax?
- =RIGHT(L6, 3)
- =LEFT(3,L6)
- =LEFT(L6, 3)
- =RIGHT(3,L6)
8. When working with spreadsheets, data analysts can use the WHERE function to locate specific characters in a string.
- True
- False
Shuffle Q/A 1
9. An analyst has financial data that is formatted as Canadian dollars, but it should be formatted as U.S. dollars. What spreadsheet tool can help them select the right format?
- Format as Dollars
- Format as Number
- Format as Currency
- Format as Money
10. You are preparing a project tracker spreadsheet. Next to each project task, you need to add the name of the team member responsible. What spreadsheet tool will save you time by enabling you to create a drop-down list with team members’ names as the possible options?
- Find
- Conditional formatting
- Pop-up menus
- Data validation
