Question

list the helpful functions of ms excel in weather forecast( please answer in points)

Answer 1

TEXT function
TEXT(value, format_text) is used to convert a
number or a date into a test string in the
specified format,

CONCATENATE function
CONCATENATE(text1, [text2], …) is designed to
join several pieces of text together or combine
values from several cells into a single cell

TRIM(text) removes leading, trailing spaces as
well as excess spaces between words.

SUBSTITUTE(text, old_text, new_text, [instance_
num]) replaces one set of characters with
another in a specified cell or a text string.
VALUE function
VALUE(text) - converts a text string to a number.

EXACT function
EXACT(text1, text2) compares two text strings
and returns TRUE if both values are exactly the
same, including case, FALSE otherwise.

Answer 2

The syntax for the FORECAST function in Microsoft Excel is:

FORECAST( x-value, known_y_values, known_x_values )
Parameters or Arguments

x-value
The x-value used to predict the y-value.
known_y_values
The known y-values used to predict the y-value.
known_x_values
The known x-values used to predict the y-value.
Returns

The FORECAST function returns a numeric value.
If x-value is not a numeric value, the FORECAST function will return the #VALUE! error.
If known_y_values and known_x_values contain different numbers of elements, the FORECAST function will return the #N/A error.

Applies To

Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000