# Foundations: Data, Data, Everywhere - Module 3 challenge

1. **In the following spreadsheet, what type of tree is in cell B4?**
    
   <table>
<thead>
<tr>
<th><em><sup>(n/a)</sup></em></th>
<th>A</th>
<th>B</th>
<th>C</th>
<th>D</th>
<th>E</th>
</tr>
</thead>
<tbody>
<tr>
<td>1</td>
<td>Ginkgo</td>
<td>Weeping willow</td>
<td>Sycamore</td>
<td>Bay laurel</td>
<td>Pistachio</td>
</tr>
<tr>
<td>2</td>
<td>Papaya</td>
<td>Maple</td>
<td>White oak</td>
<td>European ash</td>
<td>Pecan</td>
</tr>
<tr>
<td>3</td>
<td>Cedar</td>
<td>Burflower</td>
<td>Spruce</td>
<td>Redwood</td>
<td>Beech</td>
</tr>
<tr>
<td>4</td>
<td>Birch</td>
<td>Cottonwood</td>
<td>Clove</td>
<td>Cacao</td>
<td>Bristlecone</td>
</tr>
<tr>
<td>5</td>
<td>Rubber tree</td>
<td>Brazil nut</td>
<td>Walnut</td>
<td>Pine</td>
<td>Palm</td>
</tr>
</tbody>
</table>

    
    * Birch
        
    * <mark>Cottonwood</mark>
        
    * Sycamore
        
    * Bay laurel
        
2. **In the following query, what will be retrieved from the database?**
    
    ```sql
    SELECT *
    FROM Storeroom 5
    WHERE glasses = 'bifocals'
    ```
    
    * All bifocals in all storerooms
        
    * All glasses in all storerooms
        
    * <mark>All glasses in Storeroom 5 that are bifocals</mark>
        
    * All glasses in Storeroom 5
        
3. **Which of the following statements accurately describe spreadsheet attributes and observations?** Select all that apply.
    
    * <mark>An observation includes all of the attributes contained in its row.</mark>
        
    * An attribute includes all of the observations contained in its row.
        
    * <mark>Attributes are used to label spreadsheet columns.</mark>
        
    * <mark>A spreadsheet row is also referred to as an observation.</mark>
        
4. **A data professional at a social media company wants to communicate to stakeholders about which countries have the most active users. They create a data visualization that identifies 45 different countries, then shows the number of active users from each one. What type of data visualization should they create?**
    
    * Line chart
        
    * Pie chart
        
    * <mark>Bar chart</mark>
        
    * Donut chart
        
5. **When working in a spreadsheet, what is the correct syntax for a formula that adds the value in cell F9 to the value in cell G9?**
    
    * <mark>=F9+G9</mark>
        
    * F9,G9
        
    * \=F9,G9
        
    * F9+G9=
        
6. **Fill in the blank: The SQL clause** `SELECT *` **is used to retrieve all data from a particular \_\_\_\_\_.**
    
    * spreadsheet
        
    * <mark>table</mark>
        
    * database
        
    * cell
        
7. **In the following query, which clause indicates the table from which to retrieve data?**
    
    `SELECT *`
    
    * \= ‘stain’
        
    * <mark>FROM Wood</mark>
        
    * SELECT \*
        
    * WHERE finish
        
8. **Which text wrapping feature cuts off the contents of a spreadsheet cell so only the text that fits is visible?**
    
    * Wrap
        
    * Fill
        
    * Overflow
        
    * <mark>Clip</mark>
        
9. **Which of the following statements accurately describe data visualizations and visualization tools?** Select all that apply.
    
    * <mark>Spreadsheets have visualization tools that enable data professionals to create line or bar charts.</mark>
        
    * <mark>When working with the programming language R, an integrated developer environment enables the creation of data visualizations.</mark>
        
    * <mark>Tableau makes it possible to integrate data into dashboard-style visualizations.</mark>
        
    * The process used for analyzing the data should not influence the type of visualization ultimately selected.
        
10. **A data professional wants the data in column A to be in alphabetical order from A to Z. What spreadsheet feature would enable them to accomplish this task?**
    
    <table><tbody><tr><td colspan="1" rowspan="1"><p><em><sup>(n/a)</sup></em></p></td><td colspan="1" rowspan="1"><p>A</p></td><td colspan="1" rowspan="1"><p>B</p></td><td colspan="1" rowspan="1"><p>C</p></td></tr><tr><td colspan="1" rowspan="1"><p>1</p></td><td colspan="1" rowspan="1"><p>Deciani</p></td><td colspan="1" rowspan="1"><p>Lin</p></td><td colspan="1" rowspan="1"><p>33</p></td></tr><tr><td colspan="1" rowspan="1"><p>2</p></td><td colspan="1" rowspan="1"><p>Roberts</p></td><td colspan="1" rowspan="1"><p>Jeremy</p></td><td colspan="1" rowspan="1"><p>28</p></td></tr><tr><td colspan="1" rowspan="1"><p>3</p></td><td colspan="1" rowspan="1"><p>Storelli</p></td><td colspan="1" rowspan="1"><p>Hyun</p></td><td colspan="1" rowspan="1"><p>64</p></td></tr><tr><td colspan="1" rowspan="1"><p>4</p></td><td colspan="1" rowspan="1"><p>Piotrowski</p></td><td colspan="1" rowspan="1"><p>Sook</p></td><td colspan="1" rowspan="1"><p>84</p></td></tr><tr><td colspan="1" rowspan="1"><p>5</p></td><td colspan="1" rowspan="1"><p>Mondek</p></td><td colspan="1" rowspan="1"><p>Priscilla</p></td><td colspan="1" rowspan="1"><p>42</p></td></tr><tr><td colspan="1" rowspan="1"><p>6</p></td><td colspan="1" rowspan="1"><p>Lam</p></td><td colspan="1" rowspan="1"><p>April</p></td><td colspan="1" rowspan="1"><p>96</p></td></tr></tbody></table>
    
    * Formatting
        
    * Chart editor
        
    * <mark>Sort range</mark>
        
    * Dragging
        

---

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1734340706455/53f0b9ca-a3fc-484e-8f61-eab54fbd68b3.png align="center")