Microsoft Excel 2021365 - Beginner to Advanced - Exercise 09 -  VLOOKUP formula

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 09 - VLOOKUP formula

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Wayground Content

FREE Resource

This video tutorial covers the use of VLOOKUP and logical functions in Excel to manage and analyze data. It includes exercises on formatting data as tables, using VLOOKUP to find test scores and grades, applying logical functions to select venues, and using text functions for data cleaning. The tutorial provides practical examples and step-by-step guidance to ensure understanding and application of these functions.

Read more

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary purpose of using VLOOKUP in the Test Scores worksheet?

To create a data validation list

To calculate the average score of students

To format the data as a table

To retrieve test scores for specific subjects

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you test if the VLOOKUP formula is working correctly in the Test Scores worksheet?

By changing the table name

By selecting different students from a drop-down list

By modifying the formula to include more subjects

By adding more columns to the table

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main advantage of using named ranges in Excel formulas?

They make formulas easier to read and manage

They automatically update data

They allow for conditional formatting

They increase the speed of calculations

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the Student Grades worksheet, what should the VLOOKUP formula return if an error occurs?

The text 'Error'

The text 'Fail'

The average score

The highest score

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What logical function is used to determine if a venue can accommodate more than 400 people?

IF

OR

NOT

AND

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is combined with IF to check multiple conditions for venue selection?

OR

AND

NOT

XOR

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of using the TRIM function in the customer data table?

To replace text with a specific value

To find the length of the text

To remove extra spaces from text

To convert text to uppercase

Create a free account and access millions of resources

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?