2. Formulas & Function in Excel 2021

The _______ function calculates the total of a given set of values.

• SUM
• AVERAGE
• COUNT
• MAX

The ______ function checks a condition to evaluate True or False.

• IF
• CHECK
• EVALUATE
• ASSERT

________ means arranging data in ascending or descending order.

• Sorting
• Searching
• Filtering
• Grouping

_____ means to see important data and hide the rest in excel.

• Filtering
• Sorting
• Pivoting
• Merging

A formula in excel begins with an ________

• =
• A
• 1
• X

_________ are used for graphical representation of data.

• Tables
• Charts
• Paragraphs
• Equations

A group of selected cells is called a __________.

• Array
• Range
• Matrix
• Cluster

A ______ is a predefined formula in Excel.

• Function
• Cell
• Worksheet
• Workbook

Which of the following error occurs when the formula is not recognised by excel?

• Value Error
• Name Error
• Div/0 Error
• Num Error

_______ function returns the largest value in a range.

• MIN
• AVG
• SUM
• MAX