Excel Formulas Knowledge Check

Front

Which of the following formulas correctly adds the values in cells A1 and B1 in Excel?
Options:
`=A1 + B1`,
`=SUM(A1, B1)`,
`=ADD(A1, B1)`,
`=A1 & B1`

Back

`=A1 + B1`

Front

In Excel, what is the result of the formula `=10 - 2 * 3`?

Back

4

Front

Which formula correctly multiplies the values in cells C1 and D1 and then divides by 2? Options: `=C1 * D1 / 2`, `=C1 * (D1 / 2)`, `=(C1 * D1) / 2`, `=C1 / D1 * 2`

Back

`=(C1 * D1) / 2`

Front

What is the purpose of using parentheses in Excel formulas?

Back

To change the order of operations

Front

How can you apply currency formatting to a cell using the Excel toolbar?

Back

Click on the "Home" tab and select "Currency" from the "Number" group

Front

Which of the following formulas correctly calculates the average of the values in cells E1, E2, and E3? Options: `=AVERAGE(E1, E2, E3)`, `=SUM(E1, E2, E3) / 3`, `(E1 + E2 + E3) / 3`, All of the above

Back

All of the above

Front

What is the result of the formula `=(5 + 3) * 2` in Excel?

Back

16

Front

Which of the following is NOT a valid way to apply currency formatting in Excel? Using the "Format Cells" dialog box, Using the "Currency" button on the toolbar, Typing "$" before the number in the cell, Using the "Format" menu and selecting "Currency"

Back

Typing "$" before the number in the cell

Front

In Excel, what does the formula `=A1 * (B1 + C1)` calculate?

Back

The sum of B1 and C1, then multiply by A1

Front

Which formula correctly subtracts the value in cell F2 from the value in cell F1? Options: `=F1 - F2`, `=SUBTRACT(F1, F2)`, `=F2 - F1`, `=DIFFERENCE(F1, F2)`

Back

`=F1 - F2`