Microsoft Excel (Range)

True/ False? The sum function is easier to use when your'e working with more than a few numbers.

(a)  

The (a)   function returns the smallest numeric value in the data provided.

The (a)   function in Excel is the simplest form of a mathematical function, which just returns the maximum values out of the selected values or array.

Which of the following formulas below illustrates the correct function to create the Sum (Range)?

• =SUM(

• =SUM(Range)

• SUM=(Range)

The first formula range when creating formulas in Excel is called an?

• Argument

• Cell

• Range

• parenthesis

(a)   function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution. ​

_____ (Range) function in Excel returns the number of cells that contain numbers in a given range.

• COUNTA

• COUNT

• COUNTBLANK

• COUNTIFS

True/False? You can also use other functions to count different types of values in a range.

(a)  

 ______ counts all values in a range, including numbers and text​?

• COUNTBLANK (Range)

• COUNTIFS (Range. Criteria)

• COUNT (Range)

• COUNTA (Range)

Write down the format used to create the MAX formula in Excel below.

(a)