Lokasolution Batch 3 - Training Day 6 - Case Study

Lokasolution Batch 3 - Training Day 6 - Case Study

University

10 Qs

quiz-placeholder

Similar activities

Brakes, Handling Controls and Safety Systems

Brakes, Handling Controls and Safety Systems

University

15 Qs

Business Decisions

Business Decisions

University

7 Qs

Week 3  sleep management

Week 3 sleep management

University

5 Qs

IPv4 Troubleshooting and ACLs

IPv4 Troubleshooting and ACLs

University

12 Qs

Vital Vitamins: Water-Soluble Wonders

Vital Vitamins: Water-Soluble Wonders

10th Grade - University

11 Qs

AgEd Structure

AgEd Structure

University

10 Qs

Legal or Illegal Question?

Legal or Illegal Question?

University

15 Qs

Nutrition  Protein and amino acids

Nutrition Protein and amino acids

University

15 Qs

Lokasolution Batch 3 - Training Day 6 - Case Study

Lokasolution Batch 3 - Training Day 6 - Case Study

Assessment

Quiz

Life Skills

University

Practice Problem

Medium

Created by

Syibel Belvania

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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

Media Image

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

Media Image

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

Media Image

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?