Skip to content

MS Excel (Part 2)

AND vs. OR – Practice!

What if you have multiple conditions?

Advanced IFs – Practice!

HLOOKUP – Practice!

Why use Excel Tables?

Create an Excel Table

Select a design

Insert Totals Rows

Excel Tables – Practice!

Why use PivotTables?

Create a PivotTable

Assign rows / columns

Specify values for rows / columns + Slicers

Assign sub-rows / sub-columns

Top / Bottom results

Filter for records that meet condition

Place “all other values” in a different column

Handling no data in row / column

Order rows / columns

Percentages for rows / columns

Group records in range of values

Calculated field

PivotTables – Practice!

COUNTIF, SUMIF, AVERAGEIF

What do COUNTIF, SUMIF, & AVERAGEIF do?

COUNTIF, SUMIF, AVERAGEIF – Practice!

SUMPRODUCT – Practice!

3D Cell References

3D Cell References

3D Cell References – Practice!

Practice Module 1 – Excel (Part 2)

Practice Module 2 – Excel (Part 2)

Practice Module 3 – Excel (Part 2)

Practice Module 4 – Excel (Part 2)

Practice Module 5 – Excel (Part 2)

Previous Concept

HLOOKUP – Practice!

You are currently viewing a sample of the Cram Kit. Click here to unlock everything.

MS Excel (Part 2)
HLOOKUP
HLOOKUP – Practice!

Time limit: 0

Practice Exercise Summary

0 of 1 Questions completed

Questions:

Information

You have already completed the practice exercise before. Hence you can not start it again.

Practice Exercise is loading…

You must sign in or sign up to start the practice exercise.

You must first complete the following:

Results

Practice Exercise complete. Results are being recorded.

Results

0 of 1 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

Review / Skip
Answered
Correct
Incorrect

Question 1 of 1

1. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.

Let’s say you’re a cashier at your local grocery store. In this role, you need to memorize the codes on all the stickers and the items they represent.

Given the following spreadsheet, determine how to set up a lookup function (either VLOOKUP or HLOOKUP) in cell B5 to help you practice memorizing the codes.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect

Activate AutoScroll

Login

Accessing this cram kit requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?