Excel end of topic quiz Y6

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

• `=A1+A2`

• `=SUM(A1:A2)`

• `=ADD(A1,A2)`

• `=TOTAL(A1,A2)`

Which function would you use to find the average of the numbers in cells B1 to B5?

• `=SUM(B1:B5)`

• `=AVERAGE(B1:B5)`

• `=MEAN(B1:B5)`

• `=MEDIAN(B1:B5)`

How do you start a formula in Excel?

• With a plus sign (+)

• With an equal sign (=)

• With a minus sign (-)

• With a colon (:)

What is the function to find the largest number in a range of cells from C1 to C10?

• `=LARGE(C1:C10)`

• `=MAXIMUM(C1:C10)`

• `=MAX(C1:C10)`

• `=BIGGEST(C1:C10)`

The 'net' profit is a reflection of...

• Your 'gross' income minus your expenditure (what you've spent)

• The money taken from sales

• Shipping plus VAT

• The largest number in a range of cells

If you want to multiply the values in cells E1 and E2, which formula would you use?

• `=E1*E2`

• `=MULTIPLY(E1,E2)`

• `=PRODUCT(E1,E2)`

• `=E1xE2`

What is Information?

• Raw facts and figures

• Data that has been organised and turned into something meaningful

• `=SMALL(F1:F10)`

• A collection of cells

Conditional Formatting allows you to....

• Change cell formulas depending on a set of rules

• Change the formatting of a cell dependant on a set of given rules. e.g cell colour

• Calculate the gross and net profit of a spreadsheet

• Create data