Excel

Which symbol is used for addition in Excel formulas?

• /

• *

• +

• -

If cell A1 contains 10 and cell B1 contains 5, what formula would you use to subtract B1 from A1?

• =A1-B1

• =B1-A1

• =A1+B1

• =A1*B1

How would you write a formula to multiply the values in cells C1 and D1?

• =C1+D1

• =C1/D1

• =C1*D1

• =C1-D1

What formula is used to divide the value in cell E1 by the value in cell F1?

• =E1/F1

• =E1*F1

• =E1+F1

• =E1-F1

Which function would you use to find the largest number in a range of cells?

• =MAX(range)

• =MIN(range)

• =SUM(range)

• =LARGE(range)

What does the formula =MIN(A1:A10) return?

• The largest value in the range

• The average value of the range A1 to A10.

• The smallest value in the range A1 to A10.

• The total sum of the range A1 to A10.

If you want to calculate the average of numbers in cells A1 through A5, which formula should you use?

• =AVERAGE(A1:A5)

• =SUM(A1:A5)/COUNT(A1:A5)

• Both a and b

• None of the above

Which of the following is NOT a valid function in Excel?

• =SUM(range)

• =DIVIDE(range)

• =MAX(range)

• =AVERAGE(range)

If you want to calculate the total of cells A1, B1, and C1, which formula would you use?

• =A1+B1+C1

• =TOTAL(A1:C1)

• =SUM(A1:B1:C1)

• =ADD(A1:C1)

If cell A1 contains 50, cell A2 contains 20, and cell A3 contains 30, what would =AVERAGE(A1:A3) return?

• 100

• 33.33

• 50

• 25