Excel Assignments - Solve, Check, and Master
Assignment - 2
Excel Assignments - Solve, Check, and Master
0%
Completed
Assignment 1
Use of Formulas – SUM, AVERAGE, IF, COUNTIF, COUNTIF, SUMIF, AVERAGE, COUNTA, , COUNTIFS
Assignment
Reading
Assignment Solution
Reading
Assignment 2
Use of Formulas – PRODUCT, IF, COUNTA, COUNTIF & SUMIF
Assignment - 2
Reading
Assignment Solution
Reading
Assignment 3
Use of Formulas – SUM, AVERAGE, NESTED IF, COUNTA, COUNTIF, SUMIF & VLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 4
Use of Formulas – SUM, Nested IF, COUNTA, COUNTIF, SUMIF & VLOOKUP
assignment
Reading
Assignment Solution
Reading
Assignment 5
Use of Formulas – SUM, IF, COUNTA, COUNTIF, SUMIF, VLOOKUP & LOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 6
Use of COUNTA, COUNTIF, SUMIF, HLOOKUP & Conditional Formatting
Assignment
Reading
Assignment Solution
Reading
Assignment 7
Use of Formulas – COUNTA, DAY, MONTH, YEAR, COUNTIF, SUMIF, IF & DATEDIF
Assignment
Reading
Assignment Solution
Reading
Assignment 8
Use of Formulas – SUM, AVERAGE, COUNTA, COUNTIF, SUMIF & Nested IF
Assignment
Reading
Assignment Solution
Reading
Assignment 9
LOOKUP Function Syntax
Assignment
Reading
Assignment Solution
Reading
Assignment 10
Use of Formulas – COUNTA, COUNTIF, SUMIF & VLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 11
Use of Formulas – MATCH & VLOOKUP with MATCH
Assignment
Reading
Assignment Solution
Reading
Assignment 12
Create Pivot Table Using Data
Assignment
Reading
Assignment Solution
Reading
Assignment 13
Use of Formulas – COUNTIF, COUNTIFS & SUMIFS
Assignment
Reading
Assignment Solution
Reading
Assignment 14
Create Pivot Table Using Data – Separate Fruits and Vegetables
Assignment
Reading
Assignment Solution
Reading
Assignment 15
Use of Formulas – COUNTIF, COUNTIFS, SUMIFS & VLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 16
Use of Formula – VLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 17
Use of Formula – HLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 18
Use of Formula – HLOOKUP
Assignment
Reading
Assignment Solution
Reading
Assignment 19
Use of Formula – INDEX with MATCH
Assignment
Reading
Assignment Solution
Reading
More
Announcements
Course Info
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%
Go Back to Course
Complete Anyway