N5 Basic Excel Spreadsheet Formulas

Which of the following Excel formulas would correctly add the values in cells A1 and B1?

• =A1+B1

• =SUM(A1:B1)

• =ADD(A1,B1)

• =PLUS(A1,B1)

What is the correct formula to find the minimum value in the range C1:C10?

• =MINIMUM(C1:C10)

• =SMALL(C1:C10,1)

• =MIN(C1:C10)

• =LOWEST(C1:C10)

In Excel, which formula would you use to count the number of cells in range D1:D20 that contain numerical values?

• =SUM(D1:D20)

• =COUNTA(D1:D20)

• =COUNT(D1:D20)

• =COUNTIF(D1:D20,"*")

Which of the following is the correct symbol for multiplying the values in cells B5 and C5?

• =B5xC5

• =B5*C5

• =MULTIPLY(B5,C5)

• =PRODUCT(B5:C5)

What formatting option would you use to make text visible when it's too long to fit in a cell?

• Auto-fit

• Text alignment

• Wrap text

• Shrink to fit

Which formula would correctly calculate the average of values in cells A1, A2, and A3?

• =AVERAGE(A1,A2,A3)

• =MEAN(A1:A3)

• =SUM(A1:A3)/3

• =(A1+A2+A3)/COUNT(A1:A3)

What is the correct formula to subtract the value in cell B2 from the value in cell A2?

• =SUBTRACT(A2,B2)

• =MINUS(A2,B2)

• =A2-B2

• =DIFFERENCE(A2,B2)

What formula would you use to find the maximum value in the range A1:A10?

• =MAXIMUM(A1:A10)

• =LARGEST(A1:A10,1)

• =MAX(A1:A10)

• =HIGHEST(A1:A10)

Which function would you use to divide the value in cell C3 by the value in cell D3?

• =C3/D3

• =DIVIDE(C3,D3)

• =QUOTIENT(C3,D3)

• =C3÷D3

Which formatting option would you use to display numbers as £1,000.00 instead of 1000?

• Number format

• Currency format

• Accounting format

• Custom format