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

Excel Tables – Practice!

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

MS Excel (Part 2)
Excel Tables
Excel Tables – 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.

Convert the following data into an Excel table with a blue style of your choosing. Then, sort in descending order by “Abbreviation” and remove any hybrid courses from consideration.
- 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?