Answer Posted / Tinu Kumar
1. SUM(range): Adds up all the numbers in a range of cells.
2. AVERAGE(range): Calculates the average of a range of cells.
3. COUNT(range): Counts the number of cells with numeric values in a range.
4. IF(logical_test, value_if_true, value_if_false): Performs a logical test and returns one of two possible results.
5. VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]): Searches for a specific value in the first column of a table array and returns a corresponding value from another specified column.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
