Lokasolution Batch 3 - Training Day 6 - Case Study

Quiz
•
Life Skills
•
University
•
Medium
Syibel Belvania
Used 1+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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()
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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()
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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()
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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()
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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()
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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()
Create a free account and access millions of resources
Similar Resources on Wayground
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22

Lesson
•
9th - 12th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
20 questions
US Constitution Quiz

Quiz
•
11th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
Discover more resources for Life Skills
10 questions
Would you rather...

Quiz
•
KG - University
20 questions
Definite and Indefinite Articles in Spanish (Avancemos)

Quiz
•
8th Grade - University
7 questions
Force and Motion

Interactive video
•
4th Grade - University
10 questions
The Constitution, the Articles, and Federalism Crash Course US History

Interactive video
•
11th Grade - University
7 questions
Figurative Language: Idioms, Similes, and Metaphors

Interactive video
•
4th Grade - University
20 questions
Levels of Measurements

Quiz
•
11th Grade - University
16 questions
Water Modeling Activity

Lesson
•
11th Grade - University
10 questions
ACT English prep

Quiz
•
9th Grade - University