Excel Functions Quiz

What Excel function is primarily used to calculate the total quantity of specific items (like green items) in stock?

• COUNTIF

• SUMIF

• AVERAGEIF

• MAXIF

When using the SUMIF function, which of the following is NOT a required argument?

• Range

• Criteria

• Sum Range

• Average

If you want to count the total number of medium-sized red items that are reordered, which function would you use?

• SUMIF

• COUNTIF

• SUMIFS

• AVERAGEIF

In the context of the video, what is the significance of using dynamic conditions in Excel formulas?

Why is it important to fix cells (using F4) when copying and pasting formulas in Excel?

• To ensure the formula remains unchanged.

• To prevent errors from changing cell references.

• To make the formula easier to read.

• To allow for dynamic calculations.

How can using filters in Excel enhance the analysis of inventory data?

• By reducing the amount of data displayed for easier viewing.

• By changing the data itself.

• By automatically generating reports.

• By eliminating the need for formulas.

What is the main advantage of linking conditions in separate cells for a formula?

• It allows for more complex calculations.

• It simplifies the formula and makes it easier to adjust conditions.

• It eliminates the need for any criteria.

• It automatically generates new data.

After checking the results of your SUMIF formula against manual calculations, what should you do if they do not match?

• Ignore the discrepancy; the formula is likely correct.

• Review the formula and criteria used for errors.

• Change the data to match the formula.

• Delete the formula and start over.