Excel Functions and BODMAS Quiz

Which Excel function would you use to find the smallest value in a list of numbers?

• =MAX

• =MIN

• =SUM

• =AVERAGE

What does the acronym BODMAS stand for in mathematical operations?

• Brackets, Order, Division, Multiplication, Addition, Subtraction

• Brackets, Order, Division, Multiplication, Addition, Summation

• Brackets, Order, Division, Multiplication, Addition, Synthesis

• Brackets, Order, Division, Multiplication, Algebra, Subtraction

If you want to combine two cells into one larger cell in Excel, which feature should you use?

• Merge and Centre

• Borders

• Shading

• Wrap Text

Which Excel function would you use to calculate the total of a range of numbers?

• =MIN

• =MAX

• =SUM

• =AVERAGE

In Excel, which option allows you to add a coloured background to a cell?

• Borders

• Shading

• Merge and Centre

• Wrap Text

• 24

• 12

• 18

• 12

Which Excel function would you use to find the average value of a group of numbers?

• =SUM

• =MAX

• =MIN

• =AVERAGE

If you want to add a border around a cell in Excel, which feature should you use?

• Merge and Centre

• Borders

• Shading

• Sort

Which of the following formulas correctly adds the values in cells A1, A2, and A3 in Excel?

• =SUM(A1:A3)

• =ADD(A1,A2,A3)

• =TOTAL(A1,A2,A3)

• =PLUS(A1:A3)

If you want to centre the contents of a cell both horizontally and vertically, which Excel feature should you use?

• Merge and Centre

• Borders

• Shading

• Wrap Text