U2 Data Analysis and Visualizations Quiz

What are the individual boxes in a spreadsheet that hold data?

• Cells

• Rows

• Columns

• Ranges

What are the vertical lines of boxes in a spreadsheet that hold data?

• Columns

• Rows

• Cells

• Ranges

What are the horizontal lines of boxes in a spreadsheet that hold data?

• Rows

• Columns

• Cells

• Ranges

Which option would be used to present data in visual form in a report or slide show?

• Chart

• Sidebar

• Heading

• Cell

When would someone most likely use the data in a spreadsheet to create a chart?

• When preparing a visual display for a presentation

• When organizing data in rows and columns

• When determining which data is the most useful

• When certain data needs to be replaced or removed

Charts are most useful for which task?

• Creating visual displays of data for presentations

• Organizing data into a new spreadsheet

• Removing data that is not useful from a spreadsheet

• Creating more columns in a spreadsheet

A formula in cell D1 of this spreadsheet gives a result of 10. Which formula was most likely entered in cell D1?

• =C2+C3

• =B2-B3

• =A2/C2

• =A1*A3

A formula in cell D1 of this spreadsheet gives a result of 8. Which formula was most likely entered in cell D1?

• =A1*A3

• =C2+C3

• =B2-B3

• =A2/C2

A formula in cell D1 of this spreadsheet gives a result of 3. Which formula was most likely entered in cell D1?

• =A2/C2

• =A1*A3

• =C2+C3

• =B2-B3

Why might you use this kind of graph?

• To compare data from different groups or categories

• To show parts of a whole

• To show the relationship between sets of data

• To show the relationship between two variables