Excel Basics: Formulas and Formatting

What is the formula to add the values in cells A1 and B1 in Excel?

• `=A1+B1`

• `=SUM(A1:B1)`

• `=ADD(A1, B1)`

• `=A1&B1`

How do you subtract the value in cell B2 from the value in cell A2?

• `=A2-B2`

• `=SUBTRACT(A2, B2)`

• `=B2-A2`

• `=A2/B2`

Which formula multiplies the values in cells C1 and D1?

• `=C1*D1`

• `=MULTIPLY(C1, D1)`

• `=C1+D1`

• `=C1/D1`

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

• `=E1/F1`

• `=DIVIDE(E1, F1)`

• `=E1*F1`

• `=F1/E1`

How can you format a cell to display numbers as currency in Excel?

• Use the "Number" format

• Use the "Currency" format

• Use the "Text" format

• Use the "General" format

How do you apply a border to a cell in Excel?

• Use the "Fill" option

• Use the "Font" option

• Use the "Borders" option

• Use the "Alignment" option

Which formula would you use to add up all the values in a column from A1 to A10?

• `=ADD(A1:A10)`

• `=SUM(A1:A10)`

• `=TOTAL(A1:A10)`

• `=A1+A10`

What is the result of the formula `=10-3` in Excel?

• 7

• 13

• 3

• 10

How can you change the background colour of a cell in Excel?

• Use the "Font" option

• Use the "Fill Colour" option

• Use the "Borders" option

• Use the "Alignment" option

What is the result of the formula `=8/2` in Excel?

• 4

• 6

• 2

• 8