Mastering Spreadsheet Essentials

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

• `=A1+A2`

• `=SUM(A1:A2)`

• `=ADD(A1,A2)`

• `=A1-A2`

Which of the following is a basic formula to subtract the value in cell B2 from B1?

• `=B1+B2`

• `=B1-B2`

• `=SUBTRACT(B1,B2)`

• `=B2-B1`

How do you multiply the values in cells C1 and C2?

• `=C1*C2`

• `=MULTIPLY(C1,C2)`

• `=C1+C2`

• `=C1/C2`

What is the formula to divide the value in cell D1 by D2?

• `=D1*D2`

• `=D1-D2`

• `=D1/D2`

• `=DIVIDE(D1,D2)`

Which function would you use to find the average of cells E1 to E5?

• `=SUM(E1:E5)`

• `=AVERAGE(E1:E5)`

• `=MEAN(E1:E5)`

• `=MEDIAN(E1:E5)`

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

• Change the font

• Use the currency format option

• Use the percentage format option

• Use the text format option

Which of the following is a function to find the maximum value in a range of cells?

• `=MIN()`

• `=MAX()`

• `=LARGEST()`

• `=HIGHEST()`

What is the function to count the number of cells that contain numbers in a range?

• `=COUNT()`

• `=COUNTA()`

• `=COUNTIF()`

• `=COUNTBLANK()`

How do you apply bold formatting to a cell?

• Use the italic button

• Use the underline button

• Use the bold button

• Use the strikethrough button

Which function would you use to find the smallest number in a range?

• `=MIN()`

• `=MAX()`

• `=SMALLEST()`

• `=LOWEST()`