Excel Fun for Students

What is the formula to add two numbers in Excel?

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

• =A1 - B1

• =MULTIPLY(A1, B1)

• =AVERAGE(A1, B1)

How do you create a chart in Excel?

• Select data, go to 'Insert' tab, choose chart type.

• Go to 'View' tab and select 'Zoom'

• Right-click on the data and choose 'Delete'

• Click on 'File' and select 'New'

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

• average()

• sum()

• total()

• mean()

Which chart type is best for showing parts of a whole?

• Pie chart

• Bar chart

• Scatter plot

• Line chart

What is the formula for subtracting one number from another in Excel?

• =A1-B1

• =A1+B1

• =A1*B1

• =SUBTRACT(A1, B1)

How can you change the color of a chart in Excel?

• Select the chart, go to the 'Format' tab, and choose 'Shape Fill' or 'Chart Styles'.

• Use the 'Insert' tab to add a new chart style.

• Right-click the chart and select 'Delete' to remove it.

• Change the color by adjusting the monitor settings.

What function would you use to count the number of cells with numbers?

• MAX

• SUM

• AVERAGE

• COUNT

What type of graph is best for showing trends over time?

• Line graph

• Bar graph

• Pie chart

• Histogram

How do you create a pie chart in Excel?

• Select data, go to 'Insert' > 'Pie Chart', choose style.

• Highlight data, click on 'Data' > 'Chart Options', select pie.

• Select data, go to 'File' > 'New Chart', choose type.

• Choose data, navigate to 'View' > 'Chart Types', pick a pie chart.

What formula would you use to multiply two numbers in Excel?

• =A1*B1

• =A1+B1

• =A1/B1

• =MULTIPLY(A1,B1)