Math Functions

Question 1

sequence function

Answer 1

allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4.

Question 2

e date

Answer 2

EDATE(start_date, months)

The EDATE function syntax has the following arguments:

Start_date Required. A date that represents the start date. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

Months Required. The number of months before or after start_date. A positive value for months yields a future date; a negative value yields a past date.

Question 3

filter

Answer 3

The FILTER function allows you to filter a range of data based on criteria you define.

=FILTER(A5:D20,C5:C20=H2,””) to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string (“”).

Question 4

count function

Answer 4

if you want to get a quite count of number of observations in a column, use the count function

COUNT(value1, [value2], …)

Question 5

min and max functions

Answer 5

find the smallest or largest number in an array

MIN(number1, [number2], …)
MAX(number1, [number2], …)

Question 6

sum function

Answer 6

The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.

For example:

=SUM(A2:A10) Adds the values in cells A2:10.