Excel Basics for Young Learners

What is the formula to add two numbers in Excel?

• =SUM(A1, B1) or =A1 + B1

• =A1 * B1

• =ADD(A1, B1)

• =TOTAL(A1, B1)

How do you subtract one cell from another in Excel?

• Use the formula '=A1+B1' to add cell A1 and B1.

• Click on cell A1 and press the 'Delete' key to remove its value.

• Right-click on cell A1 and select 'Copy' to duplicate its value.

• Use the formula '=A1-B1' to subtract cell B1 from A1.

What function would you use to find the average of a set of numbers?

• mean()

• sum()

• total()

• average()

What is the formula to multiply two cells in Excel?

• =MULTIPLY(A1,B1)

• =A1+B1

• =A1/B1

• =A1*B1

How do you create a formula that divides one cell by another?

• =A1+B1

• =A1*B1

• =A1-B1

• =A1/B1

What function would you use to find the maximum value in a range?

• MIN

• MAX

• AVERAGE

• SUM

How can you use the SUM function in Excel?

• The SUM function is used to create charts in Excel.

• You can use the SUM function in Excel to add a range of numbers.

• You can use the SUM function to delete rows in Excel.

• You can use the SUM function to format text in Excel.

What should my cursor look like when I am using AutoFill?

• Thin Black Plus Sign

• Thick White Plus Sign

• Green Rectangle

• White Arrow

All formulas in Excel begin with what?

• Mathematical Function

• Parenthesis

• Equal Sign

• Cell Choice

To format numbers as money, you would choose what?

• Numbers

• General

• Currency

• Increase Decimals