Mastering Spreadsheet Formulas Quiz

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

• =SUM(A1+B1)

• =ADD(A1:B1)

• =ADD(A1,B1)

• =A1-B1

Which function would you use to find the average of the numbers in cells C1 to C5?

• =SUM(C1:C5)

• =AVERAGE(C1:C5)

• =AVG(C1:C5)

• =AVERAGE(C1+C5)

If you want to subtract the value in cell D2 from the value in cell D1, which formula would you use?

• =SUBTRACT(D1-D2)

• =D1*D2

• =D1-D2

• =D2-D1

How would you divide the value in cell E1 by the value in cell E2?

• =E1*E2

• =E1/E2

• =DIVIDE(E1:E2)

• =DIVIDE(E1-E2)

Which function returns the smallest number in a range of cells from F1 to F10?

• =MAX(F1:F10)

• =MIN(F1:F10)

• =MIN(F1-F10)

• =MINIMUM(F1:F10)

What is the result of the formula `=MAX(G1:G5)` if the values in G1 to G5 are 3, 7, 2, 9, and 5?

• 3

• 7

• 9

• 5

In a spreadsheet, what is a cell reference?

• A function that calculates the sum of a range

• A unique identifier for a cell, such as A1 or B2

• A formula that divides two numbers

• A method to format text

What is the term for a vertical group of cells in a spreadsheet?

• Row

• Column

• Cell

• Range

Which formula would you use to add all the numbers in a column from H1 to H10?

• `=ADD(H1:H10)`

• `=SUM(H1:H10)`

• `=H1+H10`

• `=AVERAGE(H1:H10)`

What is the formula to calculate the average of the values in cells I1, I2, and I3?

• `=SUM(I1:I3)/3`

• `=AVERAGE(I1:I3)`

• `=I1+I2+I3`

• `=MIN(I1:I3)`