Useful Microsoft Excel Formulas and Functions Exam Questions with Verified Answers Latest Update
2024-2025 (Graded A+)
Allows to sum numerical data in any number of columns or rows by selecting them or typing them in. -
Answers SUM Function
Refers to a group or array of cells - Answers Range
Is used to summate the values of cells in a range that meet the criteria that have been specified. -
Answers SUMIF Function
Allows user to get the average of all the numbers in the chosen cells. - Answers AVERAGE Function
Is used to count the number of chosen cells that have a number value in them. - Answers COUNT
Function
Allows users to achieve a particular value if the condition has been satisfied or TRUE, or if the condition
has not been satisfied or FALSE. - Answers IF Function
It checks if certain conditions or criteria are true or false. - Answers AND Function
Enables users to find something on the leftmost column of the chosen range and return a value related
to it. - Answers VLOOKUP Function
This function combined two or more text strings. In other words, this function combines the values from
two or more cells into another cell. - Answers CONCATENATE Function
Is used to search for the highest value in an array. - Answers MAX Function
Is used to search for the lowest value in an array. - Answers MIN Function
Is a feature which limits what particular value can be entered in a cell. - Answers Data Validation
Is a way of getting data from spreadsheets or other similar structured data format and transferring them
to other documents such as letters and mailing labels. - Answers Mail Merge
2024-2025 (Graded A+)
Allows to sum numerical data in any number of columns or rows by selecting them or typing them in. -
Answers SUM Function
Refers to a group or array of cells - Answers Range
Is used to summate the values of cells in a range that meet the criteria that have been specified. -
Answers SUMIF Function
Allows user to get the average of all the numbers in the chosen cells. - Answers AVERAGE Function
Is used to count the number of chosen cells that have a number value in them. - Answers COUNT
Function
Allows users to achieve a particular value if the condition has been satisfied or TRUE, or if the condition
has not been satisfied or FALSE. - Answers IF Function
It checks if certain conditions or criteria are true or false. - Answers AND Function
Enables users to find something on the leftmost column of the chosen range and return a value related
to it. - Answers VLOOKUP Function
This function combined two or more text strings. In other words, this function combines the values from
two or more cells into another cell. - Answers CONCATENATE Function
Is used to search for the highest value in an array. - Answers MAX Function
Is used to search for the lowest value in an array. - Answers MIN Function
Is a feature which limits what particular value can be entered in a cell. - Answers Data Validation
Is a way of getting data from spreadsheets or other similar structured data format and transferring them
to other documents such as letters and mailing labels. - Answers Mail Merge
