# Excel Exam 2

## Nested IF vs. IFS | CSE 148 – Excel Exam 2

Nested IF & IFS explained If you recall in the IF | Excel in 30 Minutes (Test #1) article, we created a spreadsheet for Michael … Read More

## COUNTIF, SUMIF, AVERAGEIF | CSE 148 – Excel Exam 2

COUNTIF, SUMIF, AVERAGEIF explained It’s the annual Ohio State vs. Michigan college football game. One of the biggest rivalries in the nation. Your family is … Read More

## IFERROR | CSE 148 – Excel Exam 2

IFERROR explained Imagine you run a tutoring service at your local college for math. Considering that your business has been growing recently, you have been … Read More

## HLOOKUP | CSE 148 – Excel Exam 2

HLOOKUP explained Remember our Valentine’s Day example in VLOOKUP | Excel in 30 Minutes (Test #1)? If not, here you go: “Let’s say Valentine’s Day … Read More

## PivotTables | CSE 148 – Excel Exam 2

Before starting this article, I’m going to level with you… PivotTables having a LOT of working parts. Therefore, they can get pretty confusing. However, they … Read More

## Excel tables | CSE 148 – Excel Exam 2

Excel tables explained It’s summertime, and you’ve decided you want this next year to be killer. Time to kickstart your Party Planning Committee! With you … Read More

## AND vs. OR | CSE 148 – Excel Exam 2

AND vs. OR explained While AND & OR are relatively self-explanatory, here’s a short story to exemplify their functionality. Imagine you’re back in middle school, … Read More

## 3D Cell References | CSE 148 – Excel Exam 2

3D Cell References explained “NOOOOOO!” you scream, as you sit up in bed abruptly. You wake up from your terrifying dream, dripping in sweat. To … Read More

## SUMPRODUCT | CSE 148 – Excel Exam 2

SUMPRODUCT explained Say you’re going to a concert with your 3 best friends: Drake, Josh, and Megan. Since your hefty paycheck just came in, you … Read More