Lokasolution Batch 3 - Training Day 6 - Case Study

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()