NEW
Font size
WorksheetsLokasolution Batch 3 - Training Day 6 - Case Study
Total questions: 10
Worksheet time: 5mins
You need to summarize the average commute times from the data provided. Which spreadsheet function should you use to calculate the average commute time for all transportation modes?
=VLOOKUP()
=SUM()
=AVERAGE()
=HLOOKUP()
Refer to the bar chart above showing average commute times for different transportation modes. Which mode has the longest commute time, and what function would you use in a spreadsheet to find this value?
Buses, =MAX()
Trains, =MIN()
Cars, =AVERAGE()
Bicycles, =SUM()
Given a dataset of property values and proximity to parks, which spreadsheet function would you use to predict property values based on proximity?
=VLOOKUP()
=RSQ()
=XLOOKUP()
=SUM()
You are provided with a dataset showing proximity to parks and property values. Using a spreadsheet, which function or tool would you use to create a summary table showing average property values for different proximity ranges? (dataset: bit.ly/DatasetCaseStudy6)
=VLOOKUP()
=XLOOKUP()
Pivot Table
=RSQ()
Which spreadsheet function allows you to search for a value in the first column of a table and return a value in the same row from another column?
=HLOOKUP()
=VLOOKUP()
=XLOOKUP()
=SUM()
Given the pie chart showing land use distribution in an urban area, which spreadsheet tool would help you reorganize this data to compare specific categories easily?
Pivot Table
SUM function
Conditional Formatting
VLOOKUP
You have a large dataset of urban land use categories and their areas. To quickly find the total area for a specific category, which spreadsheet function would be most efficient?
=VLOOKUP()
=XLOOKUP()
=SUMIF()
=HLOOKUP()
Analyze the scatter plot below showing the relationship between proximity to parks and property values. To determine the strength of this relationship in a spreadsheet, which function would you use?
=XLOOKUP()
=RSQ()
=SUM()
=HLOOKUP()
You need to create a report showing the percentage of each land use category in an urban area. What would be the best tool to summarize this data visually in a spreadsheet?
Pivot Table
Pie Chart
VLOOKUP
SUM function
Refer to the pie chart showing land use distribution. If you wanted to compare the sizes of two categories directly, which function or tool would you use?
=VLOOKUP()
Conditional Formatting
Pivot Table
=HLOOKUP()
