Spreadsheet - Basic Functions

Which of the following is an example of a more complex function?

• Finding the square root

• Adding two numbers

• Multiplying two numbers

• Rounding up and rounding down

What is an example of a nested IF function?

• IFOR

• IFAND

• IFERROR

• IFNA

Which function is used for vertical lookup?

• VLOOKUP

• HLOOKUP

• INDEX

• MATCH

What does the #N/A error indicator indicate in a lookup function?

• Data not found

• Invalid data type

• Circular reference

• Syntax error

Which feature is used for calculating the average, count, sum, min, and max of a range of data?

• Subtotal outline feature

• Pivot table

• Filter function

• Sort function

What is an example of a variation of a known function?

• Adding two numbers

• Rounding up and rounding down

• Multiplying two numbers

• Finding the square root

Which function is used for horizontal lookup?

• INDEX

• HLOOKUP

• MATCH

• VLOOKUP

What does the #N/A error indicator indicate in a lookup function?

• Data not found

• Syntax error

• Invalid data type

• Circular reference

Which feature is used for calculating the average, count, sum, min, and max of a range of data?

• Sort function

• Subtotal outline feature

• Filter function

• Pivot table

What is an example of a variation of a known function?

• Finding the square root

• Adding two numbers

• Rounding up and rounding down

• Multiplying two numbers