Excel Formulas and Functions

This video tutorial covers basic Excel operations, including addition, subtraction, multiplication, and division. It demonstrates how to use Excel as a calculator for direct calculations and perform operations with fractions. The tutorial also explains how to use exponents and roots in Excel, providing practical examples for each operation.

How can you add the values in cells A2 and B2 in Excel?

• Type 'SUM(A2, B2)'

• Type 'ADD(A2, B2)'

• Type 'A2 + B2'

• Type '=A2 + B2'

Which function would you use to find the total of an entire column in Excel?

• AVERAGE

• COUNT

• TOTAL

• SUM

What is the result of the formula '=A2 - B2' if A2 is 24 and B2 is 16?

• 8

• 20

• 10

• 18

How would you multiply the values in cells A4 and B4 in Excel?

• Type 'MULTIPLY(A4, B4)'

• Type 'A4 x B4'

• Type '=A4 * B4'

• Type 'A4 & B4'

If you want to multiply 7 and 6 directly in a cell, what formula would you use?

• 7 x 6

• =7 * 6

• 7 & 6

• MULTIPLY(7, 6)

What symbol is used for division in Excel formulas?

• -

• \

• /

• x

How can you use Excel as a calculator to divide 72 by 9?

• Type '=72 / 9'

• Type '72 - 9'

• Type '72 \ 9'

• Type 'DIVIDE(72, 9)'

Which function can be used to calculate 2 raised to the power of 3 in Excel?

• EXP(2, 3)

• POWER(2, 3)

• EXPO(2, 3)

• RAISE(2, 3)

How can you find the square root of 49 using Excel?

• 49 * 0.5

• POWER(49, 2)

• 49 ^ 2

• SQRT(49)

What is the cube root of 64 in Excel using the power function?

• 64 ^ 1/3

• POWER(64, 1/3)

• CUBE(64)

• 64 ^ 3