Explain few useful functions in excel.
- 1 Answers
- 706 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Can I see a list of the colorindex and the corresponding color?
How do I make a cell on excel?
What is sum function?
How can we convert excel to word?
How do you use conditional formatting in excel?
How do I insert a cell in excel 2007?
How do I download microsoft excel?
How do you conduct a scenario analysis?
What it means to merge cells in a table?
How is a spreadsheet defined answer?
How do you delete specific text in excel?
How do I create a chart on excel with two sets of data?
MS Excel Microsoft 
