Excel Formulas: Interactive: Formula Flashcards

Lesson 10: Interactive: Formula Flashcards

/en/excelformulas/practice-reading-formulas/content/

Interactive: Formula Flashcards

Let's briefly review what we have learned in the past few lessons. Then, you'll answer a few questions to test your knowledge.

Simple Formulas

Simple formulas combine relative cell references and mathematical operators to perform helpful calculations.

Let's practice!

Question 1 of 1

Select the formula that will subtract the inventory costs from the monthly budget.

You answered out of questions correctly. Click the Retry button if you'd like to take the quiz again!

Complex Formulas

Like simple formulas, complex formulas combine cell references and mathematical operators. However, in complex formulas, we usually perform more than one mathematical operation. The order of operations helps us to determine which operation to perform first.

Let's practice!

Question 1 of 1

Which formula will subtract the inventory costs from the annual budget and then divide by 12?

You answered out of questions correctly. Click the Retry button if you'd like to take the quiz again!

Functions

A function is a predefined formula that performs calculations using specific values in a particular order. The first step, however, is determining which function to use. To review the different types of functions, you can check out our Functions lesson.

Let's practice!

Question 1 of 1

Which formula would find the fastest time for this running log?

You answered out of questions correctly. Click the Retry button if you'd like to take the quiz again!

The second step to using a function is determining the correct arguments. Arguments determine which cells are analyzed by a function.

Let's practice!

Question 1 of 1

In this example, which formula would find the average time for a 3-mile run?

You answered out of questions correctly. Click the Retry button if you'd like to take the quiz again!

Now that you know the basics of formulas and functions, you're ready to learn some more advanced Excel formulas!

/en/excelformulas/overbudget-items/content/

chatsimple