Excel Formulas Quiz

What is the function that returns the value of pi in Excel?

• MATCH

• COUNTIF

• SUM

• PI

Which reference style in Excel uses letters for columns and numbers for rows?

• R1C1 reference style

• Mixed reference style

• A1 reference style

• 3-D reference style

What does an absolute cell reference in Excel always refer to?

• A constant value

• A range of cells

• A relative position

• A specific location

Which Excel function is used to calculate the average value for a range of cells?

• SUM

• AVERAGE

• COUNT

• MAX

What happens to a 3-D reference in Excel when you insert or copy sheets between the endpoints?

• Values from added sheets are included in calculations

• The reference is deleted

• Values from added sheets are excluded from calculations

• The reference remains unchanged

Which operator in Excel raises a number to a power?

• - (minus)

• + (plus)

• * (asterisk)

• ^ (caret)

What is the purpose of using mixed references in Excel formulas?

• To exclude certain cells from calculations

• To automatically adjust when copied or filled

• To calculate the total sales

• To always refer to a specific location

Which Excel function is an improved version of VLOOKUP that works in any direction?

• MATCH

• COUNTIF

• SUMIF

• XLOOKUP

What is the default reference style in Excel that uses letters for columns and numbers for rows?

• Mixed reference style

• 3-D reference style

• R1C1 reference style

• A1 reference style

Which Excel function is used to add all the values contained in a range of cells?

• MAX

• SUM

• COUNT

• AVERAGE