Excel Functions Quiz - JC1&2

What is the purpose of using advanced functions in Excel?

• To add formatting styles

• To perform simple addition

• To automate complex calculations

• To save the worksheet

Which of the following is an example of a basic Excel function?

• =SUMIF(A1:A10, ">10", B1:B10)

• =XLOOKUP(100, A1:A10, B1:B10)

• =A1 + B1

• =HLOOKUP(2, A1:E5, 3, FALSE)

Which function would you use to return a value from a vertical table based on a matching ID?

• HLOOKUP

• SUMIF

• VLOOKUP

• CONCATENATE

What does a relative reference do when copied across cells?

• Refers to fixed values

• Automatically adjusts based on position

• Locks the column only

• Locks the row only

In the formula =B2$D$1, what does $D$1 represent?

• Mixed reference

• Relative reference

• Named range

• Absolute reference

Which of the following is a benefit of using named ranges?

• Slower calculation

• Requires macros

• Easier to read formulas

• Changes values automatically

What symbol is used to create an absolute cell reference?

• @

• $

• &

• #

The formula =$A2*B$1 uses what type of references?

• Mixed references

• Absolute references

• Relative references

• Static references

What would be the result if a VLOOKUP does not find the lookup value?

• #REF!

• It returns the last row

• "Not Found"

• #N/A

When is it most appropriate to use HLOOKUP instead of VLOOKUP?

• When data is arranged horizontally

• When column headers are not labeled

• For sorting data

• When working with time series