Year 5 - Unit 4 Quiz - Exploring Spreadsheet

What would be a correct formula for SUM in excel?

• =ADD(B3:B9)

• SUM(B3:B9)

• 
  =SUM(B3:B9)

• =AUTOSUM(B3:B9)

Which formula gets the biggest value of a range of cells?

• LARGE

• MAX

• COUNT

• MIN

Which symbol must all formula begin with?

• -

• @

• (

• =

What does the Countif formula return?

• Count the number of cells that contain numbers (value)

• Biggest amount

• Smallest amount

• Rate

Which operator is used to multiply in Excel?

• \

• *

• +

• -

For dividing numbers in A1 AND B1, you use the following formula

• =A1\B1

• A!\B1

• =A1/B1

• =A/B

Which button allows you to 'Sort & Filter' the data in Excel?

• A

• B

• C

• D

Which tab has the function to insert 'Charts' in Excel?

• A

• B

• C

• D

What type of chart is this?

• Pie chart

• Line chart

• Bar chart

• Column chart

Which of the following formulas is not entered correctly?

• =B3-B4

• =25+37

• =95x6

• =15/F2