Excel Formula

What symbol must be at the beginning of every formula you write in a spreadsheet?

=SUM(A1,A3,A4)

What is the purpose of this formula?

• To add up the values referenced inside the brackets.

• To multiply the values referenced inside the brackets

• To compare the values referenced inside the brackets.

• To find a value in the cells referenced inside the brackets.

=ROUND(AVERAGE(B2:B7), 0)

Select all statements that apply.

[Maximum: 3]

• This formula includes cell referencing

• This formula will find the mean number in the range selected.

• This formula will round the answer to 2 decimal places.

• The formula will produce a whole number as an answer. 

Which formulas below will count the number of items with a cost above £1.50?

• =COUNT(IF(B2>1.5))

• COUNTIF(B2-B7, >1.5)

• =COUNTIF(B2:B7, ">1.5")

• COUNTIF(B2:B7, ">1.5")

=ROUND(A1*$C$3, 2)

Select all that apply.

[Maximum: 2]

• This formula includes absolute referencing

• This formula will add the values in the two cells.

• This formula will round the answer to 2 decimal places.

• The formula will produce a whole number as an answer. 

Write a formula to find calculate the total stock level in the bakery for all of its products combined.

Your formula MUST include cell references.

Which mathematical function does the symbol below represent?

*

• To the Power of

• Multiplication

• Division

Which mathematical function does the symbol below represent?

/

• To the Power of

• Multiplication

• Division

Which mathematical function does the symbol below represent?

^

• To the Power of

• Multiplication

• Division

Which of the formula's would correctly output Yes/No in column D.

• =IF(D2 < 10) "Yes", "No"

• =IF(D2 < 10, "Yes", "No")

• =IF(D2 > 10, "Yes", "No")

• IF(D2 > 10, "Yes", "No")