Excel Nerd Notes (Exam 2)
Nerd Notes are your way to remember all the key points throughout the concept articles! When there’s a highlighted phrase (like this one), the bolded … Read More
Module 5 Explanation
PAID CONTENTGet Excel Cram Kit (Exam 2), Lifetime Access or CSE 148 Cram Kit Bundle to access.
Already purchased? Click here to log in.
Module 4 Explanation
PAID CONTENTGet Excel Cram Kit (Exam 2), Lifetime Access or CSE 148 Cram Kit Bundle to access.
Already purchased? Click here to log in.
Module 3 Explanation
PAID CONTENTGet Excel Cram Kit (Exam 2), Lifetime Access or CSE 148 Cram Kit Bundle to access.
Already purchased? Click here to log in.
Module 2 Explanation
PAID CONTENTGet Excel Cram Kit (Exam 2), Lifetime Access or CSE 148 Cram Kit Bundle to access.
Already purchased? Click here to log in.
Practice Excel Exam 2
Module 1 – Multiple Spreadsheets Open the “Excel Cram Kit (Test #2) – Multiple Sheets.xlsx” file. Select the Sigma Apple Pi sheet and then group … Read More
Module 1 Explanation
Answer Your Sigma Apple Pi, Tri Deltoids, Alpha Beta Chi, and Totals worksheets should look like so: To download the complete answer key, click the … Read More
Nested IF vs. IFS | CSE 148 – Excel Exam 2
Nested IF & IFS explained If you recall in the IF article, we created a spreadsheet for Michael Scott’s C.R.I.M.E.A.I.D. (Crime Reduces Innocence Makes Everyone … 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