Question

List any three commonly used Excel functions and its purpose.

Answer 1

Answer ッ

• The SUM Function. The sum function is the most used function when it comes to computing data on Excel. ...
• The TEXT Function. Text function is a useful tool that helps convert a date (or number) into a text string in a particular format. ...
• The VLOOKUP Function

Answer 2

Explanation:

1. SUM

The SUM function is the first must-know formula in Excel. It usually aggregates values from a selection of columns or rows from your selected range.

=SUM(number1, [number2], …)

2. AVERAGE

The AVERAGE function should remind you of simple averages of data such as the average number of shareholders in a given shareholding pool.

=AVERAGE(number1, [number2], …)

3. COUNT

The COUNT function counts all cells in a given range that contain only numeric values.

=COUNT(value1, [value2], …)