Excel Basics for Young Learners

What formula do you use to add numbers in Excel?

• =SUMMARIZE()

• =TOTAL()

• =SUM()

• =ADD()

How do you find the average of a set of numbers in Excel?

• Use the SUM function, e.g., =SUM(A1:A10).

• Calculate the median using =MEDIAN(A1:A10).

• Count the numbers with =COUNT(A1:A10).

• Use the AVERAGE function, e.g., =AVERAGE(A1:A10).

Which symbol is used for subtraction in Excel formulas?

• /

• +

• -

• *

What function would you use to count how many cells have numbers?

• COUNT

• MAX

• SUM

• AVERAGE

How do you multiply two numbers in Excel?

• Select A1 and B1, then click 'Add' in the toolbar.

• Use =A1+B1 in a cell.

• Type A1*B1 in the formula bar.

• Use =A1*B1 or =PRODUCT(A1, B1) in a cell.