Excel prior learning y8

What is the function used to add up a range of cells in Excel?

• =SUM

• =COMBINE

• =TOTAL

• =ADD

Which symbol is used for multiplication in Excel formulas?

• !

• ÷

• x

• *

Which tool in Excel is used to format cells as currency?

• Currency Tool

• Format Cells

• Cell Formatter

• Excel Format

What is the formula to sum the values in cells A1 to A10 in Excel?

• =ADD(A1:A10)

• =TOTAL(A1:A10)

• =SUM(A1,A10)

• =SUM(A1:A10)

Which symbol is used for division in Excel formulas?

• %

• /

• x

• -

Which formula would you use to divide cell A1 from B1?

• =B1/A1

• =A1/B1

• =A1%B1

• =B1\A1

What is the formula to calculate the total sales amount in cells B1 to B10 in Excel?

• =AVERAGE(B1:B10)

• =COUNT(B1:B10)

• =MAX(B1:B10)

• =SUM(B1:B10)

What formula would you use to add cells B34 and C23 together?

• =B23+C34

• =Sum(C2:B34)

• =C23/B34

• =B34+C23

What is the formula to calculate the difference between of A1 from A3?

• =Sum(A3:A1)

• =A3-A1

• =A1-A3

• =A1/A3