1. Getting to know Excel

2 Topics | 1 Quiz
2. Working with Cells

3 Topics | 1 Quiz
3. Modifying Columns, Rows, and Cells

2 Topics | 1 Quiz
4. Formatting Cell

5 Topics | 1 Quiz
5. Understanding Number format in Excel

5 Topics | 1 Quiz
6. Using Find & Replace

2 Topics | 1 Quiz
7. Formulas and Functions

6 Topics | 1 Quiz
To calculate the sum of the products of corresponding numbers in one or more ranges, use Excel’s powerful SUMPRODUCT function.

Explanation: the SUMPRODUCT function performs this calculation: (2 * 1000) + (4 * 250) + (4 * 100) + (2 * 50) = 3500. The SUMPRODUCT function is an extremely versatile function and can produce the same result as many built-in functions in Excel and even array formulas

Microsoft Learning: Free Certificates Await

Health and Safety Free Online Certificate Course

Study a Online Course for Free

Free Computer Literacy Course with Certificate

Access to Open Educational Resources

The Role of Technology in Education

The Importance of Learning Microsoft Office