Excel Basics for Young Learners

How do you create a table in MS Excel?

• Select data range, go to 'Insert' tab, click 'Table', confirm range, click 'OK'.

• Select data range, go to 'Home' tab, click 'Copy', paste into a new sheet.

• Select data range, go to 'File' tab, click 'New', confirm range, click 'Save'.

• Highlight cells, right-click, choose 'Format Cells', select 'Table', click 'Apply'.

What formula do you use to find the total of numbers?

• Total = a1 / a2 / a3 / ... / an

• Total = a1 - a2 - a3 - ... - an

• Total = a1 + a2 + a3 + ... + an

• Total = a1 * a2 * a3 * ... * an

If you have the numbers 5, 10, and 15, what is their sum?

• 30

• 35

• 20

• 25

What formula do you use to find the largest number?

• sum(a1, a2, ..., an)

• average(a1, a2, ..., an)

• min(a1, a2, ..., an)

• max(a1, a2, ..., an)

If you have the numbers 3, 7, and 2, what is the maximum value?

• 5

• 2

• 7

• 3