Mastering Excel Formulas

What formula would you use to add two numbers in Excel?

• =A1 * B1

• =TOTAL(A1, B1)

• =SUM(A1, B1) or =A1 + B1

• =ADD(A1, B1)

Which function calculates the total of a range of cells?

• COUNT

• MAX

• SUM

• AVERAGE

If you have the numbers 10 and 5, what formula would you use to subtract them in Excel?

• =10/5

• =SUBTRACT(10, 5)

• =10-5

• =5-10

What is the correct formula to divide 20 by 4 in Excel?

• =20-4

• =20/2

• =20/4

• =4/20

Which operator is used for multiplication in Excel?

• *

• %

• -

• /

What function would you use to find the average of a set of numbers in Excel?

• MAX

• AVERAGE

• SUM

• COUNT

How do you rank a list of numbers in Excel?

• Apply conditional formatting to highlight numbers.

• Sort the numbers manually in a column.

• Use the RANK function in Excel.

• Use the SUM function in Excel.

What is the purpose of the VLOOKUP function in Excel?

• To format cells with specific styles.

• To calculate the sum of a range of cells.

• To search for a value in a table and return a corresponding value from another column.

• To create a chart based on selected data.

Which formula would you use to add the values in cells A1 and A2?

• =A1 * A2

• =SUM(A1,A2)

• =A1 - A2

• =A1 + A2

If you want to subtract the value in cell B1 from A1, what formula would you use?

• =A1-B1

• =A1*B1

• =A1+B1

• =B1-A1