18  Assessment – Spreadsheet, SQL, and Visualization Concepts

Question 1

In the following spreadsheet, what type of tree is in cell D3?

	A	B	C	D	E
1	Ginkgo	Weeping willow	Sycamore	Bay laurel	Pistachio
2	Papaya	Maple	White oak	European ash	Pecan
3	Cedar	Burflower	Spruce	Redwood	Beech
4	Birch	Cottonwood	Clove	Cacao	Bristlecone
5	Rubber tree	Brazil nut	Walnut	Pine	Palm

Options: - Sycamore
- Redwood
- Beech
- Palm

<strong>Redwood</strong>

Question 2

In the following query, what will be retrieved from the database?

SELECT * FROM riverside_elementary WHERE grade = 'kindergarten'

Options: - All kindergarteners at Riverside Elementary
- All students and grades at Riverside Elementary
- All grades at Riverside Elementary
- All kindergarteners in all elementary schools

<strong>All kindergarteners at Riverside Elementary</strong>

Question 3

Which of the following statements accurately describe spreadsheet attributes and observations?
Select all that apply.

Options: - An attribute includes all of the observations contained in its row.
- A spreadsheet row is also referred to as an observation.
- Attributes are used to label spreadsheet columns.
- An observation includes all of the attributes contained in its row.

✅ A spreadsheet row is also referred to as an <strong>observation</strong>.<br>
✅ <strong>Attributes</strong> are used to label spreadsheet columns.<br>
✅ An <strong>observation</strong> includes all of the attributes contained in its row.

Question 4

A junior data analyst at a financial company wants to communicate to stakeholders about which investment products are selected by clients the most.
They create a data visualization that identifies the 26 different products, then shows the amount of money currently invested in each one.

What type of data visualization should they create?

Options: - Bar chart
- Line chart
- Donut chart
- Pie chart

<strong>Bar chart</strong>

Question 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?

Options: - =F9,G9
- =F9+G9
- F9,G9
- F9+G9=

<code>=F9+G9</code>

Question 6

Fill in the blank:
The SQL clause SELECT * is used to retrieve all data from a particular _____.

Options: - Cell
- Database
- Table
- Spreadsheet

<strong>Table</strong>

Question 7

In the following query, which clause indicates the table from which to retrieve data?

SELECT * FROM Fiction WHERE author = 'Kingsolver'

Options: - FROM Fiction
- = ‘Kingsolver’
- WHERE author
- SELECT *

<strong>FROM Fiction</strong>

Question 8

Which text wrapping feature sets spreadsheet cells to automatically change their height to allow the text in the cell to fit?

Options: - Fill
- Wrap
- Clip
- Overflow

<strong>Wrap</strong>

Question 9

Which of the following statements accurately describe data visualizations and visualization tools?
Select all that apply.

Options: - Spreadsheets contain built-in chart and graph features.
- Tableau enables the creation of interactive dashboards for users to share.
- Choosing the most appropriate visualization is typically driven by the amount of data and the analysis process.
- The programming language R does not integrate with data visualization tools.

✅ Spreadsheets contain built-in chart and graph features.<br>
✅ Tableau enables the creation of interactive dashboards for users to share.<br>
✅ Choosing the most appropriate visualization is typically driven by the amount of data and the analysis process.

Question 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?

	A	B	C
1	Deciani	Lin	33
2	Roberts	Jeremy	28
3	Storelli	Hyun	64
4	Piotrowski	Sook	84
5	Mondek	Priscilla	42
6	Lam	April	96

Options: - Dragging
- Chart editor
- Formatting
- Sort range

<strong>Sort range</strong>

Summary

✅ Key Concepts Reviewed - Reading spreadsheets and locating cells
- Basic SQL query structure (SELECT, FROM, WHERE)
- Spreadsheet formulas (example: =F9+G9)
- Text wrapping and sorting features
- Choosing appropriate visualization types based on data and audience

---