Excel Functions and Formulas

This video tutorial covers basic math functions in Excel, including addition, subtraction, multiplication, division, exponents, and square roots. It also explains how to use Excel to calculate sums, averages, maximum and minimum values, range, standard deviation, and variance. Additionally, the video demonstrates how to evaluate trigonometric functions using Excel.

How can you add two numbers in Excel using cell references?

• Use the formula '=ADD(A1, B1)'

• Use the formula '=A1 + B1'

• Type in the numbers directly

• Use the formula '=SUM(A1, B1)'

What symbol is used for multiplication in Excel formulas?

• x

• *

• -

• /

How do you calculate the square root of a number in Excel?

• Use the formula '=SQRT(number)'

• Use the formula '=ROOT(number)'

• Use the formula '=SQUARE(number)'

• Use the formula '=POWER(number, 0.5)'

Which function is used to find the average of a range of numbers in Excel?

• SUM

• AVERAGE

• MEAN

• MEDIAN

What is the purpose of the MAX function in Excel?

• To find the minimum value in a range

• To calculate the average of a range

• To calculate the sum of a range

• To find the maximum value in a range

How do you calculate the range of a dataset in Excel?

• Multiply the maximum and minimum values

• Divide the maximum value by the minimum value

• Add the maximum and minimum values

• Subtract the minimum value from the maximum value

Which function would you use to calculate the standard deviation of a sample in Excel?

• STDEV.P

• STDEV.S

• VAR.S

• VAR.P

What is the correct way to calculate the sine of an angle in degrees using Excel?

• SIN(angle)

• SIN(angle * PI()/180)

• SIN(RADIANS(angle))

• SIN(DEGREES(angle))

If you want to find the cosine of 90 degrees in Excel, which formula should you use?

• COS(90)

• COS(RADIANS(90))

• COS(PI()/2)

• COS(DEGREES(90))

Why is it important to use radians when calculating trigonometric functions in Excel?

• Excel only accepts angles in degrees

• Radians provide more accurate results

• Excel's trigonometric functions default to radians

• Radians are easier to calculate manually